Skip to main content
Planview Customer Success Center

After restoring a Cognos contentstore DB, all data seems to have gone

Symptoms
We have restored a content store database from a different environment. When accessing Cognos, data that comes from the source environment cannot be seen in the target system; everything seems to be missing.


Resolution
After restoring, check the schema name in which the contentstore tables have been created. Typically this is Changepoint, CPSQLUser or CPADmin but it can be different. In the contentstore database, the database user that is created and linked to a login needs to have this same schema as default schema.

Also, in the Cognos configuration utility make sure to use the correct login to connect to the contentstore database. Do not use "sa", as it uses the dbo schema as default even though it has access to everything.

In case there is a mismatch between the schema names, the Cognos service will create a second, empty set of tables. Cognos will then access these empty tables, hence the data in the restored contentstore database will not be accessible.