Troubleshooting
Problem
User performs a database optimise. An error appears.
Symptom
Number: 5
Source: FrangoDirect.Optimize.AnalyzeSchema#System.Web.Services
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "<schemaname>.PRC_ANALYZE_SCHEMA", line 25
ORA-06512: at line 1
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at FrDatabaseBT.OptimizeT.AnalyzeSchema(String sGuid, String sUser)
--- End of inner exception stack trace ---
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at Cognos.Controller.Direct.Optimize.AnalyzeSchema()
at Cognos.Controller.Forms.Form.frmOptimize.RunDatabaseOptimization(Boolean& bErr, Int32& lErr, String sUser, String& sErr1, String& sErr2)
at Cognos.Controller.Forms.Form.frmOptimize.IRun_DoRun()
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "<schemaname>.PRC_ANALYZE_SCHEMA", line 25
ORA-06512: at line 1
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at FrDatabaseBT.OptimizeT.AnalyzeSchema(String sGuid, String sUser)
--- End of inner exception stack trace ---
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at Cognos.Controller.Direct.Optimize.AnalyzeSchema()
at Cognos.Controller.Forms.Form.frmOptimize.RunDatabaseOptimization(Boolean& bErr, Int32& lErr, String sUser, String& sErr1, String& sErr2)
at Cognos.Controller.Forms.Form.frmOptimize.IRun_DoRun()
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.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
Modified date:
09 May 2025
UID
ibm15951991