Data Source File Hung Up After TI Process??

Post Reply
Thurston Howell III
Posts: 36
Joined: Fri Mar 10, 2017 8:26 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Dallas, TX

Data Source File Hung Up After TI Process??

Post by Thurston Howell III »

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.
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: Data Source File Hung Up After TI Process??

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Thurston Howell III
Posts: 36
Joined: Fri Mar 10, 2017 8:26 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Dallas, TX

Re: Data Source File Hung Up After TI Process??

Post by Thurston Howell III »

The file is pushed out every night from a separate accounting system, not something generated by a TM1 process.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Data Source File Hung Up After TI Process??

Post by gtonkin »

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.
Drg
Regular Participant
Posts: 159
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Data Source File Hung Up After TI Process??

Post by Drg »

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