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.
Data Source File Hung Up After TI Process??
-
- Posts: 36
- Joined: Fri Mar 10, 2017 8:26 pm
- OLAP Product: TM1
- Version: PA 2.0.8
- Excel Version: 2016
- Location: Dallas, TX
-
- 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: Data Source File Hung Up After TI Process??
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.
-
- 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??
The file is pushed out every night from a separate accounting system, not something generated by a TM1 process.
- gtonkin
- MVP
- Posts: 1203
- 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??
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.
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.
-
- 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??
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?
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?