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'."
Last updated on APRIL 18, 2018
Applies to:Hyperion BI+ - Version 188.8.131.52.500 and later
Information in this document applies to any platform.
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: [FMWGEN][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 (00000155cb8ed6e2-0000-0299-0a90003d, 00000145f5e89f67-0000-d408-0a90003d, 0ad72262-0000-0a78-000000e95839004b)
The duplicate key value listed above is always different 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.
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