Error completing Due Date (DD) task; java.sql.SQLException: ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN) violated - child record found
(Doc ID 946129.1)
Last updated on AUGUST 24, 2023
Applies to:
Oracle Communications MetaSolv Solution - Version 6.0.15 and laterInformation in this document applies to any platform.
This problem can occur on any platform.
Symptoms
The Due Date task cannot be completed because of a "java.sql.SQLException: ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN) violated - child record found" error.
Screenshot of error:
Error text:
A data-related error occurred. Please use the detail button for more information.
java.sql.SQLException: ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN)
violated - child record foundORA-06512: at
"ASAP.SP_REMOVE_BASE_TFC_ASSIGNMENTS",line 104ORA-06512: at
"ASAP.SP_CHANGE_CIRCUIT_STATUS",line 1675ORA-06512: at
"ASAP.SP_COMPLETE_PSR",line 48ORA-06512: at "ASAP.SP_TASK_COMPLETE",
line 187ORA-06512: at line 1
java.sql.SQLException: ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN)
violated - child record foundORA-06512: at
"ASAP.SP_REMOVE_BASE_TFC_ASSIGNMENTS",line 104ORA-06512: at
"ASAP.SP_CHANGE_CIRCUIT_STATUS",line 1675ORA-06512: at
"ASAP.SP_COMPLETE_PSR",line 48ORA-06512: at "ASAP.SP_TASK_COMPLETE",
line 187ORA-06512: at line 1
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 |