Clarity

Expand all | Collapse all

Unable to Xog out the OBS Data: Getting connection reset error

  • 1.  Unable to Xog out the OBS Data: Getting connection reset error

    Posted May 07, 2018 07:15 AM

    I am trying to xog out the OBS data through the command prompt option in Dev environment. But I am getting the Connection reset error.  As CA suggested I have tried to xog out from specific server without using load balancer url. But still getting the same error due to trying to xog out large data.

     

    I am attaching the error that i am getting for reference.

    Please share your ideas on this issue whoever worked before. Any help would be much appreciated.

     

     



  • 2.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Broadcom Employee
    Posted May 11, 2018 04:34 PM

    What does your OBS_input.xml file look like?  I'm concerned you may be trying to extract too much data in a single pass. 



  • 3.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Posted May 14, 2018 05:10 AM

    Hi Ralph,

     

    I can confirm that due to trying to fetch large data wee are getting Connection reset error. Because I am able to get the xog out of the different custom OBS. 

     

    Could you please advice the way to get the data in multiple parts that might help?

    Your help would be much appreciated.

     

    Thanks,

    Durga NagendraKumar.



  • 4.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Broadcom Employee
    Posted May 14, 2018 12:03 AM

    Hi Durga

     

    How long this took to get the connection reset. Do you have any limit over your network. 

     

    Regards

    Suman Pramanik 



  • 5.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Posted May 14, 2018 05:57 AM

    Hi Suman,

     

    I am not aware of limit over your network. And Xog out has been getting failed after 15 minutes in all the possible ways i know. Could you please provide helpful information on this.

     

    Thanks,

    Durga NagendraKumar.

     

     



  • 6.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Broadcom Employee
    Posted May 14, 2018 06:58 AM

    Try to split the volume of data or you can use pagination if you are on later releases. See the xog developer guide. Also you can use fiddler to see the time took to fail. 



  • 7.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Broadcom Employee
    Posted May 14, 2018 03:10 PM

    Also, you can try to xog out the same using SOAP UI and keep the timeout of the request to 100000 in the request properties.



  • 8.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Posted May 15, 2018 11:57 AM

    Hi Sandeep,

     

    Could you please tell us where exactly we have to make this change?



  • 9.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Broadcom Employee
    Posted May 17, 2018 12:28 PM

    Hi Trupti,

     

    SOAP UI is an external tool which can be used to test/submit webservice requests. We need to create a new soap project and import the WSDL from xog client so that we can submit the soap request.

     

    Regards,

    Sandeep



  • 10.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Posted May 17, 2018 04:21 AM

    Hi Sandeep,

     

    Could you please let me know how to proceed with SOAP UI by keeping the timeout of the request to 100000 in the request properties. Your help would be much appreciated. Please provide us any sample input file for understanding.

     

    Thanks,

    Durga NagendraKuamr.



  • 11.  Re: Unable to Xog out the OBS Data: Getting connection reset error
    Best Answer

    Broadcom Employee
    Posted May 17, 2018 12:31 PM

    Hi Kumar,

     

    SOAP UI is an external tool which can be used to test/submit webservice requests. We need to create a new soap project and import the WSDL from xog client so that we can submit the soap request to your clarity URL (CLARITYURL/niku/xog).

    sample xml file as below:

     

    <soapenv:Envelope xmlns:soapenv="http://shemas.xmlsoap.org/soap/envelope/" xmlns:obj="http://www.niku.com/xog/Object">
    <soapenv:Header>
    <obj:Auth>
    <obj:SessionID>38340061__0E42FADA-C4B9-4C21-AEB5-13599DC66958</obj:SessionID>
    </obj:Auth>
    </soapenv:Header>
    <soapenv:Body>


    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
    <Header version="8.0" action="read" objectType="customObjectInstance" externalSource="NIKU"/>
    <CustomObjectInstanceQuery>
    <Filter name="objectCode" criteria="EQUALS">CUSTOM_OBJECT_CODE</Filter>
    <Filter name="instanceCode" criteria="EQUALS">INSTANCE_ID</Filter>
    </CustomObjectInstanceQuery>

    </NikuDataBus>

     

     

    </soapenv:Body>
    </soapenv:Envelope>

     

     

    Regards,

    Sandeep



  • 12.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Posted Jun 01, 2018 01:59 AM

    Hi Sandeep,

     

    I have tried to by using the below request xml code using SOAP UI tool as you suggested.

     

    <soapenv:Envelope xmlns:soapenv="http://shemas.xmlsoap.org/soap/envelope/" xmlns:obj="http://www.niku.com/xog/Object">
    <soapenv:Header>
    <obj:Auth>
    <obj:SessionID>57526190__4F014090-FEC4-4F33-AAE2-C01E725B18C4</obj:SessionID>
    </obj:Auth>
    </soapenv:Header>
    <soapenv:Body>

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
    <Header version="8.0" action="read" objectType="obs" externalSource="NIKU"/>
    <Query>
    <Filter name="name" criteria="EQUALS">KP Org Hierarchy</Filter>
    </Query>
    </NikuDataBus>
    </soapenv:Body>
    </soapenv:Envelope>

     

    But I did not get the complete output of the OBS as expected. but the status of the xog  request was success. attached the output.

     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header/>
    <soapenv:Body>
    <NikuDataBus xsi:noNamespaceSchemaLocation="../xsd/nikuxog_obs.xsd">
    <Header action="write" externalSource="NIKU" objectType="obs" version="15.2.0.213"/>
    <obsTypes/>
    <XOGOutput>
    <Object type="obs"/>
    <Status state="SUCCESS"/>
    <Skip value="1107"/>
    <XOGTotalFilteredRecords value="1"/>
    <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1107" updatedRecords="0"/>
    <Records/>
    </XOGOutput>
    </NikuDataBus>
    </soapenv:Body>
    </soapenv:Envelope>

     

    I did the above with the best knowledge i had about this SOAP UI tool. Could you please guide me if i need to make any changes to get the expected result. Your help would be much appreciated.



  • 13.  Re: Unable to Xog out the OBS Data: Getting connection reset error

    Posted May 15, 2018 08:52 AM

    Hi Durga,

     

    Agree with Suman and Sandeep. The error may also have to do with the internet connection speed at your home or work.

     

    Suhail.