IBM Support

"Standard Error ... Validate SQL Error ... TrialBalanceB_GetClosContReportData" when running Trial Balance

Technote (troubleshooting)


User clicks "Group - Reports - Trial Balance with Drilldown". User chooses parameters, and clicks 'preview'. An error message appears.


Standard Error

Source: FrangoDirect.TrialBalanceD.GetClosContReportData#ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Validate SQL Error
at Cognos.Controller.SEC.ParameterValidator.ValidateParameter(String sParamType, String sItem, String sReadWrite)
at Cognos.Controller.SEC.ParameterValidator.ValidateParameter(String sParamType, String[] aItem, String sReadWrite)
at Cognos.Controller.Proxy.CCRWS.TrialBalanceB_GetClosContReportData(String sGuid, String sUser, Int32 lLocaleID, String sPerAkt, String sKoncTyp, String sGroup, String[] varCompanies, String[] varClosVer, String[] varContVer, String sCurType, String sForms, String sAccount, String[] varDims, Boolean bShowEmptyLines, Boolean bShowZeroValues)
--- 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.TrialBalanceD.GetClosContReportData(String sPerAkt, String sKoncTyp, String sGroup, Object varCompanies, Object varClosVer, Object varContVer, Boolean bConsolAjtAsBase, String sCurType, String sCurrency, String sForms, String sAccount, Object varDims, Boolean bShowEmptyLines, Boolean bShowZeroValues, Boolean bBTypesAsReportedValues, String sClosingVersionForReportedValues)
at Cognos.Controller.Forms.Form.frmTrialBalance.LoadReport(String& sPerAct, String& sForm, Object& varCompanies, String& sAccount, String& sGroup, String& sConsType, String& sCloseVer, String& sContVer, String& sCurrencyType, String& sCurrencyCode, String[]& sClosVers, String[]& sContVers, String[]& sDims)


Invalid structures inside Controller.

More Information
In one real-life case, the customer had recently mistakenly created/imported some new company names (inside their company structure) which had spaces in them.

  • Spaces are invalid characters inside company/account names

Diagnosing the problem

There are several possible causes for similar error messages.

  • See other IBM Technotes for more examples.

TIP: It is vital to check the error message carefully (specifically check the value of the phrase after the 'at Cognos.Controller.Proxy.CCRWS' section of the error) to check which problem you are suffering from.

Resolving the problem


Fix the invalid structures inside Controller.

Real-life Example:
In one real-life customer case, the customer clicked "Maintain - Company Structure - Change Table - Define/Run"...

...and then created (and then ran) a new entry which changed the companies from their old code (e.g. "AB CDE") to their new (correct) value (e.g. "ABCDE").

Document information

More support for: Cognos Controller

Software version: 10.1.1

Operating system(s): Windows

Reference #: 1646592

Modified date: 16 August 2013

Translate this page: