Troubleshooting
Problem
User receives various errors when using Controller.
Symptom
The errors vary depending on what function the user is performing. Below are some examples:
Database Optimise:
COMException (0x80004005): [DB2/AIX64] SQL0727N An error occurred during implicit system action type "1". Information returned for the error includes SQLCODE "-551", SQLSTATE "42501" and message tokens "<username>|SELECT|SYSCAT.TABLES". SQLSTATE=56098
Consolidation:
Number: 5
Source: ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x800A01B8): Automation error (Error occured within method=RunConsol in the module with progid=FrMiscBT.ConsBusinessT)
at FrBatchBT.clsBatchTClass.Batch(String sGuid, String sUser, Int16 iProcessId, String sJobName, String sParams, Int32 lRegDate, Int32 lRegTime, Int32 lSchedDate, Int32 lSchedTime, Int16 iScheduleType, String sUdl, Int32 lDependentBy, String sTimeChain, Boolean bBatchMode)
Saving changes inside 'Server Preferences':
Number: 5
Source: FrangoDirect.StructureVersionsD.UpdateStrucVer#ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x80004005): CLI0115E Invalid cursor state. SQLSTATE=24000
at FrTransferBT.StructureVersionsTClass.UpdateStrucVer(String sGuid, String sUser, String sTyp2, String sSource, Object bUpdateChangeDate, Object bUpdateReleaseDate, String sChangeDate, String sReleaseDate, Connection& conDB)
at Cognos.Controller.Proxy.CCRWS.StructureVersionsT_UpdateStrucVer(String sGuid, String sUser, String sTyp2, String sSource, Object bUpdateChangeDate, Object bUpdateReleaseDate, String sChangeDate, String sReleaseDate, Object& conDB)
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Cognos Controller
Software version:
10.1.1
Operating system(s):
Windows
Document number:
247651
Modified date:
08 May 2025
UID
swg21681677
Manage My Notification Subscriptions