My Oracle Support Banner

Issue in Partition Purge (Doc ID 2736337.1)

Last updated on JANUARY 19, 2021

Applies to:

Oracle Communications Order and Service Management - Version 7.3.5.0.0 and later
Information in this document applies to any platform.

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

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.