AnsweredAssumed Answered

XOG error while adding participants to project

Question asked by mcanovas on Dec 1, 2015
Latest reply on Jan 13, 2016 by terse03

Hi,

 

I've created a process which collects the value of a field in odf_ca_project table and adds it as a participant through XOG. In fact, there are two processes, one for creation and another one for update. The update process works fine, but creation process always ends in an error. I copy the xml that is created (which is exactly the same than the one from update process) and the results of the  XOG.

 

<?xml version="1.0" encoding="UTF-8"?> <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd"> <Header action="write" externalSource="NIKU" objectType="project" version="13.3.0.286"/> <Projects> <Project name="Pruebas Marc 01/12 2" projectID="00404114"> <participants> <resource userName="JMMENG1"/> </participants> </Project> </Projects> </NikuDataBus>

 

 

<?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="2.864 seconds" state="FAILURE"/>

  <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>

  <Records>

  <Record>

  <KeyInformation>

  <column name="ID">6289041</column>

  <column name="name">Pruebas Marc 01/12 2</column>

  <column name="UNIQUE_NAME">00404114</column>

  </KeyInformation>

  <ErrorInformation>

  <Severity>FATAL</Severity>

  <Description>Project Object update failed</Description>

  <Exception><![CDATA[

java.lang.Exception: 31

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

at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:167)

at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:198)

at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:99)

at com...

 

 

Can you help me with this?

 

Regards,

 

Marc

Outcomes