Delete Investments Job Debug

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The 'Delete Investments' job is failing with "An error occurred while attempting to delete one or more projects in the background scheduler. Please, refer to the log for details." Which log we should be looking in and what could be a possible reason for job failure?

Environment

Release: Any

Resolution

1. Error Messages for any scheduled job can be found in the background log file (bg-ca.log) :
2. Here is an example of an error generated by the 'Delete Investments' Job
   • WARN 2022-02-05 15:09:28,913 [Dispatch Thread-34076 : bg] niku.xql2 (none:none:none) Failed to delete records from query referenced in select deleteODF :Error deleting project instance with PK: 5000286.0
   • ERROR 2022-02-05 15:09:28,913 [Dispatch Thread-34076 : bg] xql2.xbl (none:none:none) Error while attempting to delete PR-2005-00009 (5000286)
   • ERROR 2022-02-05 15:09:28,914 [Dispatch Thread-34076 : bg] xql2.xbl (none:none:none) com.niku.union.odf.ODFException: Error deleting project instance with PK: 5000286.0
   • .......... Caused by: com.niku.union.persistence.PersistenceException: statementSet not found odf-pmd.bill_info.select-pk.map
   • WARN 2022-02-03 17:21:13,549 [Dispatch Thread-2 : bg] xql2.xbl (none:none:none) PR04_0274 (5000176) cannot be deleted because it is still Active.
   • INFO 2022-02-03 17:21:13,700 [Dispatch Thread-2 : bg] xql2.xbl (none:none:none) Attempting to delete PR04_1160 (5001122).
   • ERROR 2022-02-03 17:21:15,127 [Dispatch Thread-2 : bg] xql2.xbl (none:none:none) Error while attempting to delete PR04_1160 (5001122)
   • ERROR 2022-02-03 17:21:15,129 [Dispatch Thread-2 : bg] xql2.xbl (none:none:none) com.niku.dms.util.DMSException: User does not have read permissions on this folder
   • Each Error message is specific to the details required for resolving issues.
3. If you are not seeing enough information for this job in the bg-ca.log file, then you can turn on additional debugging levels in the component 'com.niku.xql2' and 'com.niku.njs'.
   1. Go to CSA, Logs Tab, Edit Configuration
   2. Click 'Add' Button
   3. Select, from the drop-down list the component 'com.niku.xql2'
   4. Change the Priority to 'WARN'
   5. Click 'Save'
   6. Click 'Add' Button
   7. In the 2nd column 'Other Name' , type the component name 'com.niku.njs'
   8. Change the Priority to 'ERROR'
   9. Click 'Save'
   10. If you have the Option : Detect Log Configuration Changes Automatically selected , you do not need to restart the Background Services. If you do not have this option selected, then Stop and Restart the Background Services.
   11. Execute the 'Project Deletion' Job again.
   12. Review the bg-ca.log file for errors
       Caution: This job permanently deletes projects and time reporting periods marked for deletion. Before running this job, be sure to reference the Administration Guide for more details on the impact of running this job.