Error Saving Blender: The server returned an error: Violation of PRIMARY KEY constraint 'PkRmBlenderHierarchySet'. Cannot insert duplicate key in object 'dbo.RM_Blender_Hierarchy_Set'.

(Doc ID 2360723.1)

Last updated on FEBRUARY 20, 2018

Applies to:

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

Symptoms

 When trying to save a blender the following error is being seen:

 Error Saving Blender: The server returned an error: Violation of PRIMARY KEY constraint 'PkRmBlenderHierarchySet'. Cannot insert duplicate key in object 'dbo.RM_Blender_Hierarchy_Set'. 

Changes

One or more  Hierarchies that are not the last one entered have been deleted and a new one added.

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