Star ETL Process Does Not Complete Successfully When Using Custom SQL Script In The User Scripts Folder
Last updated on APRIL 12, 2018
Applies to:
Primavera Analytics - Version 17.7 and laterInformation 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