IBM Support

Unable to create blank Content Store / migrate Content Store for IBM Cognos 10.2 against Sybase ASE 15.0.3

Troubleshooting


Problem

User is unable to create a new content store or upgrade it to Cognos BI 10.2 by introducing a copy of the old content store against the new environment.

Symptom

CM-CFG-5043 Column information is not available for the content
store column CMDATA.DATASIZE associated with property 'dataSize'

Cause

Sybase 15.0.3 was only running on ESD#3

Environment

Only with Cognos BI 10.2
and
Sybase 15.0.3 ESD3 running on Solaris x86

Problem was not reproducable if Sybase was running on different Systems.

Diagnosing The Problem

Cognos Service will not start properly with:
CM-CFG-5063 A Content Manager configuration error was
detected while connecting to the content store. CM-CFG-5040 Content
Manager cannot load object class definitions from the content store.
Cause: CM-CFG-5043 Column information is not available for the content
store column CMDATA.DATASIZE associated with property 'dataSize'.
Stack trace: CM-CFG-5043 Column information is not available for the
content store column CMDATA.DATASIZE associated with property
'dataSize'. at
com.cognos.cm.dbstore.CMDbProperty.validateDatabaseParameters(CMDbProper
ty.java:470) at
com.cognos.cm.dbstore.CMDbProperty.<init>(CMDbProperty.java:154)
at
com.cognos.cm.dbstore.CMDbPropertySet.loadProperty(CMDbPropertySet.java:
115)

Resolving The Problem

Upgrade Sybase to Version 15.0.3 ESD#4
or a higher base Version like 15.5 / 15.7

Related Information

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Install and Config","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF033","label":"Windows"},{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"},{"code":"PF010","label":"HP-UX"}],"Version":"10.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21622423