Troubleshooting
Problem
Required upgrade to Cognos 11.1.7 Long Term Support release to apply fixes no longer made in 11.0.13 and for compatibility with newer JRE 8 releases. NOTE: MSSQL JDBC driver 7.4.1 causes workspaces to fail.
Symptom
![image-20220321160309-1](/support/pages/system/files/inline-images/image-20220321160309-1.png)
Cause
Microsoft SQL Server JDBC driver 7.4.1 fails to return column metadata when table name includes underscore character
Environment
MSSQL database used for Control Center.
Diagnosing The Problem
Review the errors in the Control Center data collector. Verify the JDBC Driver used.
XQE-V5-0005 Identifier not found
Resolving The Problem
To resolve this workspace issue, use the 7.2.2 driver (i.e. mssql-jdbc-7.2.2.jre8.jar).
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":"SS9GLA","label":"IBM Control Center"},"ARM Category":[{"code":"a8m0z000000cwW9AAI","label":"REPORTING\/COGNOS"}],"ARM Case Number":"TS008258118","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1.3"}]
Was this topic helpful?
Document Information
Modified date:
21 March 2022
UID
ibm16565101