Chore resubmitting itself when Locked out by another Process

Post Reply
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Chore resubmitting itself when Locked out by another Process

Post by John Hammond »

Folks

I have an unusual situation in that I have a chore that runs hourly. The chore runs a single process and the setting is such that it treats the chore as a single transaction. The single process has about 8 sub processes and takes about 2 mins to run.

There is no start batch updates / end batch updates logic within any of our processes.

The server is set up for PI but we don't carry out view creation in separate processes thus a process will lock out others for its duration rather than for the limited duration of the process that builds the view.

Without contention the chore runs fine, but when a process locks it out, it seems that the scheduler will resubmit the chore again and again so it runs many times afterwards locking any other programs out.

Note: the multiple submissions are not as a result of previous submissions unable to run being queued up. Before the problem the previous hour's chore would have run successfully.

Any ideas would be much appreciated. Happy to provide any further information.

Regards

John
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: Chore resubmitting itself when Locked out by another Process

Post by Alan Kirk »

First, welcome back. As far as I'm aware it's been a few years since you darkened the doorstep.

Second, could you please advise which version you're on now? Your profile still says 9.0, which seems unlikely.
"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.
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Chore resubmitting itself when Locked out by another Process

Post by John Hammond »

Hi Alan

Thanks for the update. Yes, it has been a long time - think you had the Mr T icon back then! :D I've updated my profile as requested.

Absence down to overzealous internet filters. Many times I tried to point out that this was an aid to TM1'ers only to be met with a sea of indifference and beauraucrasy (never can spell that word). Not quite sure what you can do to combat that, but the intellectual property right notice on the forum goes a fair way to ensuring that institutions don't throw a wobbly when you request site access.

Thanks for keeping the site going. I have done a fair bit with PM and CAFE now and I will try and post my experiences for the wider community.

Look forwards to chatting to you all again.

Regards

John
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: Chore resubmitting itself when Locked out by another Process

Post by Steve Rowe »

It's PAx now John not CAFE..... :lol:

Sounds to me that your chore is getting stuck in rollback loop that is clashing with the other jobs lock.

You can turn the logging up so that you can see what is happening in the locking model, this might give you some clues as to what is really happening. (https://www.ibm.com/support/knowledgece ... 6050c.html)

The simple thing to do is probably just put some stop start flags up so that the chore exits on line 1 if the other jobs are running, this would mean that the chore is not run though which may not work for you.

If you really need the chore to run every hour without fail then maybe
Put some flagging in the other TIs that mean they exit if the chore is running or if it is close to the time window the chore is running in in. I.e. figure a way out to give the core priority on the locking model.
Upgrade (not normally practical I know).
Rewrite to avoid the contention, might not be possible depending on the release.

Cheers,
Steve
Technical Director
www.infocat.co.uk
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: Chore resubmitting itself when Locked out by another Process

Post by Drg »

as written above the use of flags is a good idea.

I'll suggest an alternative to file flags:

Use your chore to run one parent process that starts the child processes.
in the parent process in the first line of the prolog, use the function

Code: Select all

synchronized('Important_batch_process')
Post Reply