Scheduled Valuation Is Not Completing Randomly - No Deadlocks (Doc ID 2039265.1)

Last updated on AUGUST 12, 2015

Applies to:

Oracle Insurance Policy Administration J2EE - Version 9.6.1.19 to 9.6.1.20 [Release 9.6]
Information in this document applies to any platform.

Symptoms

On : 9.6.1.19 version, Cycle Issues

When running Scheduled Valuation the job randomly fails. This has only been reported in one, non-production environment.

  java.lang.IllegalStateException: Identifier:Identifier{GUID} already exists.

ERROR
---------
Violation of PRIMARY KEY constraint 'PK_ASCYCLEDETAIL'. Cannot insert duplicate key in object 'dbo.ASCYCLEDETAIL'. The duplicate key value is ([CycleGUID], [CycleDetailGUID], )

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users must monitor cycle to ensure it completes successfully.

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