My Oracle Support Banner

LOAD_PLAN_REALTIME_PROJECT ETL Service Failing on History Merge Steps (Doc ID 2522799.1)

Last updated on OCTOBER 03, 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 checking the status of the  LOAD_PLAN_REALTIME_PROJECT, in an Analytics ODI environment, the plan is failing and the following errors can be found in the log:

ERROR

[ERROR] PROC_AFTER_LOADING_PKG_PROJECT
    [ERROR] PROC_MERGE_ACTIVITY_HISTORY_MONTH
    [DONE] 0 \-\ VAR_SCD_ONLY
    [DONE] 1 /-/ Variable - VAR_SCD_ONLY - null
    [ERROR] 1 \-\ Merge Activity History Month
    [ERROR] 2 /-/ Procedure - Merge Activity History Month - Merge Activity History Month
    ODI-1228: Task Procedure-Merge Activity History Month-Merge Activity History Month fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
    Caused By: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at "STARUSER.HIST_MERGE_PKG", line 1458
    ORA-06512: at line 5

[ERROR] PROC_MERGE_ACTIVITY_HISTORY
    [DONE] 0 \-\ VAR_SCD_ONLY
    [DONE] 1 /-/ Variable - VAR_SCD_ONLY - null
    [ERROR] 1 \-\ Merge Activity History
    [ERROR] 2 /-/ Procedure - Merge Activity History - Merge Activity History
    ODI-1228: Task Procedure-Merge Activity History-Merge Activity History fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
    Caused By: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at "STARUSER.HIST_MERGE_PKG", line 60
    ORA-06512: at line 3

[ERROR] PROC_MERGE_PROJECT_HISTORY
    [DONE] 0 \-\ VAR_SCD_ONLY
    [DONE] 1 /-/ Variable - VAR_SCD_ONLY - null
    [ERROR] 1 \-\ Merge Project History
    [ERROR] 2 /-/ Procedure - Merge Project History - Merge Project History
    ODI-1228: Task Procedure-Merge Project History-Merge Project History fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
    Caused By: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at "STARUSER.HIST_MERGE_PKG", line 242
    ORA-06512: at line 6

[ERROR] PROC_MERGE_ACTIVITY_HISTORY_WEEK
    [DONE] 0 \-\ VAR_SCD_ONLY
    [DONE] 1 /-/ Variable - VAR_SCD_ONLY - null
    [ERROR] 1 \-\ Merge Activity History Week
    [ERROR] 2 /-/ Procedure - Merge Activity History Week - Merge Activity History Week
    ODI-1228: Task Procedure-Merge Activity History Week-Merge Activity History Week fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
    Caused By: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at "STARUSER.HIST_MERGE_PKG", line 120
    ORA-06512: at line 4

[ERROR] PROC_MERGE_WBS_HISTORY
    [DONE] 0 \-\ VAR_SCD_ONLY
    [DONE] 1 /-/ Variable - VAR_SCD_ONLY - null
    [ERROR] 1 \-\ Merge WBS History
    [ERROR] 2 /-/ Procedure - Merge WBS History - Merge WBS History
    ODI-1228: Task Procedure-Merge WBS History-Merge WBS History fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
    Caused By: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at "STARUSER.HIST_MERGE_PKG", line 1405
    ORA-06512: at line 7

[ERROR] After loading package project, duration = 9370 seconds
[ERROR]Load plan [LOAD_PLAN_DAILY] completed, duration = 11188 seconds


Changes

 

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
Changes
Cause
Solution
References


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