"No snapshot found" error when viewing Identity Manager reports after database change - Identity Manager

Products

• CA Identity Suite
• CA Identity Manager

Issue/Introduction

Users may receive a "No snapshot found" error when attempting to view reports following a migration to a new Identity Manager snapshot database. This error occurs because the new database schema does not automatically contain the environment and snapshot metadata required by the reporting module.

Environment

Identity Manager 14.5

Cause

When an Identity Manager environment is created, it populates the imrptsnapshots12 table with OOTB snapshot definitions and environment information. A newly created, empty database lacks this data, preventing the report server from identifying the existing environments.

Resolution

To resolve this issue and enable report functionality with the new database, migrate the required snapshot data from the original database:

1. Create the new database schema using the provided scripts.
2. Update the database connection parameters in Identity Manager via the "Modify Snapshot Database Connection: rptParamConn" task.
3. Update the database connection URL in standalone-full.xml on the application server.
4. Copy the existing data from the original database imrptsnapshots12 table into the corresponding imrptsnapshots12 table in the new database.
5. Restart the application server to ensure the changes take effect.