My Oracle Support Banner

Receiving SQL Deadlocks (Doc ID 1580227.1)

Last updated on JULY 05, 2017

Applies to:

Skywire Documanage - Version 6.6 and later
Information in this document applies to any platform.

Symptoms

On : 6.6 version, Documanage Server

Periodically receive a SQL deadlock, such as:

07/15/13 09:51:01.166 [0x884] - [***] - (40001, 1205) [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 93) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
07/15/13 09:51:01.182 [0x884] - [***] - End of SQL diagnostic records.
07/15/13 09:51:01.198 [0x884] - [***] - (2001) "Database Error" thrown by int __thiscall ODBCDatabaseAccessor::Execute(void)(.\ODBCDatabaseAccessor.cpp:216) re-thrown by int __thiscall SelectStatement::Select(class StatementDetailsForSelect *)(.\SelectStatement.cpp:54) re-thrown by class CItemObjectArray *__thiscall CPowerCabinet::GetChildren(unsigned long,class CSession *,class CCursor *)(.\powercabinet.cpp:879) logged by unsigned long __thiscall CSessionArray::GetChildItemsInfo(unsigned long,unsigned long,struct ItemAttributes *)(.\client_item.cpp:632)

ERROR
-----------------------

07/15/13 09:51:01.198 [0x884] - [***] - (2001) "Database Error" thrown by int __thiscall ODBCDatabaseAccessor::Execute(void)(.\ODBCDatabaseAccessor.cpp:216) re-thrown by int __thiscall SelectStatement::Select(class StatementDetailsForSelect *)(.\SelectStatement.cpp:54) re-thrown by class CItemObjectArray *__thiscall CPowerCabinet::GetChildren(unsigned long,class CSession *,class CCursor *)(.\powercabinet.cpp:879) logged by unsigned long __thiscall CSessionArray::GetChildItemsInfo(unsigned long,unsigned long,struct ItemAttributes *)(.\client_item.cpp:632)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.