Page 1 of 1
Region Problem After PA Migration
Posted: Tue Dec 10, 2019 8:35 pm
by Jorge Rachid
Hi guys,
We have migrated TM1 version 10.2.1 to Planning Analytics and am facing problem on TI process that uses odbcoutput.
It only works (using client) when the country and format of Windows is United States. If I chance the format to Portuguese (which is my case), the process does not work - the process uses a cube view of source (not a .csv file).
Does anyone know what could be hapenning? It might be the instalation of tm1 on server or a client problem?
On server the region and country is also on United States. If I change this configuration on client the process does not run anymore.
Please any helps?
Kind regards,
JR
Re: Region Problem After PA Migration
Posted: Tue Dec 10, 2019 8:46 pm
by tomok
Error log????? tm1server.log??? What do they say?
Re: Region Problem After PA Migration
Posted: Wed Dec 11, 2019 11:59 am
by Jorge Rachid
tomok wrote: ↑Tue Dec 10, 2019 8:46 pm
Error log????? tm1server.log??? What do they say?
Hi tomok, yes, we do have a log, but it didin't say much:
"Data Source line (1) Error: Data procedure line (12): Error executing SQL query: "..." "
As I have said, when we change the region configuration of windows it works.
Thanks!
Re: Region Problem After PA Migration
Posted: Wed Dec 11, 2019 12:30 pm
by orlando
Jorge Rachid wrote: ↑Wed Dec 11, 2019 11:59 am
As I have said, when we change the region configuration of windows it works.
We had region problems with TM1Web with PA 2.06 - with PA 2.08 everythink works fine
Which PA Version are u using?
Did you ask the IBM Helpdesk?
Re: Region Problem After PA Migration
Posted: Wed Dec 11, 2019 12:59 pm
by Jorge Rachid
Hi Orlando, the version is 2.0.8.
Maybe it could be something about the instalation, I don't know.
I didn't ask IBM support because I am waiting the company that did the migration in the company that I work.
Thanks!
orlando wrote: ↑Wed Dec 11, 2019 12:30 pm
Jorge Rachid wrote: ↑Wed Dec 11, 2019 11:59 am
As I have said, when we change the region configuration of windows it works.
We had region problems with TM1Web with PA 2.06 - with PA 2.08 everythink works fine
Which PA Version are u using?
Did you ask the IBM Helpdesk?
Re: Region Problem After PA Migration
Posted: Wed Dec 11, 2019 1:34 pm
by tomok
Jorge Rachid wrote: ↑Wed Dec 11, 2019 11:59 am
tomok wrote: ↑Tue Dec 10, 2019 8:46 pm
Error log????? tm1server.log??? What do they say?
Hi tomok, yes, we do have a log, but it didin't say much:
"Data Source line (1) Error: Data procedure line (12): Error executing SQL query: "..." "
As I have said, when we change the region configuration of windows it works.
Thanks!
That error message doesn't tell you much???? Are you kidding? With that little nugget of information I can tell that the SQL compiler is having an issue with the SQL string TM1 is sending via the ODBCOUTPUT command. The next step here is to put in an ASCIIOUTPUT command just before to write out the SQL string to a file so you can see exactly what TM1 is sending. Chances are the differences in the regional settings handling of commas for numerical values, or accent characters, or something along those lines is the culprit. For all the readers of this post: when you are asking for help on a TI process and there is an error message from TM1 please post it along with your question. There is a reason why the programmers included error reporting in TM1, to help you determine what went wrong. Is it perfect? No, but without it we would all be completely lost.
Re: Region Problem After PA Migration
Posted: Thu Dec 12, 2019 8:07 pm
by Jorge Rachid
I understand.
Even doing this I already know where the problem is, but I don't know how to solve.
The problem is that process understands the number on this format: 1,000.00
But in reality the number is on this format: 1.000,00. It only works when I change my region/area configuration of windows.
Because of that we face the error doing the odbcoutput.
Thanks.
tomok wrote: ↑Wed Dec 11, 2019 1:34 pm
Jorge Rachid wrote: ↑Wed Dec 11, 2019 11:59 am
tomok wrote: ↑Tue Dec 10, 2019 8:46 pm
Error log????? tm1server.log??? What do they say?
Hi tomok, yes, we do have a log, but it didin't say much:
"Data Source line (1) Error: Data procedure line (12): Error executing SQL query: "..." "
As I have said, when we change the region configuration of windows it works.
Thanks!
That error message doesn't tell you much???? Are you kidding? With that little nugget of information I can tell that the SQL compiler is having an issue with the SQL string TM1 is sending via the ODBCOUTPUT command. The next step here is to put in an ASCIIOUTPUT command just before to write out the SQL string to a file so you can see exactly what TM1 is sending. Chances are the differences in the regional settings handling of commas for numerical values, or accent characters, or something along those lines is the culprit. For all the readers of this post: when you are asking for help on a TI process and there is an error message from TM1 please post it along with your question. There is a reason why the programmers included error reporting in TM1, to help you determine what went wrong. Is it perfect? No, but without it we would all be completely lost.
Re: Region Problem After PA Migration
Posted: Thu Dec 19, 2019 5:00 am
by EvgenyT
Check your ODBC driver setting
"Use regional settings when outputting currency, numbers, dates and times" if checked, I think it will override your numbers will the local server setting.
Cheers
Evgeny