Delete Investments Job Fails - Team record referenced by other records and cannot be deleted. The team record has been disabled.

Document ID : KB000022567
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

We executed the 'Delete Investments' job and found the following error message in the background (BG) log file. What does this error message indicate and how can we delete this project?

WARN 2014-10-16 05:00:25,181 [Dispatch Thread-3583 : bgserver] xql2.rule (none:none:none) Team record referenced by other records and cannot be deleted. The team record has been disabled.
WARN 2014-10-16 05:00:25,181 [Dispatch Thread-3583 : bgserver] niku.xql2 (none:none:none) Failed to delete records from query referenced in select deleteODF :com.niku.union.persistence.PersistenceApplicationException
ERROR 2014-10-16 05:00:25,181 [Dispatch Thread-3583 : bgserver] xql2.xbl (none:none:none) Error while attempting to delete 000249 (5000178)
ERROR 2014-10-16 05:00:25,182 [Dispatch Thread-3583 : bgserver] xql2.xbl (none:none:none) com.niku.union.odf.exception.ODFServiceException: com.niku.union.persistence.PersistenceApplicationException
at com.niku.projmgr.odf.TeamDeleteService.doDelete(TeamDeleteService.java:58)
at com.niku.odf.service.CustomDeleteService.process(CustomDeleteService.java:124)
at com.niku.odf.service.ODFService.doProcess(ODFService.java:183)
... more...

Solution:

The error message indicates that the Investment has actual hours posted cannot be deleted. The actual hours can be deleted by marking the Time Reporting Period for deletion and executing the 'Delete Investments' job. However this impacts all actual hours posted for that time period and it may not be desired to remove the Time Reporting Period. If you want to delete this one investment, follow the steps below to change the Track Mode on the Project.

  1. Navigate to Home, Project, Schedule page and change the Track Mode to Other.
  2. If the Project has financial actual hours, the 'Purge Financials' job must be executed for this investment before the 'Delete Investments' job is executed.
  3. Execute the 'Delete Investments' job.

The following text was added to the 'Delete Investments Job' in the Administration Guide.

Note: Change the project track mode from Clarity to Other if the assignments have actuals. If you do not change the track mode, the project is not deleted.