Attempt to acquire lock during commit or rollback

[vaonlydrb]

Hi TM1 Guru's,

I'm having an issue currently where running a TI process to "Recreate" a dimension results in the below error message;

15780 [2] ERROR TM1.Lock Attempt to acquire lock during commit or rollback
15780 [2] FATAL TM1.Server Server terminated

This is a stand-alone TI process and not part of any chore. The process is to recreate via ODBC. We want to recreate the dimension (list of projects with multiple hierarchy), where projects that are no longer active should move from the "Active Projects" folder to "Closed Projects" folder. The TI process runs successfully if the "Update" option is selected (under Maps --> Dimensions --> Action tab).

Any help here is appreciated!

TIA
DRB

[Wim Gielis]

Please post the full code of the process, if you want any meaningful replies.

[vaonlydrb]

This is a simple TI process without any manual manipulation. All codes are system created

Prolog


#****Begin: Generated Statements***
DIMENSIONDELETEALLELEMENTS(‘Project List’);
DIMENSIONSORTORDER('Project List','BYINPUT','ASCENDING','BYHIERARCHY','ASCENDING');
#****End: Generated Statements****

Metadata

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('Project List','',ProjectID,'n');
DIMENSIONELEMENTINSERT('Project List','',TOTAL,'c');
DIMENSIONELEMENTINSERT('Project List','',Group,'c');
DIMENSIONELEMENTINSERT('Project List','',Office,'c');
DIMENSIONELEMENTINSERT('Project List','',Manager,'c');
DIMENSIONELEMENTINSERT('Project List','',ProjectFolder,'c');
DIMENSIONELEMENTCOMPONENTADD('Project List',TOTAL,Group,1.000000);
DIMENSIONELEMENTCOMPONENTADD('Project List',Group,Office,1.000000);
DIMENSIONELEMENTCOMPONENTADD('Project List',Office,Manager,1.000000);
DIMENSIONELEMENTCOMPONENTADD('Project List',Manager,ProjectFolder,1.000000);
DIMENSIONELEMENTCOMPONENTADD('Project List',ProjectFolder,ProjectID,1.000000);
#****End: Generated Statements****

Data


#****Begin: Generated Statements***
ATTRPUTN(IsDirectProject,'Project List',ProjectID,'IsDirectProject');
#****End: Generated Statements****

[vaonlydrb]

Few additional points - When the TI process is run, it shuts down the server immediately and the log file has only the below entries. The server has to be manually restarted.

15780 [2] ERROR TM1.Lock Attempt to acquire lock during commit or rollback
15780 [2] FATAL TM1.Server Server terminated

In order to troubleshoot this, I duplicated the TI process (with an exact setup) to "recreate" another dimension and it runs fine. The new dimension created for testing is not part of any cube. Obviously, the lock contention has to do with the cubes & rules/feeders. I also created a cube (basically has "1" to indicate the TI process will be run) to disable the rules in others cubes when this TI process is run. This doesn't seem to work either and I'm running out of ideas. We are at testing stage and ready to go-live soon.

[Wim Gielis]

Hello,

I have no immediate cure, but first get rid of the DIMENSIONDELETEALLELEMENTS function. Use a generic process to unwind the dimension structures, Bedrock for example has such process (in case you haven't written this one yourself).

What rules do you typically have ? If I see TI wizard generated code statements, I suspect that rules and feeders would not be written in an optimal way. Can you confirm that these are validated / correct / efficient ?