Error ORA-00001: unique constraint (AGILE.xxxxx_PK) violated (Doc ID 1592261.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.1.2 and later
Information in this document applies to any platform.

Symptoms

Can't save any user profile changes
Cannot save any changes

Error: ORA-00001: unique constraint (AGILE.ITEM_HISTORY_PK) violated.

Averify errors:

AGIL-00025061 : C : CRITERIA :  table has bad data at id = 16322225 (Table ID is greater than the Sequence ID 16321921)                                                                                
AGIL-00025064 : C : VERSION :  table has bad data at id = 16323686 (Table ID is greater than the Sequence ID 16321981)                                                                                  
AGIL-00025065 : C : ITEM :  table has bad data at id = 16322672 (Table ID is greater than the Sequence ID 16322001)                                                                                    
AGIL-00025066 : C : ITEM_HISTORY :  table has bad data at id = 16323231 (Table ID is greater than the Sequence ID 16322021)                                                                            
AGIL-00025068 : C : QUERY :  table has bad data at id = 16323948 (Table ID is greater than the Sequence ID 16322041)                                                                                    
AGIL-00025070 : C : REV :  table has bad data at id = 16323676 (Table ID is greater than the Sequence ID 16322081)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms