AnsweredAssumed Answered

Delete Project with XOG

Question asked by AdminDIRCE on Jul 25, 2017
Latest reply on Mar 15, 2018 by marjo60

How can you delete a project using XOG? My current efforts fail - see below.

 

XML file ...

 

<?xml version="1.0" encoding="utf-8"?>
<NikuDataBus xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Header action="write" externalSource="NIKU" objectType="project" version="14.3.0.298" />
<Projects>
<Project name="Delete Me" projectID="00001103" delete="true">
<General />
</Project>
</Projects>
</NikuDataBus>

 

Result ...

 

<?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header/>
<soapenv:Body>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Object type="project"/>
<Status elapsedTime="0.348 seconds" state="FAILURE"/>
<Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
<Records>
<Record>
<KeyInformation>
<column name="ID">5014021</column>
<column name="name">Delete Me</column>
<column name="UNIQUE_NAME">00001103</column>
</KeyInformation>
<ErrorInformation>
<Severity>FATAL</Severity>
<Description>Project Object update failed</Description>
<Exception><![CDATA[
java.lang.Exception: 107
at com.niku.schedulers.api.XOGProjectAPI.returnErrorMessage(XOGProjectAPI.java:472)
at com.niku.schedulers.api.XOGProjectAPI.process(XOGProjectAPI.java:300)
at com.niku.schedulers.api.XOGProjectAPI.eval(XOGProjectAPI.java:142)
at com.niku.xql2.eval.XQLFunctionNode.eval(XQLFunctionNode.java:27)
at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1086)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1060)
at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1292)
at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1325)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:178)
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.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.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.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.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:263)
at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:170)
at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:198)
at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:99)
at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)
at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:595)
at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:273)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:148)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.niku.union.web.filter.XSSFilter.doFilter(XSSFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.niku.union.web.filter.TenantSetupFilter.doFilter(TenantSetupFilter.java:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:65)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1086)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:659)
at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:223)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1558)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1515)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
]]></Exception>
</ErrorInformation>
</Record>
</Records>
</XOGOutput>
</soapenv:Body>
</soapenv:Envelope>

Outcomes