Attempt to acquire lock during commit or rollback

Post Reply
vaonlydrb
Posts: 5
Joined: Mon May 23, 2016 8:53 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Attempt to acquire lock during commit or rollback

Post by vaonlydrb » Sun Mar 22, 2020 3:01 pm

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
MVP
Posts: 2366
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Attempt to acquire lock during commit or rollback

Post by Wim Gielis » Sun Mar 22, 2020 3:24 pm

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

vaonlydrb
Posts: 5
Joined: Mon May 23, 2016 8:53 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Attempt to acquire lock during commit or rollback

Post by vaonlydrb » Mon Mar 23, 2020 6:10 am

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
Posts: 5
Joined: Mon May 23, 2016 8:53 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Attempt to acquire lock during commit or rollback

Post by vaonlydrb » Mon Mar 23, 2020 6:34 am

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
MVP
Posts: 2366
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Attempt to acquire lock during commit or rollback

Post by Wim Gielis » Mon Mar 23, 2020 8:15 am

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 ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

Post Reply