AnsweredAssumed Answered

Delete Investments Job is failing due to error in project deletion.

Question asked by Puneeth on Jan 27, 2016
Latest reply on Feb 11, 2016 by nick_darlington

WARN  2016-01-27 09:13:05,569 [Dispatch pool-5-thread-5 : bg@usa0300vm589 (tenant=clarity)] niku.xql2 (clarity:admin:14783019__9965FA8F-016F-4BC2-A397-C9432E9693D0:Delete Investments- 273) Failed to delete records from query referenced in select deleteODF :<?xml version="1.0" encoding="UTF-8"?>

<deleteService type="java" componentId="odf" description="com.niku.odf.service.object.CustomObjectDeleteService" transaction="dbTransaction" xmlns="http://schemas.niku.com/2002/objectTypes"/>

 

Caused by: id: odf.objectIllegalDelete location:  type: error value:

 

ERROR 2016-01-27 09:13:05,569 [Dispatch pool-5-thread-5 : bg@usa0300vm589 (tenant=clarity)] xql2.xbl (clarity:admin:14783019__9965FA8F-016F-4BC2-A397-C9432E9693D0:Delete Investments- 273) Error while attempting to delete <project_name>

ERROR 2016-01-27 09:13:05,569 [Dispatch pool-5-thread-5 : bg@usa0300vm589 (tenant=clarity)] xql2.xbl (clarity:admin:14783019__9965FA8F-016F-4BC2-A397-C9432E9693D0:Delete Investments- 273) com.niku.union.odf.exception.ODFServiceException: <?xml version="1.0" encoding="UTF-8"?>

<deleteService type="java" componentId="odf" description="com.niku.odf.service.object.CustomObjectDeleteService" transaction="dbTransaction" xmlns="http://schemas.niku.com/2002/objectTypes"/>

 

Caused by: id: odf.objectIllegalDelete location:  type: error value:

 

    at com.niku.odf.object.Utils.execService(Utils.java:214)

    at com.niku.odf.object.Utils.execService(Utils.java:260)

    at com.niku.odf.object.ODFObjectImpl.delete(ODFObjectImpl.java:3167)

    at com.niku.odf.object.ODFObjectImpl.delete(ODFObjectImpl.java:3139)

    at com.niku.odf.service.CustomDeleteService.doDeleteSubObject(CustomDeleteService.java:186)

    at com.niku.odf.service.CustomDeleteService.doProcess(CustomDeleteService.java:85)

    at com.niku.odf.service.ODFActionService.processRequest(ODFActionService.java:115)

    at com.niku.union.service.binding.ServiceControlBindingJava.processRequest(ServiceControlBindingJava.java:58)

    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:902)

    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)

    at com.niku.odf.object.Utils.execService(Utils.java:200)

    at com.niku.odf.object.Utils.execService(Utils.java:260)

    at com.niku.odf.object.ODFObjectImpl.delete(ODFObjectImpl.java:3167)

    at com.niku.odf.object.ODFObjectImpl.delete(ODFObjectImpl.java:3139)

    at com.niku.xql2.odf.ODFRecordSet.delete(ODFRecordSet.java:828)

    at com.niku.xql2.jdbc.JDBCRecord.doDelete(JDBCRecord.java:522)

    at com.niku.xql2.odf.ODFRecord.doRealDelete(ODFRecord.java:357)

    at com.niku.xql2.odf.ODFRecord.delete(ODFRecord.java:340)

    at com.niku.xql2.handlers.DeleteHandler.postProcess(DeleteHandler.java:41)

    at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1419)

    at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)

    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

    at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:54)

    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)

    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)

    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)

    at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)

    at com.niku.njs.xbl.XBLService.process(XBLService.java:127)

    at com.niku.njs.xbl.XBLService.process(XBLService.java:75)

    at com.niku.njs.listeners.XBLJob.scheduledEventFired(XBLJob.java:44)

    at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:367)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

    at java.lang.Thread.run(Thread.java:745)

ERROR 2016-01-27 09:14:57,689 [Dispatch pool-5-thread-5 : bg@usa0300vm589 (tenant=clarity)] niku.njs (clarity:admin:14783019__9965FA8F-016F-4BC2-A397-C9432E9693D0:Delete Investments- 273) Error executing job: 7025397 error PRJ-07536: An error ocurred while attempting to delete one or more projects in the background scheduler.  Please, refer to the log for details.

 

 

Can anybody explain me what the error is happening here.

 

I have also verified the project and it satisfies all the mentioned conditions for deletion:

 

  1. The investment is inactive.
  2. The investment contains no WIP entries.
  3. The investment contains no non-zero time entries.
  4. The Financial Properties Status is set to "Closed".
  5. There are no process instances attached to this investment or tasks on the investment
  6. There are no requisitions attached to this investment.
  7. There is not a Participant Group on the project.

Outcomes