Cognos TM1 & SQL: What you gonna do if TI failed ODBCclose?
Posted: Thu Nov 14, 2013 2:22 pm
Hello, community!
When we use ODBCopen/ODBCclose in TI there is possibility to fail procces in the middle and miss execution of second command. In this case there are opened connections to ODBC are suspended in SQL until tm1 service is restarted.
So the question is - is it somehow possible to close them from tm1? Is session id available for TI? And how to avoid such trap? My only idea is to set up chain of two processes ("matryoshka") with first (base,parent) just to open/close connections and second (child) to do all other job. But is it within bestpractice?
When we use ODBCopen/ODBCclose in TI there is possibility to fail procces in the middle and miss execution of second command. In this case there are opened connections to ODBC are suspended in SQL until tm1 service is restarted.
So the question is - is it somehow possible to close them from tm1? Is session id available for TI? And how to avoid such trap? My only idea is to set up chain of two processes ("matryoshka") with first (base,parent) just to open/close connections and second (child) to do all other job. But is it within bestpractice?