Page 1 of 1

Parallel update of dimensions causes rollback

Posted: Mon May 26, 2025 9:22 am
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

Re: Parallel update of dimensions causes rollback

Posted: Mon May 26, 2025 7:30 pm
by Wim Gielis
Are there cube links through rules ?

Re: Parallel update of dimensions causes rollback

Posted: Fri May 30, 2025 7:38 am
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.