Applies To
Product(s):
ALIM Import/Export
Version(s):
v1.0.1.XX
Environment:
N/A
Area:
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.