Data Warehouse ETL Executed From The Analytics Administration Application Moves To A Queued Status But Never Runs

(Doc ID 2353508.1)

Last updated on JANUARY 30, 2018

Applies to:

Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Primavera Data Warehouse - Version 17.11.0.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
When attempting to execute an ETL from the Analytics Administration application for moving data into Data Warehouse for usage of Primavera Analytics, the status moves into a "queued" state but never runs.

EXPECTED BEHAVIOR
When attempting to execute an ETL from the Analytics Administration application for moving data into Data Warehouse for usage of Primavera Analytics, the status should move into a queued to running state.


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

  1. Connect to the Analytics Administration Application (https://nyuhospitals-dev-primavera.oracleindustry.com/p6rdb)
  2. Select the associated data source you are wish to run an ETL (for example, staretl2 for Unifier source)
  3. Click RunETL
  4. Select the Home link and note the status stays in queued indefinitely.
  5. Additionally, select the datasource link (for example, staretl2) > status and note that there is no new entry for a running ETL process

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