IBM Support

XQE-DAT-0001 error when attempting to open report studio after running a backup of content store

Troubleshooting


Problem

After running a backup of the content store, Cognos Connection returns the error message "XQE-DAT-0001" when the user attempts to open a report in report studio.

Symptom

"XQE-DAT-0001 - Data Source Adapter Error: Invalid operation: Connection is closed. ERRORCODE = -4470, SQLSTATE =08003"

Cause

When backing up the content store, the database used by the content store was put into offline mode, which disconnects Cognos from the database. The offline mode was set as a user requirement. Cognos does not automatically reconnect to the database.

Environment

Content store on DB2

Resolving The Problem

Restart Cognos Service

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21618965