ETL Fails Then Automatically Restarts And Executes Successfully (Showing An OK Status) But Log File Shows Failure (And What Looks To Be Reference To The First ETL Failure)
Last updated on MAY 21, 2018
Applies to:Primavera Analytics - Version 17.7 and later
Primavera Analytics Cloud Service - Version 17.7 and later
Information in this document applies to any platform.
The scheduled ETL shows as failed, but then immediately after the failure a new ETL is kicked off and shows a status of OK. However, the subsequent ETL displays a log file with a failure which makes it appear as if the subsequent ETL execution did not run successfully.
Example log for a P6 Datasource generated from the secondary run:
Load plan [LOAD_PLAN_DAILY] started, instance id = 5389
[RUNNING] Load dimension and fact tables
Pre-ETL Tasks for Textura
[RUNNING] P6 Daily
[DONE] Status daily run start, duration = 1 seconds
[RUNNING] Case Data Source Type
SQL scripts after loading part 1
SQL scripts after loading part 2
[DONE] Security Staging Updates, duration = 13 seconds
[DONE] For scheduled interval projects, duration = 288 seconds
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 416 seconds
-- End --
For the ETL to complete successfully and generate a log file which either a) shows what the cause of failure is or b) shows a log file from the consecutive execution with better detail to the successful run.
The issue can be reproduced at will with the following steps:
- Login to the Analytics Administration Application
- Schedule the ETL to run at a scheduled interval time of your choosing.
- When the ETL executes at the defined interval, if it fails, note that a new ETL is automatically executed.
- The new ETL executes successfully but when clicking the View Log link, it generates a log file which shows an ETL failure (which appears to be the log from the first run)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms