My Oracle Support Banner

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 later
Information 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:

  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

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


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