Hello,
after moving to a knew windows server (Win 2016) i have a problem with one of the tm1 instances
If a run a a data load or dimension process, the service for this db stops:
"TM1.Transaction TM1TransactionLog::BasicInitialize: The transaction log was found and write-locked. Recovery possible after server load."
I never saw this message before - does anybody has an idea what's my problem is or should i call ibm?
I'm working with Planning Analytics 11.4.00000.21
Best regards,
orlando
TM1 server crash
-
- Posts: 77
- Joined: Wed Sep 12, 2018 11:19 am
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0
- Excel Version: 2016
Re: TM1 server crash
Not entirely sure, but sounds like this *could be* related:
https://www-01.ibm.com/support/docview. ... wg21654717
https://www-01.ibm.com/support/docview. ... wg21654717
- orlando
- Community Contributor
- Posts: 167
- Joined: Fri Aug 04, 2017 8:27 am
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365
Re: TM1 server crash
thanks for your reply.bgregs wrote: ↑Mon Dec 10, 2018 12:21 pm Not entirely sure, but sounds like this *could be* related:
https://www-01.ibm.com/support/docview. ... wg21654717
i saw that before. even shut down server, delete logfiles, start service does not help
-
- Posts: 77
- Joined: Wed Sep 12, 2018 11:19 am
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0
- Excel Version: 2016
Re: TM1 server crash
Do you have a backup that was taken before the server migration you could test? This line:
really sounds like it could be the cause. If you don't have a backup to test with, then calling IBM may be your best bet (unless somebody else on here has another idea).The TM1 service may not have been shut down completely prior to copying the model
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1 server crash
I don't recall seeing that message before but we have had a few situations where instances that were running just fine on 10.2.2.x refused to load in 11.x and some others where the server did load but then crashed on each SaveDataAll. In these cases we found that the cause was "incomplete" file structure in the data directory which resulted in objects not registering on the server. Particularly
- }ElementAttributes cubes and dimensions where the root dimension .dim file didn't exist or was corrupted
- }vues folders for cubes no longer existing
After cleaning up the data directory the server was able to load and/or in the other case no more crash on save.
Might be worth trying before giving up hope.
- }ElementAttributes cubes and dimensions where the root dimension .dim file didn't exist or was corrupted
- }vues folders for cubes no longer existing
After cleaning up the data directory the server was able to load and/or in the other case no more crash on save.
Might be worth trying before giving up hope.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- orlando
- Community Contributor
- Posts: 167
- Joined: Fri Aug 04, 2017 8:27 am
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365
Re: TM1 server crash
Hi all,
i found the "problem".
It was a DimensionDestroy in one of my meta processes.
A metaprocess runs
Process 1: build a temp dimension
Process 2: Copy a part of the structure to another dimension
Process 3: Load the attributes
After the third process the metaprocess runs DimensionDestroy for the temp. dimension
Server Crashs.
Without the DimensionDestroy it rund fine.
It looks like that Win 2016 locks the Dim-File longer than Win 2012.
So in the future i do the housekeeping later.
Thanks for your help!
Best regards,
orlando
i found the "problem".
It was a DimensionDestroy in one of my meta processes.
A metaprocess runs
Process 1: build a temp dimension
Process 2: Copy a part of the structure to another dimension
Process 3: Load the attributes
After the third process the metaprocess runs DimensionDestroy for the temp. dimension
Server Crashs.
Without the DimensionDestroy it rund fine.
It looks like that Win 2016 locks the Dim-File longer than Win 2012.
So in the future i do the housekeeping later.
Thanks for your help!
Best regards,
orlando