Troubleshooting
Problem
On publishing a custom object, the following message appears:
"BMXAA7409E - The transformed object structures cannot be published to the Cognos server. To determine the cause, check the product log files. Metadata Provider Error"
Cogserver.log entries contain the following error information:
<ns1:severity>Error</ns1:severity><ns1:errorCode>0</ns1:errorCode>
<ns1:message>
<ns1:messageString>BMT-MD-0003 XQE-MD-0008 Could not bind [Data Source View].[ipo_test].[description]
XQE-MD-0008 Could not bind [Data Source View].[ipo_test].[hasld]
XQE-MD-0008 Could not bind [Data Source View].[ipo_test].[ipo_testid]
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[description]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[description]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[description]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[hasld]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[hasld]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[hasld]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[ipo_testid]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[ipo_testid]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[ipo_testid]'.
</ns1:messageString>
<ns1:nestingLevel>0</ns1:nestingLevel></ns1:message><ns1:message><ns1:messageString>BME-EX-0144
Trace back:</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel></ns1:message>
<ns1:message>
<ns1:messageString>BmtPlayTransaction.cpp(788):
BmtEngine: CCL_RETHROW:
BmtPlayTransaction::DoAction</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel>
</ns1:message><ns1:message>
<ns1:messageString>BmtActionsHelper.cpp(488): BmtEngine: CCL_RETHROW: BmtActionsHelper::DoAction</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel>
</ns1:message>
<ns1:message>
<ns1:messageString>BmtActionsHelper.cpp(488): BmtEngine: CCL_RETHROW: BmtActionsHelper::DoAction</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel>
</ns1:message>
<ns1:message>
<ns1:messageString>BmtActionSQL.cpp(255): BmtEngine: CCL_THROW: BMTMD_THROW_VALIDATE_RESPONSE</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel>
</ns1:message><ns1:message>
<ns1:messageString>
<ns1:message>
<ns1:messageString>BMT-MD-0003 XQE-MD-0008 Could not bind [Data Source View].[ipo_test].[description]
XQE-MD-0008 Could not bind [Data Source View].[ipo_test].[hasld]
XQE-MD-0008 Could not bind [Data Source View].[ipo_test].[ipo_testid]
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[description]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[description]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[description]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[hasld]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[hasld]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[hasld]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[ipo_testid]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[ipo_testid]'.
XQE-V5-0005 Identifier not found '[Data Source View].[ipo_test].[ipo_testid]'.
</ns1:messageString>
<ns1:nestingLevel>0</ns1:nestingLevel></ns1:message><ns1:message><ns1:messageString>BME-EX-0144
Trace back:</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel></ns1:message>
<ns1:message>
<ns1:messageString>BmtPlayTransaction.cpp(788):
BmtEngine: CCL_RETHROW:
BmtPlayTransaction::DoAction</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel>
</ns1:message><ns1:message>
<ns1:messageString>BmtActionsHelper.cpp(488): BmtEngine: CCL_RETHROW: BmtActionsHelper::DoAction</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel>
</ns1:message>
<ns1:message>
<ns1:messageString>BmtActionsHelper.cpp(488): BmtEngine: CCL_RETHROW: BmtActionsHelper::DoAction</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel>
</ns1:message>
<ns1:message>
<ns1:messageString>BmtActionSQL.cpp(255): BmtEngine: CCL_THROW: BMTMD_THROW_VALIDATE_RESPONSE</ns1:messageString>
<ns1:nestingLevel>1</ns1:nestingLevel>
</ns1:message><ns1:message>
<ns1:messageString>
Symptom
This is specific to Microsoft SQL Server only and cannot be reproduced in Oracle or DB2 database platforms.
Cause
Cognos Framework Manager fails to import columns in SQL query where the table name has an underscore (ipo_test).
Environment
Maximo 7.6.1
MS SQL Server 2016 & 2019
MS SQL Server 2016 & 2019
Resolving The Problem
Install the Cognos Analytics 11.0.13 Fix Pack 4 where issue does not occur.
Cognos Analytics 11.0.13 Fix Pack 4
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbQxAAK","label":"Reporting->Cognos Integration"}],"ARM Case Number":"TS004891545","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.6.1"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Installation and Configuration->Data Sources"},{"code":"a8m0z000000TN4sAAG","label":"Installation and Configuration->Database"},{"code":"a8m50000000Cl4NAAS","label":"Modeling->Framework Manager"}],"Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0.11;11.0.13"}]
Product Synonym
TPAESECURITY; TPAESS2016; TPAESS2019; TPAEREP;
Was this topic helpful?
Document Information
Modified date:
05 May 2022
UID
ibm16463943