supriya.chakraborty

Delete Investment allocation job Failing

Discussion created by supriya.chakraborty on Jun 28, 2013
Latest reply on Jun 29, 2013 by navzjoshi00
Hi ,

Delete Investments job is failing for us .
I have checked all the possible option (locks and last updated by ) for the project mentioned in the error.


at java.lang.Thread.run(Thread.java:619)
WARN 2013-06-28 00:48:20,544 [Dispatch Thread-3716 : bg@***] niku.xql2 (non e:none:none) Failed to delete records from query referenced in select deleteODF :<?xml version="1.0" encoding="UTF-8"?>
<deleteService type="xbl" componentId="odf" description="custom/customDeleteService.xbl" transaction="dbTransaction" xmlns="http://schemas.niku.com/2002/objectTypes"/>

ERROR 2013-06-28 00:48:20,544 [Dispatch Thread-3716 : bg@xxxx] xql2.xbl (none:none:none) Error while attempting to delete P-008432 (5170311)
ERROR 2013-06-28 00:48:20,544 [Dispatch Thread-3716 : bg@xxxx] xql2.xbl (none:none:none) com.niku.union.odf.exception.ODFServiceException: <?xml version="1.0" encoding="UTF-8"?>
<deleteService type="xbl" componentId="odf" description="custom/customDeleteService.xbl" transaction="dbTransaction" xmlns="http://schemas.niku.com/2002/objectTypes"/>


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

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

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

at com.niku.odf.service.CustomDeleteService.process(CustomDeleteService.java:116)

at com.niku.odf.service.ODFService.doProcess(ODFService.java:191)

at com.niku.odf.service.BaseODFService.processRequest(BaseODFService.java:109)

at com.niku.odf.service.CustomDeleteService.processRequest(CustomDeleteService.java:51)

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

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

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

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

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

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

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

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

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

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

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)z

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

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

at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)

at java.lang.Thread.run(Thread.java:619)
ERROR 2013-06-28 00:48:34,124 [Dispatch Thread-3716 : bg@xxxx] niku.njs (none:none:none) Error executing job: 5233689 error An error ocurred while attempting to delete one or more projects in the background scheduler. Please, refer to the log for details.


i have seen some post in the ca communities before on this topic as well but didnt get more info on this .
Upon checking the project id i found that it is a project template which is marked for deletion .
Any clue on this woukd be of great help!!!!

Regards,
Supriyo Chakraborty

Outcomes