My Oracle Support Banner

Sending a Workflow Type Record to the Next Step Processes for a Long Time and Eventually an Alert Pops-Up: Error2:0 error Status:0 -or- Error2:Internal Server Error Status:500 (Doc ID 2597663.1)

Last updated on DECEMBER 22, 2020

Applies to:

Primavera Unifier Cloud Service - Version 19.4 and later
Information in this document applies to any platform.

Symptoms

On Unifier : Version: 19.4

When attempting to create and route a workflow type business process record to the next step in the workflow and clicking on "Send" the process gets stuck with the 3 loading dots. Eventually, after some time, one of the following Alert's may pop-up:

ERROR
------------------

Alert Error2:0 error Status:0 -or- Error2:Internal Server Error Status:500

Something to the following may be found in the Unifier log files:

Error Msg = ORA-00001: unique constraint (UNIFIER.SYS_PROXY_HISTORY_PK) violated at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
[wrapped] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (UNIFIER.SYS_PROXY_HISTORY_PK) violated

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create and Send the workflow records to the next step in the workflow as the action never completes processing.

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.