Troubleshooting
Problem
User performs a task (for example a database optimise) but receives an error. Alternatively, I.T. administrator opens the Event Log on the Controller application server, and views the 'Application Log'. There are a number of events which relate to 'deadlocks'. What are deadlocks, and why do I get them?
Symptom
The exact error message will vary depending on what the user was doing at the time. Below are some examples:
Information
Standard Error
Number: 5
Source: FrangoDirect.CopyValuesD.ReportedBetweenPer#ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. --->
system.Runtime.InteropServices.COMException (0x0004005): Transaction (Process ID 52) was deadlocked on lock resources with another process
and has been chosen as the deadlock victim. Rerun the transaction.
at FrCopyValuesBT.CopyValuesTClass.ReportedBetweenPer(Recordset rsBol, Recordset rsCurrType, Recordset rsForms, Recordset rsPerakt,
Boolean bForceCopy, String sGuid, String sUser, Int32& IErrorCode, String& sErrorMsg)
at Cognos.Controller...
'Application' Event Logs example:
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 21/02/2008
Time: 15:07:02
User: N/A
Computer: APPSERVER
Description:
The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 4276 ,Logged: Error occured at 2/21/2008 4:07:02 PM in FrSrvFunc, Error No=-2147467259, Source=Server function:Dbp_ExecuteImmediate(..) , Description=Transaction (Process ID 89) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., HelpFile= HelpContext=0
Log InLog in to view more of this document
Historical Number
1038647
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
swg21347720