TM1 Forum

I have a TI process that runs on a nightly schedule. The data source is a text file that is replaced daily by an updated version. Occasionally the source file gets hung up after the process runs and cannot be replaced because it thinks it is currently open and in use. The message log indicates that the TI process was completed without errors and the process doesn't appear in TM1 Top on the server. The only solution I have found thus far to free the file is to restart the TM1 server and get rid of the existing data source file.

Is anyone familiar with a problem like this or have any solutions other than restarting the server, which is an inconvenience to other users? It is strange that the process is complete, but the file behaves as though it is in use and the issue is resolved by stopping the service.

What is the source of the text file? is it coming from an outside source or another TI process that runs earlier? TM1 would not not normally acquire a lock on a file if it is just reading it AFAIK. I could be wrong. One solution is to not replace the file each night but instead create a new one with a timestamp type value in the filename. You can then set the datasource property in the TI to process the correct file. This way you also have history because of keeping the previous text files.

The file is pushed out every night from a separate accounting system, not something generated by a TM1 process.

May be worthwhile as a test to add some code to copy the source file to another name, use this as your source and remove afterwards. That way, the two systems should not lock/fight.
If the file is on a share drive, you could also try use the "openfiles" command to see who/what may have any locks. Alternatively, use Process Explorer to find what is locking the file.

you use RUNTI?
How do you verify that the data is loaded?
You use chore to run load process(What level of acceptance are you using)?
What structure does the process call the parent child processes?