My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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


The issue can be reproduced at will with the following steps:

  1. Export Agile database schema dmp from source instance
  2. On the target instance, import the Agile database schema exported in step 1
  3. See AUT is stuck while running sql at the back end
  4. 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

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