Load DWH Job Failing due to ORA-04036 / ORA-02063 errors

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Both the incremental and Full load Data Warehouse are failing continuously in our Production.

BG DWH log shows the below error when processing DWH_FIN_TRANSACTION TABLE.

CA Clarity][Oracle JDBC Driver][Oracle]ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-02063: preceding line from PPMDBLINK

Environment

Release : 15.5.1

Component : CA PPM SAAS DATA WAREHOUSE

Cause

PGA Memory is completely used in PPM Database causing the remote query to generate a ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT ERROR.

This indicates a memory issue on the Database server.

Resolution

Possible Solutions:

1. PGA_AGGREGATE_LIMIT is too low and needs to be increased.
2. ON Premise customers check with your DBA for any sessions which are using more PGA memory and are causing the issue. Wait for the sessions to finish or kill them to free up PGA Memory.
3. SAAS Customers, please create a Support ticket.