Exception computing feeders for base cube 'Cube': IX locking is prohibited in nested transactions
Posted: Tue Jun 03, 2025 11:02 pm
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:
After loading the model, the feeders in these cubes do not work. To restore the feeders, I set up chore with the CubeProcessFeeders() command
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'.