Clarity

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.

odf.objectIllegalDelete

This is also known as "ODF-0105: Not authorized to delete one or more selected {0} instances." (where {0} represents the Studio object, e.g. 'project').

So please check that the user running the job has permissions to edit/delete this object instance, as well as any custom subobject instances below it.

Hi Nick,

I am running this Job from my login and also with the administrator login. This is Happening only for this project while other projects are getting deleted with out any issues.

So does this project have any subobject instances?  Have you tried deleting them first?  Can you double check that your users have those permissions (just using the 'administrator' account isn't sufficient, out of the box, that account is missing several permissions and the creation of new custom subobjects for example will not automatically have their rights given to the administrator accounts either - those accounts give you the power to grant/revoke those rights, without necessarily even having them yourself).

The error you are receiving occurs specifically at the step prior to executing any deletes, and that step performs a permissions check for you on that object instance, so it would still seem that it is somehow failing at that point.

If you are still facing issues with this even after ensuring all necessary rights have been granted, you will need to get an issue opened I think.  It's possible even with all the right permissions that you maybe have a data issue that inhibits it.

Please see this article for more details about this error code and confirmation of the causes for it (TEC511237):

Delete Investments job leaves some projects unprocessed due to access rights

Can you check for the below conditions ?

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.

NJ