AnsweredAssumed Answered

Delete Investments Job Failing

Question asked by flo_clarity on Oct 15, 2013
Latest reply on Oct 17, 2013 by Nika_Hadzhikidi
Hi all,

we are running Clarity v. 13.0.1 and since a few days we are having issues with the scheduled Delete Investments Job. It is failing...

I did some intensive debugging, but I could not found the root cause of this. This is part of the log:

DEBUG 2013-10-15 09:04:52,307 [Dispatch pool-4-thread-3 : bg@CorStrCac101 (tenant=clarity)] niku.xql2 (clarity:unknown:-1:none) Error deleting ODF Object project
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:222)

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

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

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

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

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

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

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

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

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

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

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

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

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

at java.lang.Thread.run(Thread.java:662)
WARN 2013-10-15 09:04:52,308 [Dispatch pool-4-thread-3 : bg@CorStrCac101 (tenant=clarity)] niku.xql2 (clarity:unknown:-1:none) 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:

DEBUG 2013-10-15 09:04:52,309 [Dispatch pool-4-thread-3 : bg@CorStrCac101 (tenant=clarity)] niku.xql2 (clarity:unknown:-1:none) Processing catch for 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:

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

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

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

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

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

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

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

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

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

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

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

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

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

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

at java.lang.Thread.run(Thread.java:662)
ERROR 2013-10-15 09:04:52,311 [Dispatch pool-4-thread-3 : bg@CorStrCac101 (tenant=clarity)] xql2.xbl (clarity:unknown:-1:none) Error while attempting to delete 5056280 (5055268)
ERROR 2013-10-15 09:04:52,311 [Dispatch pool-4-thread-3 : bg@CorStrCac101 (tenant=clarity)] xql2.xbl (clarity:unknown:-1:none) 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:222)

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

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

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

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

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

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

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

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

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

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

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

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

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

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

Does anyone already have experienced same issues? How can we solve this issue?

Many thanks in advance!

Cheers,
Flo

Outcomes