My Oracle Support Banner

Unable to Close DD Task for PSR Service Order - Receiving Error: Java SQLIntegrityConstraintViolationException: ORA-02292 - (ASAP.CIR_POS__CIR_POS_PEN) (Doc ID 2070589.1)

Last updated on OCTOBER 23, 2018

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

Unable to close DD task on PSR service order: 409694 Receiving the attached error messages

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

sqlerror:1
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN) violated - child record found
ORA-06512: at "ASAP.SP_REMOVE_BASE_TFC_ASSIGNMENTS", line 104
ORA-06512: at "ASAP.SP_CHANGE_CIRCUIT_STATUS", line 1675
ORA-06512: at "ASAP.SP_COMPLETE_PSR", line 48
ORA-06512: at "ASAP.SP_TASK_COMPLETE", line 207
ORA-06512: at line 1

When he clicks ‘OK’, he get another error message:

The ‘Details’ button on this error message also reveals a text box with the following:

ORA-02292: integrity constraint (ASAP.CIR_POS__CIR_POS_PEN) violated - child record found
ORA-06512: at "ASAP.SP_REMOVE_BASE_TFC_ASSIGNMENTS", line 104
ORA-06512: at "ASAP.SP_CHANGE_CIRCUIT_STATUS", line 1675
ORA-06512: at "ASAP.SP_COMPLETE_PSR", line 48
ORA-06512: at "ASAP.SP_TASK_COMPLETE", line 207
ORA-06512: at line 1

When he click’s ‘OK’ here, and gets this message:

  Error completing task

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try completing DD task for order 409694
2. Users are getting the errors listed above.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Order cannot be completed.
.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.