Simple RunProcess - Runs in Serial Mode

Post Reply
chewza
Regular Participant
Posts: 154
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Simple RunProcess - Runs in Serial Mode

Post by chewza »

Hi There

Scenario is as follows for using RunProcess with master wrapper:
RunProcess => pass parameters such that months 1 to 6 are deleted in destination cube, and months 1 to 6 are copied from source cube
RunProcess => pass parameters such that months 6 to 12 are deleted in same destination cube, and months 6 to 12 are copied from same source cube

This immediately goes into serial mode, with a status of wait on the second line.

Any ideas?

Many thx!
Chris
lotsaram
MVP
Posts: 3672
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Simple RunProcess - Runs in Serial Mode

Post by lotsaram »

TM1 is pretty good and reliable at parallelizing pure data transactions, and even metadata these days as long as there is absolutely no overlap in objects (and dependencies) between threads. If your threads are locking then the most likely explanation is that there's a conflict in the subset names you are using for the zero out and/or data copy and both threads are trying to update the same metadata object which will of course cause a lock.

If each sub-process called by RunProcess does it's own view and subset creation make sure that:
- all subsets and views used are temp objects
- all subsets and views ARE UNIQUELY NAMED

If you went old skool and are doing the subset and view creation in the wrapper before calling the sub-processes (not really recommended), then you need to make sure that the sub-processes perform no manipulation of these objects at all.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
MarenC
Regular Participant
Posts: 364
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Simple RunProcess - Runs in Serial Mode

Post by MarenC »

chewza wrote: Thu Jun 27, 2024 3:56 pm RunProcess => pass parameters such that months 1 to 6 are deleted in destination cube, and months 1 to 6 are copied from source cube
RunProcess => pass parameters such that months 6 to 12 are deleted in same destination cube, and months 6 to 12 are copied from same source cube
Should the second part read months 7 to 12 and not 6 to 12? If not, would deleting identical periods in both process calls cause this?

Maren
chewza
Regular Participant
Posts: 154
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Simple RunProcess - Runs in Serial Mode

Post by chewza »

Many thanks all - got it working now!
Example was just hypothetical - did some additional work to ensure views/subsets unique
Post Reply