About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
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"}}]
Log InLog in 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 Log in button above to access the full document. 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