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


Article ID: 130894


Updated On:


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


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. 


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.  


Component: PPRPRM


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.