AUT Is Not Completing and Stuck While Running SQL at the Backend
(Doc ID 2862038.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Agile PLM Framework - Version 9.3.6.0 and laterInformation in this document applies to any platform.
Symptoms
Actual Behavior
While upgrading Agile database schema using AUT (Automated Upgrade Tool), it gets stuck while running the sql at the backend. It takes very long time (hours) to complete.
Expected Behavior
AUT to complete successfully without getting stuck while running sql at the back end
Steps
The issue can be reproduced at will with the following steps:
- Export Agile database schema dmp from source instance
- On the target instance, import the Agile database schema exported in step 1
- See AUT is stuck while running sql at the back end
- Check AUT.log generated under %AUT%\logs, and can see the log is pending for long time at the same line
Changes
Agile database schema dmp from the source instance was imported to target instance prior to run AUT using indexes=n option
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 |