Delete Investments Job failing with Table or View does not Exist Error

book

Article ID: 130894

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The Delete Investments and Time Reporting Periods job fails with 'ORA-00942: table or view does not exist' error in the bg-ca logs, and the investment does not get deleted. 
 

Cause

This is due to a custom subobject of the project object getting deleted incorrectly to where orphan references to the associated subobject tables get left in the database.  

Environment

Release:
Component: PPRPRM

Resolution

Create the custom subobject of the project object with the same ID as shown in the logs and then run the Delete Investments and Time Reporting Periods job. Once the job completes successfully, the custom object can be deleted to clear any orphan records or table associations left in the system .The Delete Investments and Time Reporting Periods job should be running successfully after deleting the custom object for the second time as well.