Clarity PPM

Expand all | Collapse all

XOG Out a Custom Object

Jump to Best Answer
  • 1.  XOG Out a Custom Object

    Posted 03-26-2018 05:16 AM

    Hi All,

     

    I am trying to xog out a custom object definition using below xml file. It is throwing Number Format Exception.

    Please let me know your thoughts why it is trowing error: 

     

    our clarity version/Build is: 14.3.0.298 05 10

    Here I am trying to limit the xog data, that's why i am using below two elements.

     

    <args name="singleContentType" value="object" />
    <args name="no_dependencies" value="true" />

     

    custom_object_read.xml

    <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 name="singleContentType" value="object" />
    <args name="no_dependencies" value="true" />
    </Header>
    <ObjectQuery>
    <Filter name="object_code" criteria="EQUALS">opt_data_cleanup_v2</Filter>
    </ObjectQuery>
    </NikuDataBus>

     

    Error:

     

    Thank you



  • 2.  Re: XOG Out a Custom Object
    Best Answer

    Posted 03-26-2018 08:09 AM

    Hi Subbareddy,

    I did some quick research on this and found a defect that could possibly be related (not certain but worth a shot), which is fixed in 15.3.  Its documented here in the documentation:  https://docops.ca.com/ca-ppm-saas/15-3/en/release-information/ca-ppm-15-3-resolved-defects#CAPPM15.3ResolvedDefects-DE31… 

     

    Here is the info it provides:

     

    DE31172 (S2): CLRT-79129: XOG - Unable to read object view

    Steps to Reproduce:
    1. Use the following input file to read Project Views.
    - <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"> <args contentType="object" name="order_by_1" value="code" /> <args name="singleContentType" value="view" /> <args name="no_dependencies" value="true" /> <args name="exclude_parent" value="true" /> </Header> - <ViewQuery> <Filter name="code" criteria="OR">property</Filter> <Filter name="object_code" criteria="EQUALS">project</Filter> <Filter name="partition_code" criteria="EQUALS">NIKU.ROOT</Filter> </ViewQuery> </NikuDataBus>

    2. Run the XOG from command line:

    Expected Result: Output file should be generated with xml of Project Views

    Actual Result: XOG failes with error Failed to retrieve response document

    Login Succeeded Request Document: prj_view_read.xml Writing output to ProjectView_Out.xml

    Failed to retrieve response document

    java.lang.NumberFormatException: For input string: " at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at com.niku.xog.client.XOGClient.mergeResponseToStream(XOGClient.java:92 8) at com.niku.xog.client.XOGClient.processRequestAsStream(XOGClient.java:1 002) at com.niku.xog.client.XOGClient.processRequest(XOGClient.java:674) at com.niku.xog.client.XOGClient.processRequests(XOGClient.java:1625) at com.niku.xog.client.XOGClient.invokeCommand(XOGClient.java:1382) at com.niku.xog.client.XOGClient.main(XOGClient.java:159) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.werken.forehead.Forehead.run(Forehead.java:551) at com.werken.forehead.Forehead.main(Forehead.java:581) Logout Succeeded

     

    Does this seem like it could be the same problem you are facing?  Unfortunately I dont believe there is a fix for it for 14.3, so the only way to resolve it would be to upgrade to 15.3 or 15.4 (most current).

     

    Let us know,

    Jon I.



  • 3.  Re: XOG Out a Custom Object

    Posted 03-26-2018 09:09 AM

    Sounds like that.
    I get the same error when I try to read the task object (in addition to custom objects) in 14.4



  • 4.  Re: XOG Out a Custom Object

    Posted 03-26-2018 01:46 PM

    Yeah most likely thats it then.  Unfortunately there is no one-off fix in 14.4, this would require an upgrade to 15.3 or 15.4 to resolve.  

    Thanks,
    Jon I.