Unsolved
This post is more than 5 years old
4 Posts
0
17937
DELL OME SQL Errors "was deadlocked on lock resources with another process and has been chosen as the deadlock victim."
SQL Errors in OME application logs:
OME version: 1.0.1.1253
| Severity,"Time","Message" | |
| Critical,"9/17/2012 10:43:59 AM","Inventory Manager Exception | Device: -1093266236 , Exception: Failed to insert or update records due to non-unique data in columns of table. : Error executing the SQL Statement:INSERT INTO Agent (AgentId,AgentGlobalStatus,AgentManufacturer,AgentDescription,DeviceId) VALUES(?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 23000, | |
| Native Error Code: 203, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'AgentName', table 'OMEssentials.dbo.Agent' | column does not allow nulls. INSERT fails. |
| SQL_ERROR results continued: | |
| SQL Error State: 01000, | |
| Native Error Code: E25, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:16 AM","Inventory Manager Exception | Device: -2123721362 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:16 AM","Inventory Manager Exception | Device: -1579914863 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:15 AM","Inventory Manager Exception | Device: 654756882 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:15 AM","Inventory Manager Exception | Device: 677029104 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:15 AM","Inventory Manager Exception | Device: 892141512 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][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. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:15 AM","Inventory Manager Exception | Device: 1187813878 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:15 AM","Inventory Manager Exception | Device: 1444794315 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:15 AM","Inventory Manager Exception | Device: -1552173211 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:15 AM","Inventory Manager Exception | Device: -2037808996 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:14 AM","Inventory Manager Exception | Device: -1506483162 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:13 AM","Inventory Manager Exception | Device: -561345538 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:10 AM","Inventory Manager Exception | Device: -987455879 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][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. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:42:05 AM","Inventory Manager Exception | Device: -1438608590 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:29 AM","Inventory Manager Exception | Device: -2099660184 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:28 AM","Inventory Manager Exception | Device: 286092039 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:28 AM","Inventory Manager Exception | Device: 12134627 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:28 AM","Inventory Manager Exception | Device: 310782446 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:28 AM","Inventory Manager Exception | Device: 1248585373 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][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. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:28 AM","Inventory Manager Exception | Device: 48813662 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:27 AM","Inventory Manager Exception | Device: 151514204 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:26 AM","Inventory Manager Exception | Device: -1748504051 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][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. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:23 AM","Inventory Manager Exception | Device: 1198824810 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |
| Critical,"9/17/2012 10:41:18 AM","Inventory Manager Exception | Device: 12480934 , Exception: An internal database error occurred. : Error executing the SQL Statement:INSERT INTO Firmware (FirmwareVersion,FirmwareType,FirmwareChassisIndex,FirmwareName,DeviceId,FirmwareIndex) VALUES(?,?,?,?,?,?) |
| Error: | |
| SQL_ERROR results: | |
| SQL Error State: 40001, | |
| Native Error Code: 4B5, | |
| ODBC Error Text: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. | |
| ODBC_DatabaseConnection::AddTableRow()" | |