Forum Discussion
Transaction was deadlocked on lock resources with another process ??
Hi,
We have a cognos datastage job that updates a table.
It fails with an error that the table is locked., see below
ini_PerformanceManagement_tblEmployees,0: ODBC function "SQLExecute" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (CC_OdbcDBStatement::executeUpdate, file CC_OdbcDBStatement.cpp, line 1,058)
Anyone any ideas about how to resolve this?
Thanks for your time,
Ollie
1 Reply
Rerun the transaction.
Deadlocks can happen if two processes accesses resources in different order; that can happen.
Deadlock (computer science) - Wikipedia
Do what the message says: Rerun the transaction.
