TM1 Forum

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

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.

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.

Yes, this problem is also found at 10.2.2 fp 7, there is still no solution except restarting.