Workflow Error 'http Status 500 - Internal Server Error Transaction (Process Id 93) Was Deadlocked'
(Doc ID 3000046.1)
Last updated on FEBRUARY 01, 2024
Applies to:
Oracle Insurance Policy Administration J2EE - Version 11.2.0.24 and laterInformation in this document applies to any platform.
Symptoms
On : 11.2.0.24 version, Workflow
When users attempt to access the Workflow page, the following message is reported:
ERROR
-----------------------
HTTP Status 500 - Internal Server Error.
Failure.Message: Javax.persistence.PersistenceException: Exception {EclipseLink-4002]
Internal Exception: java.sql.SQlException: Transaction (Process ID 93) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.
Rerun the transaction. Error Code: 1205 Call: SELECT SUM (t.totalresults) Total
FROM (
SELECT COUNT( DISTINCT ASWORKFLOWTASK.WORKFLOWTASKGUID ) totalresults
FROM ASWORKFLOWTASK
INNER JOIN AsPolicy AsPolicy ON AsPolicy.PolicyGuid = ASWORKFLOWTASK.ENTITYGUID
AND ASWORKFLOWTASK.ENTITYCODE='POLICY'
LEFT OUTER JOIN ASCODE ON ASCODE.CODEVALUE = ASWORKFLOWTASK.STATUSCODE
AND ASCODE.CODENAME = 'AsCodeWorkflowTaskStatus'
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OIPA.
2. Attempt to access the Workflow Page.
Changes
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 |
| Changes |
| Cause |
| Solution |