My Oracle Support Banner

Staretl Fails with [ERROR] PROC_LOAD_ASSIGNMENT_SPREAD_HISTORY (Doc ID 2737229.1)

Last updated on DECEMBER 21, 2020

Applies to:

Primavera Analytics Cloud Service - Version 20.10 to 20.11 [Release 20.10 to 20.11]
Information in this document applies to any platform.

Symptoms

When attempting to execute the staretl,
the following error occurs.

ERROR
-----------------------
[ERROR] PROC_LOAD_ASSIGNMENT_SPREAD_HISTORY
  [DONE] 0 \-\ VAR_DATASOURCE_ID
  [DONE] 1 /-/ Variable - VAR_DATASOURCE_ID - null
  [DONE] 1 \-\ VAR_SCD_ONLY
  [DONE] 2 /-/ Variable - VAR_SCD_ONLY - null
  [DONE] 2 \-\ VAR_EFFECTIVE_START_DATE
  [DONE] 3 /-/ Variable - VAR_EFFECTIVE_START_DATE - null
  [DONE] 3 \-\ VAR_HISTORY_ENABLED
  [DONE] 4 /-/ Variable - VAR_HISTORY_ENABLED - null
  [ERROR] 4 \-\ Load Assignment Spread History
  [ERROR] 5 /-/ Procedure - Load Assignment Spread History - Load Assignment Spread History
  [ERROR] Load assignment spread history, duration = 82 seconds


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute or allow scheduled etl to execute.

Changes

Environment upgrade to release 20.11.

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.