File is open in IBM Cognos TM1 Server

Post Reply
Alex Leung
Posts: 9
Joined: Fri May 24, 2019 1:23 am
OLAP Product: Planning Analytics
Version: 2.0.6
Excel Version: Excel 2013 32-bit

File is open in IBM Cognos TM1 Server

Post by Alex Leung »

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
User avatar
Steve Rowe
Site Admin
Posts: 2410
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

Post by Steve Rowe »

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.
Technical Director
www.infocat.co.uk
Alex Leung
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

Post by Alex Leung »

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.
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: File is open in IBM Cognos TM1 Server

Post by Drg »

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