Issue in Partition Purge
(Doc ID 2736337.1)
Last updated on JANUARY 19, 2021
Applies to:Oracle Communications Order and Service Management - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
It is observed the below error message while performing partition purge in OSM
Error starting at line : 2 in command -
a_online => false,
a_delete_before => trunc(sysdate) - 30,
a_order_states => om_new_purge_pkg.v_closed_orders,
a_drop_empty_ptns => true,
a_purge_xchg_prg_tables => true,
a_parallelism => 32,
a_stop_date => to_date('20-11-2020 08:10','DD-MM-YYYY HH24:MI'),
Error report -
ORA-12801: error signaled in parallel query server P00Z, instance DCOB21-000:PRWOM11 (1)
ORA-00001: unique constraint (PROD_ORDERMGMT.XCHG_OM_BCK_$001$_PK) violated
ORA-06512: at "PROD_ORDERMGMT.OM_PART_MAINTAIN", line 6906
ORA-06512: at line 2
12801. 00000 - "error signaled in parallel query server %s"
*Cause: A parallel query server reached an exception condition.
*Action: Check the following error message for the cause, and consult
your error manual for the appropriate action.
*Comment: This error can be turned off with event 10397, in which
case the server's actual error is signaled instead.
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