Region Problem After PA Migration

[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

[tomok]

Error log????? tm1server.log??? What do they say?

[Jorge Rachid]

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!

[orlando]

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?

[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!

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?

[tomok]

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.

[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.

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.

[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