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
TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
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.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
Worth adding
TM1.ODBC=DEBUG
TM1.SQLAPI=DEBUG
to tm1s-log.properties to see if maybe there's anything coming back.
Cheers
-
- Community Contributor
- Posts: 148
- Joined: Tue Apr 02, 2013 1:41 pm
- OLAP Product: tm1, cognos bi
- Version: from TM1 9.4 to PA 2.0.9.6
- Excel Version: 2010
- Location: Toronto, ON
Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Hey,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
We are experiencing the same issue after upgrading to PA 2.0.9.2
Did you guys found any solution?
Thanks
Ardian Alikaj
- mce
- Community Contributor
- Posts: 352
- Joined: Tue Jul 20, 2010 5:01 pm
- OLAP Product: Cognos TM1
- Version: Planning Analytics Local 2.0.x
- Excel Version: 2013 2016
- Location: Istanbul, Turkey
Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Upgrading Oracle Client to Oracle 12 solves the problem. PA 2.0.9.1 does not seem to support older Oracle client versions.
-
- Community Contributor
- Posts: 148
- Joined: Tue Apr 02, 2013 1:41 pm
- OLAP Product: tm1, cognos bi
- Version: from TM1 9.4 to PA 2.0.9.6
- Excel Version: 2010
- Location: Toronto, ON
Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
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
Ardian Alikaj