My Oracle Support Banner

Primavera Analytics P6 ETLs Fail When P6 Projects With Very Large Notebook Topics Are Included (Doc ID 3030835.1)

Last updated on JULY 23, 2024

Applies to:

Construction Intelligence Cloud Service - Version 22.10 and later
Primavera Analytics Cloud Service - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

P6 ETL job fails when projects with very large P6 notebook topics are included.

STEPS TO REPRODUCE

1. Publish a P6 project which has a notebook topic with 16,000+ rows of data.
2. Run P6 ETL from Analytics Administration Application
3. Check ETL log and notice Fail error.

EXPECTED BEHAVIOR

P6 ETL should complete when projects with very large P6 notebook topics are included.

Errors in ODI Console logs reference ODI Session P6_SCHEDULED_W_PROJECT_NOTE_D_PHYSICAL and target table W_PROJECT_NOTE_D.

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


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