Hi everyone,
I am using Planning Analyrics 2.0.6. I have run a process which uses a text file as a data source. After running the process successfully, when i rename or delete the text file, it said "The action can't be completed because the file is open in IBM Cognos TM1 Server". The situation happens occasionally. When i copy the same file to UAT environment and run the same process (same code), there is no problem.
Anyone encountered the same problem before? Please help.
Besides, i would like to ask how to check whether the TM1 server is using the file and stop TM1 server to open it.
I opened tm1top but there is no any process running. Currently, my fixing method is to restart the tm1 server. But it spends too much time, hope there is any alternative way to end tm1 using the text file.
Thank you,
Alex
File is open in IBM Cognos TM1 Server
-
- Posts: 9
- Joined: Fri May 24, 2019 1:23 am
- OLAP Product: Planning Analytics
- Version: 2.0.6
- Excel Version: Excel 2013 32-bit
- Steve Rowe
- Site Admin
- Posts: 2417
- 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: File is open in IBM Cognos TM1 Server
Hi Alex,
I'm not going to be much help I'm afraid but I have seen similar behaviour, erratically and infrequently, where the OS thinks TM1 still has a lock on a file that has been used as TI datasource.
Not been able to reproduce and so it has not been raised with IBM.
I'm not going to be much help I'm afraid but I have seen similar behaviour, erratically and infrequently, where the OS thinks TM1 still has a lock on a file that has been used as TI datasource.
Not been able to reproduce and so it has not been raised with IBM.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 9
- Joined: Fri May 24, 2019 1:23 am
- OLAP Product: Planning Analytics
- Version: 2.0.6
- Excel Version: Excel 2013 32-bit
Re: File is open in IBM Cognos TM1 Server
Thanks Steve,
My fixing method also is to restart the TM1 server currently. I have not met this problem in TM1 10.2.2. Hope others know the reason.
Now i add
"DATASOURCENAMEFORSERVER = DataDir | DummyFile;
DATASOURCENAMEFORCLIENT = DataDir | DummyFile; "
in the Epilog.
Hope it will release the loaded file after running the process successfully.
My fixing method also is to restart the TM1 server currently. I have not met this problem in TM1 10.2.2. Hope others know the reason.
Now i add
"DATASOURCENAMEFORSERVER = DataDir | DummyFile;
DATASOURCENAMEFORCLIENT = DataDir | DummyFile; "
in the Epilog.
Hope it will release the loaded file after running the process successfully.
-
- 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: File is open in IBM Cognos TM1 Server
Yes, this problem is also found at 10.2.2 fp 7, there is still no solution except restarting.