Runetl Process Step 1, Part 1 Fails With Error: Original Exception: java.lang.OutOfMemoryError (Doc ID 2250407.1)

Last updated on MAY 15, 2017

Applies to:

Primavera Data Warehouse - Version 6.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run ETL, the following error occurs.

ERROR
-----------------------

<DateTime> [INFO] (Message) - Connecting to jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.52.19) (PORT=1551))(CONNECT_DATA=(SERVICE_NAME=P6TRN1))) as STAGEUSER
<DateTime> [INFO] (Message) - === Step 1, Part 1 ====================================================
<DateTime> [INFO] (Message) - === Run the ETL calculation process (StartETLJava)

<DateTime> [WARN] (Message) - Spread loading thread 2: There was a problem processing a record for the ACTIVITYSPREAD table : com.primavera.PhoenixException
Object Identifier: ACTIVITYSPREAD Project MECHANICAL SCHEDULE STUDY - DB Schedule (103675 JS3- A1a-RCCV)
Primary Key(s): 15893
<DateTime> [WARN] (Message) - Spread loading thread 5: There was a problem processing a record for the ACTIVITYSPREAD table : com.primavera.PhoenixException
Object Identifier: ACTIVITYSPREAD Project Global Service Events Schedule (GSES)
Primary Key(s): 15644
<DateTime> [WARN] (Message) - Spread loading thread 4: There was a problem processing a record for the ACTIVITYSPREAD table : com.primavera.PhoenixException f
Object Identifier: ACTIVITYSPREAD Project EDF West Burton Unit 2 CMV (Client rev AJ) EPM schedule (102347-EPM-20)
Primary Key(s): 15889
<DateTime> [WARN] (Message) - Spread loading thread 1: There was a problem processing a record for the ACTIVITYSPREAD table : com.primavera.PhoenixException
Object Identifier: ACTIVITYSPREAD Project Lynemouth Construction - Detail (100935.C.1-1)
Primary Key(s): 15959
<DateTime> [WARN] (Message) - Spread loading thread 3: There was a problem processing a record for the ACTIVITYSPREAD table : com.primavera.PhoenixException
Object Identifier: ACTIVITYSPREAD Project PROPOSALS WORKLOAD FORWARD PLAN - UK Proj. Opportunities (PWFP-2015_ Wk50)
Primary Key(s): 15891
<DateTime> [WARN] (Message) - There was a problem processing a record for the RESOURCEASSIGNMENT table : java.lang.OutOfMemoryError
Object Identifier: RESOURCEASSIGNMENT for resource PLAD on activity A89700 in project Tender U3 66 Day
Primary Key(s): 312531
<DateTime> [ERROR] (Message) - Spread loading thread 2: ERROR FOR ACTIVITYSPREAD
com.primavera.PhoenixException

<DateTime> [WARN] (Message) - Spread loading thread 3: There was a problem processing a record for the ACTIVITYSPREAD table : com.primavera.PhoenixException
Object Identifier: ACTIVITYSPREAD Project HGNE JS3a - RCCV Installation Copy for AM Scope (101812 JS3a RCCVCopy)
Primary Key(s): 17539
<DateTime> [ERROR] (Message) - Spread loading thread 3: ERROR FOR ACTIVITYSPREAD
com.primavera.PhoenixException

Original Exception:
java.lang.OutOfMemoryError

<DateTime> [WARN] (Message) - Spread loading thread 1: There was a problem processing a record for the ACTIVITYSPREAD table : com.primavera.PhoenixException

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

  1. Run ETL with the file runetl
  2. Get to Step 1 Part 1 of Run the ETL calculation process (StartETLJava)
  3. Fails
  4. See issue in etlprocess.log

Changes

 

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