My Oracle Support Banner

Star ETL Process Does Not Complete Successfully When Running a Custom SQL Script from the User_Scripts Folder (Doc ID 2383161.1)

Last updated on MARCH 18, 2022

Applies to:

Primavera Analytics - Version 17.7 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

When running a custom script to update project names, the records get updated but the ETL process appears to have stuck at step 56.  The Primavera Analytics Administration page shows the process is in Running status.

EXPECTED BEHAVIOR

The ETL Process should complete successfully.

 

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

  1. Add a custom script to the USER_Scripts folder, then run the ETL process.
  2. Note the reported issue.

Changes

 

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!

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