DRM Relational Database Schema Has Been Restored from Backup but the DRM Application Will Not Start and 'ORA-00001: unique constraint (PR_DB.PK_RMTRANSACTIONHISTORY) violated' (Doc ID 1603308.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Data Relationship Management - Version 11.1.2.0.00 and later
Information in this document applies to any platform.

Symptoms

After restoring a DRM relational database schema and then trying to start DRM the following error is seen:

ORA-00001: unique constraint (PR_DB.PK_RMTRANSACTIONHISTORY) violated

Changes

 The DRM relational database schema has been restored from a backup.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms