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?
Cognos TM1 & SQL: What you gonna do if TI failed ODBCclose?
-
ioscat
- Regular Participant
- Posts: 209
- Joined: Tue Jul 10, 2012 8:26 am
- OLAP Product: Contributor
- Version: 9.5.2 10.1.1 10.2
- Excel Version: 07+10+13
- Contact:
Cognos TM1 & SQL: What you gonna do if TI failed ODBCclose?
Last edited by ioscat on Fri Nov 15, 2013 5:33 am, edited 1 time in total.
-
macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Cognos TM1 & SQL: What you gonna do if TI failed ODBCclo
Use three processes, one is master and other two sub-processes. one is to check the connection in normal TI ODBC interface. If it can be opened, then execute the second job process. Otherwise, skip it?