IBM Support

"Standard Error ... Validate SQL Error ... TrialBalanceB_DrillCompany" when drilling down by Company

Technote (troubleshooting)


User launches "Group - Reports - Trial Balance with Drilldown". User opens selections. Afterwards, user tries to drilldown by company. An error appears.


Number: 5
Source: FrangoDirect.TrialBalanceD.DrillCompany#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.Proxy.CCRWS.TrialBalanceB_DrillCompany(String sGuid, String sUser, Int32 lLocaleID, String sPerAkt, String sKoncTyp, String sGroup, String[] varDims, String sAccount, String sCompany, String sClosVer, String sContVer, String sVerNr, String sVkod, String sBType, String sEType, String sCounterCompany, 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.DrillCompany(String sPerAkt, String sKoncTyp, String sGroup, Object varDims, String sAccount, String sCompany, String sClosVer, String sContVer, Boolean bConsolAjtAsBase, String sVerNr, String sVkod, String sBType, String sEType, String sCounterCompany, String sOriginCompany, Boolean bShowZeroValues)
at Cognos.Controller.Forms.Form.frmTrialBalance.DoDrill(String& sDrillOn, String& sPerakt, String& sConsType, String& sGroup, Object& varCompanies, String[]& sDims, String& sAccount, String& sCompany, String& sCloseVer, String& sContVer, String& sVKod, String& sBType, String& sEtype, String& sVerNr, String& sCounterCompany)
at Cognos.Controller.Forms.Form.frmTrialBalance.DrillDown()
at Cognos.Controller.Forms.Form.frmTrialBalance.tbDrillDown_ClickEvent(String strButtonName)


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.

Resolving the problem


Fix the invalid structures inside Controller.

  • Afterwards, it may also be necessary to.

More Information:
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").

Afterwards, in one real-life case a customer found that (even after performing the above) some (but not all!) users still got the error message when drilling into a company that formerly (used to) had a space in their name.
  • The solution to this was to perform the following steps:
    1. Move all of the relevant companies out of the linked structure
    2. Move all the relevant companies back in to the linked structure

Document information

More support for: Cognos Controller

Software version: 10.1.1

Operating system(s): Windows

Reference #: 1646599

Modified date: 13 September 2013

Translate this page: