RunProcess in a scheduled chore causes server crash

Post Reply
User avatar
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

Post by PavoGa »

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.
Ty
Cleveland, TN
MarenC
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

Post by MarenC »

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
Alan Kirk
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

Post by Alan Kirk »

PavoGa wrote: Wed Feb 26, 2020 4:10 pm 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.
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.
User avatar
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

Post by PavoGa »

Alan Kirk wrote: Wed Feb 26, 2020 6:00 pm
PavoGa wrote: Wed Feb 26, 2020 4:10 pm 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.
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.)
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
User avatar
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

Post by Oratia623 »

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.
Post Reply