TI processing locking file

Post Reply
appleglaze28
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

TI processing locking file

Post by appleglaze28 »

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?
EvgenyT
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

Post by EvgenyT »

Hello,
When we shut down the server, the file was no available to be overwritten.


Sorry, but seems like a contradiction to me ?

ET
declanr
MVP
Posts: 1815
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

Post by declanr »

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?
Declan Rodger
User avatar
Steve Rowe
Site Admin
Posts: 2410
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

Post by Steve Rowe »

When we shut down the server, the file was no available to be overwritten.
no = now or not ?
Technical Director
www.infocat.co.uk
tomok
MVP
Posts: 2831
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

Post by tomok »

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!
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
appleglaze28
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

Post by appleglaze28 »

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

Post by appleglaze28 »

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.
Duncan P
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

Post by Duncan P »

To be sure you need ProcMon. This will tell you exactly which process is locking the file.
Post Reply