Error "ORA-00001: Unique Constraint (ADMUSER.PK_SUMTRSRC) Violated" When Attempting to Execute the RESET_SUMTBL_PK Procedure to Reset Primary Keys on the SUMTRSRC Table (Doc ID 2757760.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

When attempting to execute the summarization record maintenance stored procedure per doc id 2104603.1, to restore summarization functionality, the following error occurs:

ERROR

Error starting at line : 1 in command -
begin
reset_sumtbl_pk('sumtrsrc');
end;
Error report -
ORA-00001: unique constraint (ADMUSER.PK_SUMTRSRC) violated
ORA-06512: at "ADMUSER.RESET_SUMTBL_PK", line 22
ORA-06512: at line 2
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
  For Trusted Oracle configured in DBMS MAC mode, you may see
  this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.


STEPS

The issue can be reproduced at will with the following steps:
1.  Connect to the database as the P6 schema owner.
2.  Execute the following to run the summarization record maintenance stored procedure:

begin
reset_sumtbl_pk('sumtrsrc');
end;

3.  Observe the reported error.

Cause

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