"(0x80040E14) ... "d.vkodlc" could not be bound" using Trial Balance with Drilldown (mainly for linked actualities)

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

APAR PM82879

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 #:

1625211

Modified date:

2013-04-26

Translate my page

Machine Translation

Content navigation