Deleting Files from Newly Created Document Revision (with All Structures) Returns Error : Internal Database Error in "zag_dbi_upd_id_int" (EPSQL "epqupd") Code -948 (Doc ID 1982588.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.3.0 to 6.1.3.0 [Release 6.1.0]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
--------------------------
On Agile e61.3.0 HF05

When attempting to delete files from newly created document revision (with all structures)
receiving error
... Internal Database Error in "zag_dbi_upd_id_int" (EPSQL "epqupd") Code -948
... OCI Error: -1 / ORA-00001: unique constraint (PLMREF.EDB_DOC_FIL_R) violated


STEPS:
---------------------
1. Create a document and assign at least 2 files
2. Release this document (Status Change from 110 to 120 to 230)
3. Change status to PI 240 (In change)
4. Create a new revision (with all structures) of this document
5. Delete the files of the new revision
6. Clear trash basket
7. Receive error
... Internal Database Error in "zag_dbi_upd_id_int" (EPSQL "epqupd") Code -948
... OCI Error: -1 / ORA-00001: unique constraint (PLMREF.EDB_DOC_FIL_R) violated


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