This may have been brought up before, so forgive me if that is the case.
Looks like using RunProcess in a process executed by a scheduled or startup chore will crash the server. I'd run into this before and forgot about it, then it happened again when the same changes were made to use RunProcess in our chore processes. No error logs are written for the processes, but there are various entries in the server log as we ran tests:
IX conflict encountered during single threaded operation.
TM1.Lock Before image is NOT NULL Client, server is not stable
TM1.Object TM1ObjectImpl::AddUnregistered: Object NULL could not be added to owning client R*h2_sys.Cube.Dimension Usage Update
And just as likely as not, we would have no error, just a server crash. These errors were reported on separate crashes. So, fair warning.
RunProcess in a scheduled chore causes server crash
- PavoGa
- MVP
- Posts: 622
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
RunProcess in a scheduled chore causes server crash
Ty
Cleveland, TN
Cleveland, TN
-
- Regular Participant
- Posts: 436
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: RunProcess in a scheduled chore causes server crash
Hi Pavoga,
I encountered this very issue last week and saw the exact same message in the server log.
I was going to raise an issue on the forum but thought I had used up enough of peoples time with RunProcess questions!
Maren
I encountered this very issue last week and saw the exact same message in the server log.
I was going to raise an issue on the forum but thought I had used up enough of peoples time with RunProcess questions!
Maren
-
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: RunProcess in a scheduled chore causes server crash
For which version? You have two specified in your profile.
I have a bunch of scheduled chores which use RunProcess and I've not encountered this to date. (PA 2.0.6.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- PavoGa
- MVP
- Posts: 622
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: RunProcess in a scheduled chore causes server crash
PA 2.0.5. It is repeatable. I should have mentioned this, but we are using CAM. I have no idea if that could be part or all of the problem; have not tested.
Another interesting observation: we use a process that records statistics for each process execution. We had just blanket converted everything to execute this with RunProcess. It would complete the first time it executed, then crash on the second call.
Bottom line was the only way to stop the crashing was to remove the RunProcess calls in processes called in scheduled or startup chores.
Ty
Cleveland, TN
Cleveland, TN
- Oratia623
- Posts: 40
- Joined: Mon Apr 27, 2009 5:36 am
- OLAP Product: TM1/PA/CA
- Version: V7.x to 2.0.9+
- Excel Version: All
- Location: Sydney, Australia
Re: RunProcess in a scheduled chore causes server crash
For future readers: This is a IBM bug (link to IBM APAR) for which there is a fix available in 2.0.8 and higher.
Paul Williamson
____________________________________________________________________________________
I came. I saw. I did not concur.
____________________________________________________________________________________
I came. I saw. I did not concur.