Star ETL Process Does Not Complete Successfully When Using Custom SQL Script In The User Scripts Folder

(Doc ID 2383161.1)

Last updated on APRIL 12, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
When using the customized script to update project names, running ETL process appears to have stuck at step 56. It does update the records but afterwards it doesn't progress. Primavera Analytics Administration page shows the status in 'running' mode.

EXPECTED BEHAVIOR
-----------------------
ETL Process to complete successfully.

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

   1. Put customized script in the USER_Scripts folder

   2. After placing the script, run ETL Process

   3. Notice that the script was executed successfully and records are updated

   4. Notice in the logs that ETL process is stuck at step 56 AND Primavera Analytics Administration page shows the status is in running status

Cause

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 hundreds of Community platforms