My Oracle Support Banner

LOAD_PLAN_DAILY (ETL) Fails with Oracle Database Error ORA-02085 (Doc ID 2445630.1)

Last updated on DECEMBER 05, 2019

Applies to:

Primavera Analytics Cloud Service - Version 18.1 and later
Primavera Analytics - Version 18.8 and later
Information in this document applies to any platform.

Symptoms

When attempting to execute an ODI ETL on Primavera Analytics Administration, the following error occurs:

ERROR

<TIMESTAMP>.... Starting loadPlan LOAD_PLAN_DAILY
Load plan [LOAD_PLAN_DAILY] started, instance id = XXX
  [RUNNING] Load dimension and fact tables
  Pre-ETL Tasks for XXXX
  Pre-ETL Tasks
[RUNNING] P6 Daily
  [ERROR] For scheduled interval projects, duration = 6 seconds
  [ERROR] RUNNER_SCHEDULED_P6
......
 ODI-1227: Task Procedure-Gather Spread Update Count-Gather activity spread update count fails on the source connection PRIMAVERA_ANALYTICS_TGT_DS. Caused By: java.sql.SQLSyntaxErrorException: ORA-02085: database link XXXXXXXX.INT.ORACLEINDUSTRY.COM connects to XXXXXXXX.INT.ORACLEINDUSTRY.COM at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407) at
......


STEPS

The issue can be reproduced at will with the following steps:
1.  Run an ETL manually.
2.  Observe the ETL fails with the above error.

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot complete ETL successfully.

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!


In this Document
Symptoms
Cause
Solution


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