Parallel update of dimensions causes rollback

Post Reply
andreykadysh
Posts: 22
Joined: Fri Aug 27, 2021 5:41 pm
OLAP Product: IBM Cognos Planning Analytics
Version: 2.0.9.19
Excel Version: 2016

Parallel update of dimensions causes rollback

Post by andreykadysh »

Hi!
I call upon the Help and Wisdom of TM1 Experts.

We are trying to make parallel updates of dimensions from CSV files.
For parallel interaction we use RushTI.

Issue:
At the stage of filling attributes on the Data tab, process blocking and rollback occur, i.e., they cannot run in parallel.

For example:
There are two dimension update processes running in parallel:
Dim.Update.Agreement and Dim.Update.Counterparty.

Dim.Update.Agreement locks a certain number of cubes in Read, ReadOnly and IntenteXclusive mode, for reasons unclear.
Meanwhile, Dim.Update.Counterparty, which was running in parallel, goes into rollback.

The processes only add new dimension elements via DimensionElementInsert / DimensionElementComponentAdd and write attributes via AttrPutS.
Adding elements on the Metadata tab locks only its own dimension, as it logically should.
But on the Data tab, when adding attributes it locks some random cubes. Even those that don't have this dimension :roll:

Any help would be appreciated!
Andre
Wim Gielis
MVP
Posts: 3230
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Parallel update of dimensions causes rollback

Post by Wim Gielis »

Are there cube links through rules ?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
andreykadysh
Posts: 22
Joined: Fri Aug 27, 2021 5:41 pm
OLAP Product: IBM Cognos Planning Analytics
Version: 2.0.9.19
Excel Version: 2016

Re: Parallel update of dimensions causes rollback

Post by andreykadysh »

Yes, some of them linked through rules.

Did I get it right, that:
IntenteXclusive mode - is for cubes, that contain dimension being updated in process.
Read, ReadOnly modes are for cubes linked through rules.
Post Reply