Error 'ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT' When Performing Global Search and Replace with Project Owner (Doc ID 2702461.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

1.  When attempting to use global search and replace with project owner, the following error occurs in the P6WebAccess.html log file:

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

The issue can be reproduced at will using the following steps:

1. Log into P6 Web.
2. Navigate to Projects > EPS.
3. Click Actions > Global search and replace.
4. Select User or Global Template.
5. Select the EPS in the left column and click the arrow to move it to the right column, then click Next.
6. Define the search criteria.
7. Project owner = "specify value".
8. Define the replace criteria.
9. Project owner = <a new value>.
10. Click Apply.
11. View the reported error in the log file.

2.  Error may occur when importing XML files.

1. Login to P6 Pro.
2. Go to File > Import.
3. Use the import Wizard to import to Primavera P6 - (XML).
4. Import fails.
5. Error found in the Import Log file.

Cause