My Oracle Support Banner

Error ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT When Running Scheduled Summarization Project Job (Doc ID 2455429.1)

Last updated on OCTOBER 21, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.3.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a Project Scheduled Service to Summarize a Project, the following error occurs.

ERROR
-----------------------
"Completed with Errors"
Please refer to P6 Server Side Log for more information

The log file shows the following error as the reason for the failure.
Caused by: java.sql.SQLException: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure a Project Scheduled Service to run a summarize job
2. Receive error

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.