Clarity PPM1

Expand all | Collapse all

Error while creating custom object instance through XOG

Jump to Best Answer
  • 1.  Error while creating custom object instance through XOG

    Posted 07-20-2017 02:09 AM

    Hi,

     

    I am getting error while creating custom object instance through XOG in a process. Getting error while doing manual XOG also. We are in V15.2

     

    Here is the sample XML and error message.

     

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd">
    <Header action="write" externalSource="NIKU" objectType="customObjectInstance" version="15.2.0.213">
    <args name="overrideAutoNumbering" value="false"/>
    </Header>
    <customObjectInstances objectCode="os_eace">
    <instance instanceCode="-1" objectCode="os_eace">
    <CustomInformation>
    <ColumnValue name="code">-1</ColumnValue>
    <ColumnValue name="name">Test ACE</ColumnValue>
    <ColumnValue name="os_division">2</ColumnValue>
    <ColumnValue name="page_layout">odf.os_eaceFrame</ColumnValue>
    <ColumnValue name="partition_code">tbs_org_ops</ColumnValue>
    </CustomInformation>
    <OBSAssocs complete="false"/>
    </instance>
    </customObjectInstances>
    </NikuDataBus>

     

    Error:

    <XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
    <Object type="customObjectInstance"/>
    <Status elapsedTime="1.095 seconds" state="SUCCESS"/>
    <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
    <Records>
    <Record>
    <KeyInformation>
    <column name="os_eace">-1</column>
    </KeyInformation>
    <ErrorInformation>
    <Severity>FATAL</Severity>
    <Description>com.niku.union.odf.exception.ODFServiceException: An exception occurred while trying to update an object instance os_eace</Description>
    </ErrorInformation>
    </Record>
    </Records>
    </XOGOutput>

     

    Thanks,

    Shiva



  • 2.  Re: Error while creating custom object instance through XOG

    Posted 07-20-2017 04:29 PM

    Is auto-numbering enabled on Custom Attribute ID column?. Can you please check app log?

     

    Thanks
    Senthil



  • 3.  Re: Error while creating custom object instance through XOG

    Posted 07-21-2017 12:23 AM

    Yes, Auto numbering is enabled in object attribute. This issue is coming after we upgrade it to 15.2 from 13.3.

     

    Thanks,

    Shiva



  • 4.  Re: Error while creating custom object instance through XOG

    Posted 07-21-2017 03:03 AM

    I used the method detailed by

    Aurora_Gaimon 

    in

    XOG and autonumbering Status Reports 

    and it solved my problem.



  • 5.  Re: Error while creating custom object instance through XOG

    Posted 07-21-2017 04:04 AM

    In my case it was working with previous version of clarity and after upgrade its failing.

    I will check with support if no other choice I will use above solution.

     

    Thanks,

    Shiva



  • 6.  Re: Error while creating custom object instance through XOG

    Posted 07-27-2017 01:54 PM

    Tried above solution but still getting below error.

     

    ERROR 2017-07-27 13:47:57,567 [http-nio-80-exec-13] xbl.XOGCustomObjectInstanceHandler (clarity:xogadmin:204528874__59FEA362-0657-463D-AB2F-085572A8BAB8:XOG::customObjectInstance::write) exception XOGging object
    com.niku.union.odf.exception.ODFServiceException: An exception occurred while trying to update an object instance os_eace
    at com.niku.odf.object.ObjectInstanceImpl.update(ObjectInstanceImpl.java:2590)
    at com.niku.odf.object.xbl.XOGCustomObjectInstanceHandler.importCustomObjectInstance(XOGCustomObjectInstanceHandler.java:787)
    at com.niku.odf.object.xbl.XOGCustomObjectInstanceHandler.importObjectInstances(XOGCustomObjectInstanceHandler.java:431)
    at com.niku.odf.object.xbl.XOGCustomObjectInstanceHandler.postProcess(XOGCustomObjectInstanceHandler.java:129)
    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.traverseIntern(DOMWalker.java:92)
    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:261)
    at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:168)
    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:585)
    at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:263)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at com.niku.union.web.filter.ResponseHeaders.doFilter(ResponseHeaders.java:62)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:153)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at com.niku.union.web.filter.XSSFilter.doFilter(XSSFilter.java:86)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at com.niku.union.web.filter.TenantSetupFilter.doFilter(TenantSetupFilter.java:55)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:45)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:63)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:789)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1437)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    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)
    Caused by: com.niku.union.odf.exception.ODFException: com.niku.union.service.ServiceException: Service Exception
    at com.niku.odf.object.Utils.execService(Utils.java:249)
    at com.niku.odf.object.Utils.execService(Utils.java:274)
    at com.niku.odf.object.ODFObjectImpl.insert(ODFObjectImpl.java:2811)
    at com.niku.odf.object.ODFObjectImpl.insertWrapper(ODFObjectImpl.java:2879)
    at com.niku.odf.object.ODFAbstractObjectImpl.update(ODFAbstractObjectImpl.java:3631)
    at com.niku.odf.object.ObjectInstanceImpl.update(ObjectInstanceImpl.java:2568)
    ... 64 more
    Caused by: com.niku.union.service.ServiceException: Service Exception
    at com.niku.odf.service.ODFActionService.processRequest(ODFActionService.java:164)
    at com.niku.union.service.binding.ServiceControlBindingJava.processRequest(ServiceControlBindingJava.java:58)
    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:914)
    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)
    at com.niku.odf.object.Utils.execService(Utils.java:199)
    ... 69 more

     

    Thanks,

    shiva



  • 7.  Re: Error while creating custom object instance through XOG

    Posted 07-21-2017 05:58 AM

    Hi shiva.s43

    Please check if you have any custom lookup associated with any attribute of that custom object. Check if that is returning duplicate data while you are running the XOG file. I have seen similar issues happening for the same reason, earlier. 

     

    Thanks,

    Abhisek Dhar



  • 8.  Re: Error while creating custom object instance through XOG

    Posted 07-27-2017 12:30 PM

    Hi Abhishek,

     

    I tried removing the duplicate from one of the lookup but still same issue.

     

    Thanks,

    Shiva



  • 9.  Re: Error while creating custom object instance through XOG

    Posted 07-28-2017 05:10 PM

    One way to try to identify the problem is to take off the autonumbering for a test. That would tell if it related to autonumbering.

    My experience is that there are differences between versions ins XOGing. So I would not take it granted the if something works in a version it also works in other versions.



  • 10.  Re: Error while creating custom object instance through XOG
    Best Answer

    Posted 08-09-2017 11:47 AM

    I was able to figure out the issue to fix it.

    The issue was with couple of MVL attributes. The XOG XML was expecting the tags of these attribute even though they are not required fields for the instance to create.

     

    Thanks guys