AUT Not Revising Schema Version, Running agile9impdp Reports Error 'It does not match with Agile Oracle schema version' (Doc ID 2894537.1)

Last updated on JANUARY 24, 2024

Applies to:

Symptoms

Below error is reported when running agile9impdp.sh/agile9impdp.bat utility after upgrading Agile database schema using AUT (Automated Upgrade Tool):



 

Error

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Your database schema version is 9.3.xxx.
!!! It does not match with Agile Oracle schema version 9.3.yyy!!!
!!! Cancel this script and update the Agile schema!!!
!!! Otherwise unexpected errors may occur!!!
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Exit if versions mismatch, otherwise press Enter to continue.




Steps

The issue can be reproduced at will with the following steps:
1. From the location where AUT is installed, run aut.sh (for Linux)/aut.bat (for Windows) under %AUT_Home%\bin to upgrade Agile database schema
2. Run agile9expdp.sh (for Linux)/agile9expdp.bat (for Windows) under Agile database maintenance script location: %ORACLE_HOME%\admin\%ORACLE_SID%\create\agile to export Agile database schema
3. Run recreateagile.sh (for Linux)/recreateagile.bat (for Windows) under Agile database maintenance script location to refresh Agile database schema
4. Run agile9impdp.sh (for Linux)/agile9impdp.bat (for Windows) under Agile database maintenance script location to import the database schema exported in step 2. See the error message in the console

Changes

Upgraded Agile database schema using AUT

Cause

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