Issue in Partition Purge (Doc ID 2736337.1)

Last updated on MARCH 27, 2023

Applies to:

Symptoms

It is observed the below error message while performing partition purge in OSM

Error starting at line : 2 in command -
begin
om_part_maintain.purge_partitions(
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_order_id_ge =>236000001,
a_stop_date => to_date('20-11-2020 08:10','DD-MM-YYYY HH24:MI'),
a_order_id_lt=>239000001
) ;
end;
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.

Changes

Cause

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