Clarity

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

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

Thanks
Senthil

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

Thanks,

Shiva

I used the method detailed by

Aurora_Gaimon 

in

XOG and autonumbering Status Reports 

and it solved my problem.

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

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

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

Hi Abhishek,

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

Thanks,

Shiva

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.

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