Technote (troubleshooting)
Problem(Abstract)
User clicks "Group - Reports - Trial Balance with Drilldown". User chooses parameters and then clicks "Preview". User receives error message.
Not all parameters will trigger the problem. In one real-life case the problem was triggered when using:
* linked actualities
* and also non-linked actualities with currency type "L".
Symptom
Error
Standard Error
[Details] [OK]
Error Details
Source: FrangoDirect.TrialBalanceD.GetClosContReportData#ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x80040E14): The multi-part identifier "d.vkodlc" could not be bound.
at FrTrialBalanceB.TrialBalanceNYKOMOBClass.GetClosContReportData(String sGuid, String sUser, Int32 lLocaleID, String sPerAkt, String sKoncTyp, String sGroup, Object varCompanies, Object varClosVer, Object varContVer, Boolean bConsolAjtAsBase, String sCurType, String sCurrencyCode, String sForms, String sAccount, Object varDims, Boolean bShowEmptyLines, Boolean bShowZeroValues, Boolean bBTypesAsReportedValues, String sClosingVersionForReportedValues)
at Cognos.Controller.Proxy.CCRWS.TrialBalanceNYKOMOB_GetClosContReportData(String sGuid, String sUser, Int32 lLocaleID, String sPerAkt, String sKoncTyp, String sGroup, Object varCompanies, Object varClosVer, Object varContVer, Boolean bConsolAjtAsBase, String sCurType, String sCurrencyCode, String sForms, String sAccount, Object varDims, Boolean bShowEmptyLines, Boolean bShowZeroValues, Boolean bBTypesAsReportedValues, String sClosingVersionForReportedValues)
--- 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)
Event Viewer (Application Log):
Log Name: Application
Source: VBRuntime
Date: 11/02/2013 16:22:03
Event ID: 1
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVERNAME
Description:
The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 5552 ,Logged: Error occured at 11/02/2013 16:22:03 in FrSrvFunc, Error No=-2147217900, Source=Server function:Dbp_ExecuteImmediateWithRowCount(..) , Description=The multi-part identifier "d.vkodlc" could not be bound., HelpFile= HelpContext=0
Log Name: Application
Source: Cognos Controller
Date: 11/02/2013 16:22:03
Event ID: 0
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVERNAME
Description:
Error occured at 11/02/2013 16:22:03 in IBM Cognos Controller, Error No=5, Source=FrangoDirect.TrialBalanceD.GetClosContReportData#ControllerProxyClient, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x80040E14): The multi-part identifier "d.vkodlc" could not be bound.
at FrTrialBalanceB.TrialBalanceNYKOMOBClass.GetClosContReportData(String sGuid, String sUser, Int32 lLocaleID, String sPerAkt, String sKoncTyp, String sGroup, Object varCompanies, Object varClosVer, Object varContVer, Boolean bConsolAjtAsBase, String sCurType, String sCurrencyCode, String sForms, String sAccount, Object varDims, Boolean bShowEmptyLines, Boolean bShowZeroValues, Boolean bBTypesAsReportedValues, String sClosingVersionForReportedValues)
at Cognos.Controller.Proxy.CCRWS.TrialBalanceNYKOMOB_GetClosContReportData(String sGuid, String sUser, Int32 lLocaleID, String sPerAkt, String sKoncTyp, String sGroup, Object varCompanies, Object varClosVer, Object varContVer, Boolean bConsolAjtAsBase, String sCurType, String sCurrencyCode, String sForms, String sAccount, Object varDims, Boolean bShowEmptyLines, Boolean bShowZeroValues, Boolean bBTypesAsReportedValues, String sClosingVersionForReportedValues)
--- End of inner exception stack trace ---
Cause
Code production problem (APAR PM82879) in Controller.
Resolving the problem
Upgrade to Controller 10.1.2155 or later.
Related information
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.