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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms