Delete Investments Job failing with Table or View does not Exist Error
Article ID: 130894
Clarity PPM SaaSClarity 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.
Release: Component: PPRPRM
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.
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.