search cancel

Delete Investments Job throws Fatal Error if Financial Object attribute is Audited

book

Article ID: 203244

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Projects cannot be deleted if an attribute from the Financials object is being audited for deletion on the Project object. 

Steps to Reproduce: 
1. Go to Administration - Objects - Financials object
2. On the attributes tab, click on new 
3. Create a new attribute with Data Type: Money and select the option to 'Reference another attribute of this object' and select the Currency Code field
4. Go to the Project object
5. On the Audit Trail tab, add the attribute created on Step 3 to the 'Logged Attributes for Delete Operation' section and click on Save
6. Create a project, inactive it, close the Financial Status, and mark it for deletion (can also do this step with an existing project)
7. Run the 'Delete Investments and Time Reporting Periods' job, select the 'DELETE MARKED INVESTMENTS WITH TIMESHEET AND TRANSACTION DATA' option if necessary

Expected Results: The job completes without error, and the project is deleted. 
Actual Results: The job completes with the following error and the project is not deleted: "Fatal error deleting investment (nnnn).  Review job scheduler log for more detail.". The bg-ca logs contain the following errors: 

ERROR 2020-11-12 11:32:40,533 [Dispatch Delete Investments and Time Reporting Periods : bg (tenant=clarity)] background.DeleteInvestmentService (clarity:admin:5185128__5A384127-9EAC-409E-95E0-687D21F753AB:Delete Investments and Time Reporting Periods) Fatal error deleting investment (nnnn).  Review job scheduler log for more detail.
ERROR 2020-11-12 11:32:40,533 [Dispatch Delete Investments and Time Reporting Periods : bg (tenant=clarity)] background.DeleteInvestmentService (clarity:admin:5185128__5A384127-9EAC-409E-95E0-687D21F753AB:Delete Investments and Time Reporting Periods) 
com.niku.union.odf.exception.ODFException: com.niku.union.persistence.PersistenceException: 
SQL error code: 1403
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01403: no data found
ORA-06512: at "niku.T_PROJECT_OODF_CA_FINANCIALS", line 10
ORA-04088: error during execution of trigger 'niku.T_PROJECT_OODF_CA_FINANCIALS'

Environment

Release : 15.7.1 - 15.9

Component : CA PPM Project Management

Cause

Caused by DE58675

Resolution

DE58675 is fixed in the upcoming 15.9.1 release. 

Workaround: Temporarily remove the attribute from being audited for deletion on the Project object by removing it from the 'Logged Attributes for Delete Operation' section, and run the Delete Investments job