My Oracle Support Banner

Financial Reporting (FR) Scheduled Batch Fails With Error: "Violation of PRIMARY KEY constraint 'PK_V8_ACCESS_CTRL'. Cannot insert duplicate key in object 'dbo.V8_ACCESS_CTRL'." (Doc ID 2162270.1)

Last updated on JANUARY 15, 2020

Applies to:

Hyperion BI+ - Version 11.1.2.3.500 and later
Information in this document applies to any platform.

Symptoms

You're scheduling FR batches to create snapshot reports as their output, but this results in errors when the batches run:

javax.jcr.RepositoryException: System 9 Platform error: [XXXXX][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_V8_ACCESS_CTRL'. Cannot insert duplicate key in object 'dbo.V8_ACCESS_CTRL'. The duplicate key value is (<UUID1>, <UUID2>, <UUID 3>)

NOTE: <UUID#> placeholders used above represent the 35-character hexidecimal Universally Unique ID strings.  The actual UUID values shown in the duplicate key message vary for each error/run.

It has been also recognized that the permissions specified in the bursting file (CSV comma delimited format) are not being correctly applied during/after the batch run.

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.