System Error when deleting more than one cancelled job

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


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(
        at com.niku.odf.ori.xblhandlers.EntityHandler.modifyBusinessObject(
        at com.niku.odf.ori.xblhandlers.EntityHandler.processOdfRequest(
        at com.niku.odf.ori.xblhandlers.EntityHandler.postProcess(
        at com.niku.xql2.XQLVisitor.postProcess(
SQL error code: 1427
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01427: single-row subquery returns more than one row 


Applies to all supported PAS environments for specified releases.


Caused by CLRT-76562


Resolved in CA PPM 14.2

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


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