IBM Support

Unable to run report in Cognos Connection: QE-DEF-0314 An error occurred while calling the content store for

Troubleshooting


Problem

When test the data source in Cognos Connection test successfully however running any report against this data source it gives an error. The same data source in Framework Manager also test successfully but the Query Subject fail when tested.

Symptom

Error in Cognos connection when running report. QE-DEF-0459 CCLException QE-DEF-0314 An error occurred while calling the content store for the database: ('anyname') CCL-RCI-0002 The Soap server returned a Soap fault. CM-REQ-4158 The search path dataSourceSignon('anyname') in invalid. CM-REQ-4078 The function 'dataSourceSignon'; has an invalid argument. CM-REQ-4075 A function call is invalid because the closing parenthesis is missing. Error in Framework Manager when testing Query Subject. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16' UDA-SQL-0353 An error was detected while processing the SQL request.

Cause

The data source in Framework Manager had an invalid entry for catalog.

Resolving The Problem

In Framework manager data source remove the invalid entry.Republish the package. Steps: 1. Open Framework manager and click on the erroring data source. 2. In the property window remove the value for catalog. 3. Retest the Query Subject in framework manager

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21341681

Page Feedback