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.