ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 190110

calendar_today

Updated On:

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

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.

Environment

Release : 15.5.1

Component : CA PPM SAAS DATA WAREHOUSE

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.