My Oracle Support Banner

Fails to Create Item with Error: Null Reached the Maximum Limit After Importing Agile Database Schema (Doc ID 2810780.1)

Last updated on SEPTEMBER 29, 2021

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information 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:

  1. On the source instance, run agile9expdp utility under $ORACLE_BASE/admin/{sid}/create/agile to export Agile database schema dmp file
  2. Copy the dmp file to the target instance under $ORACLE_BASE/admin/{sid}/create/agile
  3. 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
  4. Run recreateagile utility under $ORACLE_BASE/admin/{sid}/create/agile
  5. Run agile9impdp utility under $ORACLE_BASE/admin/{sid}/create/agile to import the database dmp file
  6. Restart Agile Application Server
  7. Log into Web Client, and create a new Item
  8. Gets error in the UI
  9. 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)
  10. 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


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