System Error when deleting more than one cancelled job

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

Problem:

A System Error is generated when deleting more than one cancelled job.

Steps to Reproduce:

  1. Login as an administrator
  2. Navigate to Scheduled Jobs page
  3. Select two or more 'Cancelled' jobs
  4. Click 'Delete Job' button

Expected Result: Successful deletion of cancelled jobs

Actual Result: System Error message.  Look in the application log files and see the following error message:

ERROR 2015-09-26 10:15:17,217 [http-bio-1080-exec-4] niku.xql2 (clarity:admin:9648042__D40F703E-B528-4E6B-8FE7-39E8E6DD30D5:nmc.deleteJob) Internal Processing exception
com.niku.odf.ori.exceptions.OdfException: BusinessObject could not be updated.
        at com.niku.odf.ori.OdfController.updateBusinessObject(OdfController.java:266)
        at com.niku.odf.ori.xblhandlers.EntityHandler.modifyBusinessObject(EntityHandler.java:227)
        at com.niku.odf.ori.xblhandlers.EntityHandler.processOdfRequest(EntityHandler.java:120)
        at com.niku.odf.ori.xblhandlers.EntityHandler.postProcess(EntityHandler.java:57)
        at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1418)
SQL error code: 1427
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01427: single-row subquery returns more than one row 

Environment:

Applies to all supported PAS environments for specified releases.

Cause:

Caused by CLRT-76562

Resolution:

Resolved in CA PPM 14.2

The resolution to this issue has caused a new issue CLRT-78822 where saved filters are removed unexpectedly.  

Workaround:

Select only one, and delete each cancelled job one-by-one.

Additional Information:

Reference TEC1214402 : Why some Saved filters, Saved Job Parameters, Saved Report Parameters are removed with the upgrade to 14.2?

Reference CA PPM Resolved Defects Index for CA PPM 14.3