Page 1 of 1
TM1 service holding open ODBC?
Posted: Mon Jul 01, 2019 12:13 pm
by Mark RMBC
Hi,
does anyone know if the TM1 service can hold open an ODBC connection permanently for a TI execution?
We have some issues and IT have said TM1 is holding open an odbc connection and preventing some backups
cheers, Mark
Re: TM1 service holding open ODBC?
Posted: Mon Jul 01, 2019 12:28 pm
by jim wood
In the same process do you have ODBCClose in the prologue?
Jim.
Re: TM1 service holding open ODBC?
Posted: Mon Jul 01, 2019 1:58 pm
by Mark RMBC
Hi Jim, thanks for the reply.
No there is no ODBCClose in the prologue or anywhere in the process for that matter
cheers, Mark
Re: TM1 service holding open ODBC?
Posted: Mon Jul 01, 2019 2:11 pm
by Bakkone
Then you have to add one.
Re: TM1 service holding open ODBC?
Posted: Mon Jul 01, 2019 2:13 pm
by Mark RMBC
Hi Bakkone,
On the prologue? Won't that affect the meta and data tabs?
I presume JIm had something else in mind?
cheers, Mark
Re: TM1 service holding open ODBC?
Posted: Mon Jul 01, 2019 3:38 pm
by jim wood
Sorry I meant the epilogue. In my defense it was first thing in the morning and there wasn't even a sniff of caffeine yet!! So yes close the ODBC in the epilogue.
Re: TM1 service holding open ODBC?
Posted: Mon Jul 01, 2019 4:14 pm
by Mark RMBC
No problem and thanks for the advice!
Re: TM1 service holding open ODBC?
Posted: Tue Jul 02, 2019 3:34 pm
by Bakkone
Try to add some validations and other checks that also triggers a close. Otherwise you risk having the connection stay open because of an error.
Or if you know that the DBAs are running backups at night. Add a process with ODBC close in your own nightly backup routine.