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.

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


Article ID: 130894


Updated On:


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