TM1 Forum

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?

Hello,

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

Sorry, but seems like a contradiction to me ?

ET

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?

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

no = now or not ?

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!

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.

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.

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