TM1 service holding open ODBC?

[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

[jim wood]

In the same process do you have ODBCClose in the prologue?

Jim.

[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

[Bakkone]

Then you have to add one.

[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

[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.

[Mark RMBC]

No problem and thanks for the advice!

[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.