AUT Is Not Completing and Stuck While Running SQL at the Backend
(Doc ID 2862038.1)
Last updated on APRIL 11, 2022
Applies to:Oracle Agile PLM Framework - Version 188.8.131.52 and later
Information in this document applies to any platform.
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.
AUT to complete successfully without getting stuck while running sql at the back end
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
Agile database schema dmp from the source instance was imported to target instance prior to run AUT using indexes=n option
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