HPCM - Intermittent Error: "EclipseLink-2004, ConcurrencyException, RollbackException" When Running Multiple Management Ledger Allocations Via Automation Script (Doc ID 2775971.1)

Last updated on AUGUST 22, 2024

Applies to:

Symptoms

Management Ledger Allocations fail intermittently when kicking off multiple allocation via automation script. Some allocation rules will run successfully while others intermittently fail with the following errors:

ERROR IN GUI:
-----------------------
EclipseLink-2004, ConcurrencyException, RollbackException


ERROR IN HPCM log:
-----------------------

[2021-03-15T13:40:59.189-04:00] [Profitability0] [WARNING] []
[org.eclipse.persistence.session.zip:D:/Oracle/Middleware/user_projects/domains/EPMSystem/servers/Profitability0/tmp/servers/Profitability0/tmp/_WL_user/PROFITABILITY_11.1.2.0/mig5y6/war/WEB-INF/lib/_wl_cls_gen.jar!/_hpm] [tid: 809]
[userId: <anonymous>] [ecid: 0000NWokcvLBp2KqySzW6G1WJkej000002,0:1] [APP:PROFITABILITY#11.1.2.0] [[Local Exception Stack:Exception [EclipseLink-4002] (Eclipse Persistence Services -2.3.1.v20111018-r10243):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException:
[FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in
object 'dbo.HPM_CALC_PROG_RULE' with unique index 'XAK1HPM_CALC_PROG_RULE'.
The duplicate key value is (3409, Select Accounts - Membership - Comm IndvdlSelf).
Error Code: 2601

Cause

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