AnsweredAssumed Answered

Troubles while xogging project object

Question asked by voliveira on Apr 29, 2014
Latest reply on Dec 22, 2016 by Danpego

Hello folks, hope everyone is fine.

We are trying to XOG the project oject between two partitioned environments. More specifically, we just need to XOG 1 partition, so we used the filter `partition_code` when we requested the object in order to bring just the data of the selected partition. This is how our read XOG looks like:

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
  <Header version="8.0" action="read" objectType="contentPack" externalSource="NIKU">
      <!-- the contentType is used to determine which filter goes where -->
        <args contentType="job_definition" name="order_by_1" value="code"/>
        <args contentType="menu" name="order_by_1" value="code"/>
        <args contentType="view" name="order_by_1" value="code"/>
        <args contentType="process" name="order_by_1" value="code"/>
        <args contentType="object" name="order_by_1" value="code"/>
   <args name="no_dependencies" value="true"/>
      </Header>
      <ViewQuery>
        <Filter name="object_code" criteria="EQUALS">project</Filter>
        <Filter name="partition_code" criteria="EQUALS">ditv</Filter>
      </ViewQuery>
  </NikuDataBus>
When trying to XOG-in the output of this request (which is pretty big, something like 211k lines) in the target environment, we get an error that`s not self explanatory. This is the error:
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
  <Object type="contentPack"/>
  <Status elapsedTime="5.0 minutes 17.894000000000005 seconds" state="FAILURE"/>
  <Statistics failureRecords="1" insertedRecords="-2" totalNumberOfRecords="14" updatedRecords="15"/>
  <Records>
    <Record>
      <KeyInformation>
        <column name="externalSource">NIKU</column>
        <column name="source"/>
        <column name="code">project</column>
      </KeyInformation>
      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>XOG-3360: Custom attribute record has not been inserted java.lang.Exception: Failure while evaluating "localizeMsg('')" in expression "{localizeMsg('{message}')}" error: Invalid expression localizeMsg(''): null&#xd;
at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1289)&#xd;
at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1317)&#xd;
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:178)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)&#xd;
at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:88)&#xd;
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)&#xd;
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)&#xd;
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)&#xd;
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)&#xd;
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)&#xd;
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)&#xd;
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)&#xd;
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)&#xd;
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)&#xd;
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)&#xd;
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)&#xd;
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)&#xd;
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)&#xd;
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)&#xd;
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)&#xd;
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)&#xd;
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)&#xd;
at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:50)&#xd;
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)&#xd;
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)&#xd;
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)&#xd;
at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:260)&#xd;
at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:167)&#xd;
at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:197)&#xd;
at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:99)&#xd;
at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)&#xd;
at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:599)&#xd;
at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:359)&#xd;
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)&#xd;
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)&#xd;
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)&#xd;
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)&#xd;
at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:68)&#xd;
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)&#xd;
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)&#xd;
at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)&#xd;
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)&#xd;
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)&#xd;
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)&#xd;
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)&#xd;
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)&#xd;
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)&#xd;
at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:70)&#xd;
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)&#xd;
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)&#xd;
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)&#xd;
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)&#xd;
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)&#xd;
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)&#xd;
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)&#xd;
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)&#xd;
at java.lang.Thread.run(Thread.java:722)&#xd;
Caused by: java.lang.Exception: Invalid expression localizeMsg(''): null&#xd;
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1126)&#xd;
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1052)&#xd;
at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1284)&#xd;
... 72 more&#xd;
Caused by: java.lang.NullPointerException</Description>
        <Exception><![CDATA[
java.lang.NullPointerException
]]></Exception>
      </ErrorInformation>
    </Record>
  </Records>
</XOGOutput>
One important observation about this XOG is that the create view of the project object is not being migrated. We don't know exactly why, but this would be our next question, as we want to migrate everything. smiley
I appreciate any help on this one.
Thanks a lot.
Vitor.

Outcomes