Page 1 of 1
TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Posted: Mon Jul 13, 2020 1:19 pm
by mce
Hello,
We upgraded from 2.0.7 to 2.0.9.1 in a test environment for one of our clients.
But TM1 server keeps crashing immediately when we execute TM1 processes connecting to Oracle DB via ODBC. Not only when executing the process, it crashes even when opening such processes in Architect. It happens in all such processes regardless of the SQL Query.
This is the last message seen in TM1 server log, before TM1 server dies.
2388 [2] DEBUG 2020-07-13 13:42:45.797 TM1.SQLAPI Doing SQLConnectW( "XXXXXX", "xxxxxxxx" )
Thanks in advance for all responses.
Regards
Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Posted: Tue Jul 14, 2020 1:57 am
by ykud
mce wrote: ↑Mon Jul 13, 2020 1:19 pm
Hello,
We upgraded from 2.0.7 to 2.0.9.1 in a test environment for one of our clients.
But TM1 server keeps crashing immediately when we execute TM1 processes connecting to Oracle DB via ODBC. Not only when executing the process, it crashes even when opening such processes in Architect. It happens in all such processes regardless of the SQL Query.
This is the last message seen in TM1 server log, before TM1 server dies.
2388 [2] DEBUG 2020-07-13 13:42:45.797 TM1.SQLAPI Doing SQLConnectW( "XXXXXX", "xxxxxxxx" )
Thanks in advance for all responses.
Regards
OS? We saw something similar on RedHat when oracle driver couldn't write to it's log and sent a message about it to TM1. And that 'i cannot write to my log' warning message from unixodbc was crashing TM1 server. Adding a log folder or fixing permissions for this log made the error go away.
Worth adding
TM1.ODBC=DEBUG
TM1.SQLAPI=DEBUG
to tm1s-log.properties to see if maybe there's anything coming back.
Cheers
Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Posted: Fri Oct 16, 2020 9:20 pm
by ardi
mce wrote: ↑Mon Jul 13, 2020 1:19 pm
Hello,
We upgraded from 2.0.7 to 2.0.9.1 in a test environment for one of our clients.
But TM1 server keeps crashing immediately when we execute TM1 processes connecting to Oracle DB via ODBC. Not only when executing the process, it crashes even when opening such processes in Architect. It happens in all such processes regardless of the SQL Query.
This is the last message seen in TM1 server log, before TM1 server dies.
2388 [2] DEBUG 2020-07-13 13:42:45.797 TM1.SQLAPI Doing SQLConnectW( "XXXXXX", "xxxxxxxx" )
Thanks in advance for all responses.
Regards
Hey,
We are experiencing the same issue after upgrading to PA 2.0.9.2
Did you guys found any solution?
Thanks
Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Posted: Sat Oct 17, 2020 11:26 pm
by mce
Upgrading Oracle Client to Oracle 12 solves the problem. PA 2.0.9.1 does not seem to support older Oracle client versions.
Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Posted: Mon Oct 19, 2020 11:33 pm
by ardi
mce wrote: ↑Sat Oct 17, 2020 11:26 pm
Upgrading Oracle Client to Oracle 12 solves the problem. PA 2.0.9.1 does not seem to support older Oracle client versions.
Thank you!
We managed to find an ODBC driver that works but that is not a Native Oracle driver and it does not support some SQL statement (does not support Transaction COMMIT / ROLLBACK)
This issue is also reported at IBM since 2018 but IBM as usually says this is an Oracle issue not a TM1 issue
Very frustrating