Getting Deadlock Error while importing data with ALIM Import/Export tool


Applies To

Product(s):

ALIM Import/Export

Version(s):

v1.0.1.XX

Environment:

N/A

Area:

ALIM Import/Export

Subarea:

----------

Original Author:

Nitin Bhui, Bentley Technical Support Group

 

Problem:

Getting following Error while Importing the Data : Transaction (Process ID 78) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Error:

Go to the Import Excel Sheet which you used for Import and Check the Error Message column.

You can see the below error:

Error: Transaction (Process ID 81) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Workaround:

Above error occurred because the other session-transactions were using the same table due to which the deadlock has happened on the Database level. So as per the message, you can re-run/re-upload the sheet. Which should resolve this issue.