Agile Database Sequence Not Being Imported Correctly When Using Datapump (Doc ID 1191643.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.0.0 to 9.3.0.1 [Release 9.3]
Information in this document applies to any platform.
***Checked for relevance on 02-Mar-2015***

Symptoms

Many sequence related Averify errors reported after importing Agile database.

ERROR
-----------------------
AGIL-00000007 : C : A_PROJ_RSRC table has bad data (A_PROJ_RSRC Table ROW_ID is greater than the SEQ_ACTIVITY_ID Current Value <SEQ_ID>)
AGIL-00025055 : C : NODETABLE : table has bad data at id = <ID> (Table ID is greater than the SeqNodetable Current Value <SEQ_ID>)
AGIL-00025056 : E : PROPERTYTABLE : table has bad data at id = <ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025057 : E : ADMINICRITERIA : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025058 : E : BOM : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025059 : E : CHANGE : table has bad data at id = <ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025060 : E : CHANGE_HISTORY : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025061 : E : CRITERIA : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025062 : E : FOLDER : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025063 : E : ATTACHMENT : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025064 : E : VERSION : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025065 : E : ITEM : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025066 : E : ITEM_HISTORY : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025068 : E : QUERY : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025070 : E : REV : table has bad data at id = <Table_ID> (Table ID is greater than the Sequence ID <SEQ_ID>)
AGIL-00025141 : C : NOTIFICATION_FIELDS table has bad data (NOTIFICATION_FIELDS Table NOTIFIELD_PK id is greater than the NOTIFICATION_FIELDS_SEQ sequence Current Value <SEQ_ID)
AGIL-00025142 : C : NOTIFICATION_USER table has bad data (NOTIFICATION_USER Table NOTIUSER_PK id is greater than the NOTIFICATION_USER_SEQ sequence Current Value <SEQ_ID)
AGIL-00025143 : C : NOTIFICATION table has bad data (NOTIFICATION Table NOTI_PK id is greater than the NOTIFICATION_SEQ sequence Current Value <SEQ_ID)

FACT
-----------------------
Imported production instance database to test instance.
Datapump is used to import the Agile database.
Sequence related averify errors are not reported in the production server instance database.

STEPS
-----------------------
Steps to reproduce:
1. Stop Agile Application Server.
2. Run recreateagile
3. Run agile9impdp to import the database

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