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.

Data Warehouse Job failing with Oracle undo tablespace error

book

Article ID: 111837

calendar_today

Updated On:

Products

Clarity PPM SaaS 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.