AnsweredAssumed Answered

Delete Investments Job is not deleting investment

Question asked by navzjoshi00 Champion on Jan 22, 2015
Latest reply on Jun 23, 2015 by navzjoshi00

These are the errors -

 

Failed to delete records from query referenced in select deleteODF :com.niku.union.persistence.PersistenceApplicationException

 

com.niku.union.odf.exception.ODFException: com.niku.union.persistence.PersistenceApplicationException

    at com.niku.projmgr.odf.TaskDeleteService.invokeDeleteRule(TaskDeleteService.java:64)

    at com.niku.projmgr.odf.TaskDeleteService.doDelete(TaskDeleteService.java:31)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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:1355)

    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:50)

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

    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:161)

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

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

    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:290)

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

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

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

Caused by: com.niku.union.persistence.PersistenceApplicationException

 

 

I checked and found that it satisfies the below criteria -

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.

 

I've also checked the below -

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec510859.aspx

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec534931.aspx

 

Any more thoughts ?

 

NJ

Outcomes