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
TM1 service holding open ODBC?
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 service holding open ODBC?
In the same process do you have ODBCClose in the prologue?
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: TM1 service holding open ODBC?
Hi Jim, thanks for the reply.
No there is no ODBCClose in the prologue or anywhere in the process for that matter
cheers, Mark
No there is no ODBCClose in the prologue or anywhere in the process for that matter
cheers, Mark
-
- Posts: 119
- Joined: Mon Oct 27, 2014 10:50 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 service holding open ODBC?
Then you have to add one.
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: TM1 service holding open ODBC?
Hi Bakkone,
On the prologue? Won't that affect the meta and data tabs?
I presume JIm had something else in mind?
cheers, Mark
On the prologue? Won't that affect the meta and data tabs?
I presume JIm had something else in mind?
cheers, Mark
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 service holding open ODBC?
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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: TM1 service holding open ODBC?
No problem and thanks for the advice!
-
- Posts: 119
- Joined: Mon Oct 27, 2014 10:50 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 service holding open ODBC?
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.
Or if you know that the DBAs are running backups at night. Add a process with ODBC close in your own nightly backup routine.