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

Technote (troubleshooting)


Problem(Abstract)

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

Symptom


Error
Standard Error

Details:
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)

Cause

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:

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").


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Controller
Controller

Software version:

10.1.1

Operating system(s):

Windows

Reference #:

1646592

Modified date:

2013-08-16

Translate my page

Machine Translation

Content navigation