TM1 Instance is crashing because the process cannot access its own log file

Post Reply
AskAndAnswer
Posts: 34
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: Planning Analytics
Version: 2.0...
Excel Version: 2016

TM1 Instance is crashing because the process cannot access its own log file

Post by AskAndAnswer » Thu Apr 25, 2019 6:21 pm

The issue started after an upgrade to Planning Analytics 2.0.35. One of the instances is constantly crashing with the same error message:

153712 [] FATAL 2019-04-25 10:06:48.917 TM1.System.File TM1 Server Abort: sf_Write() - Write error on file "d:\tm1\dbname\logs\TM1ProcessError_20190425100638_76253712_process_name.log$". Error = error code:32 reason:"The process cannot access the file because it is being used by another process." file:"d:\tm1\dbname\logs\TM1ProcessError_20190425100638_76253712_process_name.log$"
buffer = 0x0000001FB5CA26D0, len= 32751

It looks like TM1 is creating an error log file and immediately locks it for the process that created it. It happens only in one database out of six that are running on the same server.

Any ideas? All your help is greatly appreciated.

dr.nybble
Posts: 143
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: TM1 Instance is crashing because the process cannot access its own log file

Post by dr.nybble » Thu Apr 25, 2019 7:23 pm

Have you checked with Process Explorer that indeed no other process is accessing that file?

AskAndAnswer
Posts: 34
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: Planning Analytics
Version: 2.0...
Excel Version: 2016

Re: TM1 Instance is crashing because the process cannot access its own log file

Post by AskAndAnswer » Thu Apr 25, 2019 8:11 pm

Thank you for your reply. Do you mean Microsoft Process Explorer? It does not exist on the server as of right now. Is there any other way to identify what could lock the file right after it was created by a process?

Wim Gielis
MVP
Posts: 2109
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: TM1 Instance is crashing because the process cannot access its own log file

Post by Wim Gielis » Thu Apr 25, 2019 8:26 pm

Unless I am mistaken, Dr. Nybble is referring to this utility:
https://docs.microsoft.com/en-us/sysint ... ds/procmon
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 service with AutoHotKey

User avatar
gtonkin
MVP
Posts: 677
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: TM1 Instance is crashing because the process cannot access its own log file

Post by gtonkin » Fri Apr 26, 2019 6:32 am

Process Explorer is also part of SysInternals like ProcMon.
FInd it here: https://docs.microsoft.com/en-us/sysint ... s-explorer

Bakkone
Posts: 97
Joined: Mon Oct 27, 2014 10:50 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: TM1 Instance is crashing because the process cannot access its own log file

Post by Bakkone » Fri Apr 26, 2019 6:49 am

I have this feeling that something changed within PA/TM1 in one of the later versions. I feel like it used to be that I could just turn off an instance. Change the location of the config file etc and everything was fine and dandy.

But as in the problem here. I've noticed that even when shutting down the instance, ie the TM1 server. The system still retains the connection to the "old" data folders and configs. Instead I have to shut down the all of the instances, admin, application servers in cognos config for it to properly release its hold of the data and logs.

So maybe try a full restart?

AskAndAnswer
Posts: 34
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: Planning Analytics
Version: 2.0...
Excel Version: 2016

Re: TM1 Instance is crashing because the process cannot access its own log file

Post by AskAndAnswer » Fri May 10, 2019 9:47 pm

It looks like the new version of TM1 is handling multi-threading differently. The root cause was that the process was in conflict with SaveDataAll process.

Drg
Posts: 127
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: TM1 Instance is crashing because the process cannot access its own log file

Post by Drg » Mon May 13, 2019 1:40 pm

If you change metadata the answer -yes

AskAndAnswer
Posts: 34
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: Planning Analytics
Version: 2.0...
Excel Version: 2016

Re: TM1 Instance is crashing because the process cannot access its own log file

Post by AskAndAnswer » Fri May 17, 2019 3:43 pm

Looks like it's not only metadata that affects it.

Post Reply