Data Warehouse Job failing with Oracle undo tablespace error

Article Id: 111837

Status: Published

Updated On: 24-05-2019 06:14

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

Load Data Warehousejob fails with the following Oracle errors:

ORA-00604: error occurred at recursive SQL level 1.

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'.

Cause:

This is Oracle database resource issue so please our Saas team investigate it before re-submitting your job.

Environment:

CA PPM 15.3

Resolution:

Once they have been completed their investigation please re-submit the job.