My Oracle Support Banner

Slow ETL Performance When Running ScdDimensionLoad (Slowly Changing Dimension) or ResourceRoleLimit (ResourceLimit and RoleLimit) (Doc ID 2829650.1)

Last updated on AUGUST 18, 2022

Applies to:

Primavera Analytics - Version 20.12 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

The ETL step(s) ScdDimensionLoad (Slowly Changing Dimension) Or ResourceRoleLimit (ResourceLimit and RoleLimit) run very slowly. Sometimes the ETL hangs at these steps.

EXPECTED BEHAVIOR

These ETL steps should complete in a timely manner.

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!

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