Fails to Create Item with Error: Null Reached the Maximum Limit After Importing Agile Database Schema
(Doc ID 2810780.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Agile Product Collaboration - Version 9.3.6.0 and laterInformation in this document applies to any platform.
Symptoms
After importing Agile database schema, unable to create Item with below error:
Error
null reached the maximum limit. Please report this to your system administrator
Steps
The issue can be reproduced at will with the following steps:
- On the source instance, run agile9expdp utility under $ORACLE_BASE/admin/{sid}/create/agile to export Agile database schema dmp file
- Copy the dmp file to the target instance under $ORACLE_BASE/admin/{sid}/create/agile
- On the target instance, edit agile9impdp.par file under $ORACLE_BASE/admin/{sid}/create/agile, and update the value for dumpfile so that it will point to the dmp file copied in step 2
- Run recreateagile utility under $ORACLE_BASE/admin/{sid}/create/agile
- Run agile9impdp utility under $ORACLE_BASE/admin/{sid}/create/agile to import the database dmp file
- Restart Agile Application Server
- Log into Web Client, and create a new Item
- Gets error in the UI
- Log into Java Client as admin user, and go to Admin tab > Data Settings > AutoNumbers, and open Part Number. See Next Number is reset to the first number (i.e. P00001)
- On the source instance, log into Java Client as admin user, and go to Admin tab > Data Settings > AutoNumbers, and open Part Number. See Next Number is showing different (i.e. P376935)
Changes
Imported Agile database schema exported from another instance
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 |