Clarity

 View Only
  • 1.  java.lang.NumberFormatException Error in Xogout

    Posted Jan 12, 2017 08:20 AM

    Hello All,

     

    Process Engine failed, so there are few Instance which are to be manually completed by running the process.
    Among them 5 Instances are displaying Contact System Administrator Error.
    I have Xogged the Instance now its showing below Error.
    Few other instance were created like RM000012 , we are able to Xog out but the problem is with these 5 Instances.


    Could you please help me out why we are seeing that Contact System administrator error and java.lang.NumberFormatException Error 

    <KeyInformation>
              <column name="objectCode">td_rm_attest</column>
              <column name="instanceCode">00000056,00000055,00000059,00000057,00000058</column>
            </KeyInformation>
            <ErrorInformation>
              <Severity>FATAL</Severity>
              <Description>Custom Object Instance Export Failed</Description>
              <Exception><![CDATA[
    java.lang.NumberFormatException
        at java.math.BigDecimal.<init>(BigDecimal.java:494)
        at java.math.BigDecimal.<init>(BigDecimal.java:383)
        at java.math.BigDecimal.<init>(BigDecimal.java:806)
        at com.niku.odf.object.ObjectInstanceImpl.setupAssocRows(ObjectInstanceImpl.java:470)
        at com.niku.odf.object.ODFAbstractObjectImpl.getMultiValuedAttributeValues(ODFAbstractObjectImpl.java:2972)
        at com.niku.odf.object.ODFAbstractObjectImpl.readInstance(ODFAbstractObjectImpl.java:2411)
        at com.niku.odf.object.ODFAbstractObjectImpl.readInstance(ODFAbstractObjectImpl.java:2227)
        at com.niku.odf.object.ODFAbstractObjectImpl.readInstance(ODFAbstractObjectImpl.java:2209)
        at com.niku.odf.object.xbl.XOGParentObjectInstanceHandler.getParentObjectInstances(XOGParentObjectInstanceHandler.java:79)
        at com.niku.odf.object.xbl.XOGParentObjectInstanceHandler.postProcess(XOGParentObjectInstanceHandler.java:68)
        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.traverseIntern(DOMWalker.java:92)
        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:195)
        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.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.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.MatchHandler.preProcess(MatchHandler.java:129)
        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.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:355)
        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:164)
        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>
    </NikuDataBus>



  • 2.  Re: java.lang.NumberFormatException Error in Xogout

    Posted Jan 18, 2017 03:47 AM

    Hi

     

    That looks odd:

     

    <column name="instanceCode">00000056,00000055,00000059,00000057,00000058</column>

     

    why do yo have so many codes?



  • 3.  Re: java.lang.NumberFormatException Error in Xogout

    Posted Jan 18, 2017 08:43 AM

    Hi,
    I was Xogging out for multiple Instance , So i gave many codes.
    I faced same error in the Xog out file for single Code.

    Thanks.



  • 4.  Re: java.lang.NumberFormatException Error in Xogout

    Posted Jan 18, 2017 10:02 AM

    com.niku.odf.object.ODFAbstractObjectImpl.getMultiValuedAttributeValues

     

    Seems to be a problem with an attribute (multi-valued lookup value)

     

    Can you check ?

     

    NJ



  • 5.  Re: java.lang.NumberFormatException Error in Xogout

    Posted Jan 18, 2017 10:04 AM

    Also, check this:

     

    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec602375.html 

     

    One or more projects fail to open throwing the following error: "Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator."

    Document ID:  TEC602375
    Last Modified Date:  10/01/2016
    Show Technical Document Details

    Issue:

    Some projects fail to open throwing the following error: "Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator." Sometimes this occurs post upgrade, but it can happen at other times as well, particularly when a multi value lookup value is changed to a blank value and the old value may still be stuck in the database for the lookup.

    The app-ca.log file shows the following error:

    ERROR 2013-10-28 13:33:50,494 [http-bio-8080-exec-544] niku.xql2
    (clarity:admin:6758105__5E52B4FC-309B-4EA9-9A3B-61C89366163C:projmgr.project
    Properties)
    Internal Processing exception java.lang.NumberFormatException
    at java.math.BigDecimal.<init>(BigDecimal.java:470)
    at java.math.BigDecimal.<init>(BigDecimal.java:739)
    at
    com.niku.odf.object.ObjectInstanceImpl.setupAssocRows(ObjectInstanceImpl.jav
    a:304)
    at
    com.niku.odf.object.ODFAbstractObjectImpl.getMultiValuedAttributeValues(ODFA
    bstractObjectImpl.java:2756)
    at
    com.niku.odf.object.ODFAbstractObjectImpl.readInstance(ODFAbstractObjectImpl
    .java:2290)

    Environment:

    Applies to all supported PAS environments for specified releases.

    Resolution:

    Query these tables by replacing '?' with the internal ID of the affected project.

    select * from inv_investments where id = ?
    select * from odf_multi_valued_lookups where id = ?
    select * from odf_ca_project where id = ?

    The odf_multi_valued_lookups table contains a NULL value for the affected project. Please update the row with the correct value.

    If the lookup value is blank, temporarily populate it with a value and save. This can be done by adding the affected attribute to the project list, populating a value for the attribute from the project list, and clicking Save. (Typically, the last modified Multi Value Lookup(s) for the project are the impacted lookups, which can be  found  by running the query: select * from odf_multi_valued_lookups where id = ? .

     

     

    NJ