Is there anyway to determine if a TI process is keeping the file open. Cause we had an instance where the user is trying to override the source file but we're getting an error that the file is opened by another program.
There was no running TI process so we were unable to kill the process.
When we shut down the server, the file was no available to be overwritten. Is there any other options other than restarting the TM1 Server instance?
TI processing locking file
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: TI processing locking file
Hello,
Sorry, but seems like a contradiction to me ?
ET
When we shut down the server, the file was no available to be overwritten.
Sorry, but seems like a contradiction to me ?
ET
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TI processing locking file
If you've shut down the service and the file was still locked then it is unlikely TM1 is the program holding the lock.
Possibly another user just has it open?
Have you tried hard deleting the file in cmd prompt?
Possibly another user just has it open?
Have you tried hard deleting the file in cmd prompt?
Declan Rodger
- Steve Rowe
- Site Admin
- Posts: 2424
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: TI processing locking file
no = now or not ?When we shut down the server, the file was no available to be overwritten.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TI processing locking file
I'm going to take a stab here and guess the file you are talking about is a CSV file. If that's the case then someone probably has it open in Excel, thus the locking. People don't realize when you have an Excel sheet open and then save as CSV, you will keep a lock on the CSV until you physically close the file. I have people that use CSV files as TI sources call me all the time wondering why their process failed. I then have to remind them to close the file in Excel first. Doh!
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Re: TI processing locking file
We checked it in Computer Management there is no user having the csv file open. But when we try to restart the TM1 Application Server, the file is now available to be overwritten.
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Re: TI processing locking file
We checked it in Computer Management there is no user having the csv file open. But when we try to restart the TM1 Application Server, the file is now available to be overwritten.
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: TI processing locking file
To be sure you need ProcMon. This will tell you exactly which process is locking the file.