Exception computing feeders for base cube 'Cube': IX locking is prohibited in nested transactions

[biggie]

Hi, why do I see this message (Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread) for some cubes while running the model? For example:

Code: Select all

6644   []   INFO   2025-05-25 19:29:36.668   TM1.Server   TM1CubeImpl::ProcessFeeders: Computing feeders for base cube 'Cube_A'.
... 'Adding cube dependency' message for other cubes...
1436   []   INFO   2025-05-25 19:29:47.006   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
5976   []   INFO   2025-05-25 19:29:47.007   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
2060   []   INFO   2025-05-25 19:29:47.007   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
2452   []   INFO   2025-05-25 19:29:47.007   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
3096   []   INFO   2025-05-25 19:29:47.007   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
... 'Adding cube dependency' message for other cubes...
1436   []   INFO   2025-05-25 19:30:06.871   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
5548   []   INFO   2025-05-25 19:30:06.871   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
... 'Adding cube dependency' message for other cubes...
1280   []   INFO   2025-05-25 19:30:06.872   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
2060   []   INFO   2025-05-25 19:30:06.872   TM1.Cube.Dependency   Adding cube dependency: Cube '0302_БП_БП_предприятия_Сводный_ГП' depends on cube '0204_НС_Соотв_Материалы_Статьи'.
4912   []   INFO   2025-05-25 19:30:06.872   TM1.Cube.Dependency   Adding cube dependency: Cube '0302_БП_БП_предприятия_Сводный_ГП' depends on cube '0204_НС_Соотв_Материалы_Статьи'.
2060   []   INFO   2025-05-25 19:30:06.873   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
4912   []   INFO   2025-05-25 19:30:06.873   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
... 'Adding cube dependency' message for other cubes...
1328   []   INFO   2025-05-25 19:30:06.874   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
1220   []   INFO   2025-05-25 19:30:06.874   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
4164   []   INFO   2025-05-25 19:30:06.874   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
1852   []   INFO   2025-05-25 19:30:06.875   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
... 'Adding cube dependency' message for other cubes...
5976   []   INFO   2025-05-25 19:30:07.412   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
... 'Adding cube dependency' message for other cubes...
5976   []   INFO   2025-05-25 19:30:09.867   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
2060   []   INFO   2025-05-25 19:30:09.867   TM1.Server   TM1CubeImpl::ProcessFeeders: Exception computing feeders for base cube 'Cube_A': IX locking is prohibited in nested transactions. Remaining work will be performed in serialized mode by the transaction thread.
6644   []   INFO   2025-05-25 19:30:12.055   TM1.Server   TM1CubeImpl::ProcessFeeders(in 35391ms): Done computing feeders for base cube 'Cube_A'.

After loading the model, the feeders in these cubes do not work. To restore the feeders, I set up chore with the CubeProcessFeeders() command

[Adam]

I’ve gotten this error in the past for large daisy chained feeders, while not literally this, it’s effectively:
1 => 2
2 => 3
…
999 => 1000

Carefully review the feeders and ensure it’s not a long chain.

[Emixam]

I had the same problem couple months ago. You can read this technote from IBM for more information: https://www.ibm.com/support/pages/excep ... ansactions

I hate to say that but you'll have to review all your feeders to find the culprit. Enjoy !