Clarity

Expand all | Collapse all

CA Clarity - XOG SOAP call - Getting read time out

  • 1.  CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 03:45 AM

    Hi am trying to call SOAP clarity service,

     

    I wan to fetch all project - allocation realted data.

    Service  is returnign -read time out

     

    Can you please help ?

    Many thanks



  • 2.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:38 AM

    How many number of project allocation you are trying to xog out, try breaking down to small chunk and give it a try.

     

    Regards

    Suman Pramanik



  • 3.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 09:50 AM

    Can you share the XML read file?  It is tough to figure out with the amount of information you have provided.

    Also, how are you trying to run the XOG?



  • 4.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:00 PM

    Fpena and Suman , thanks for the reply.

    Here is  XML read file i am using as Query -

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">

      <Header version="6.0.11" action="read" objectType="project" externalSource="NIKU"> 

        <args name="order_by_1" value="name"/>

        <args name="order_by_2" value="projectID"/>

      

        </Header>

      <Query>

      <Filter name="active" criteria="EQUALS">true</Filter>

    </Query>

    </NikuDataBus>

     

    I am invoking SOAP request via SOAPUI

     

    Many Thanks,

    Rekha



  • 5.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:08 PM

    well you are trying to pull back all the active projects in one XOG.  For sure that is going to cause problems. 

    you mention that you only want to pull allocation data, you might want to add additional arguments to ensure you do not get unnecessary nodes since you are trying to pull back so much.

    Something like this:

      <args name="include_tasks" value="false"/>

        <args name="include_dependencies" value="false"/>

        <args name="include_subprojects" value="false"/>

        <args name="include_resources" value="false"/>

        <args name="include_baselines" value="false"/>

        <args name="include_allocations" value="true"/>

        <args name="include_estimates" value="false"/>

        <args name="include_actuals" value="false"/>

        <args name="include_custom" value="false"/>

    I would recommend you extract your projects in smaller batches (I always prefer by doing them individually) instead of ALL active.

    i'm pretty sure that is your issue.

    Hope this helps



  • 6.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-09-2015 12:20 AM

    For SoapUI you can increase the timeout of the request.

     

    Click on the request and increase the timeout.  I believe it is in milliseconds.

     

     

    V/r,

    Gene



  • 7.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:11 PM

    well, to run query on smaller batches , I need to know the  all project details first.

     

    Can you pls share simple query -which returns only, all  project names/project Ids,

    Then in the subsequent call I can try getting allocation data for a perticular project.

     

    Thanks,

    Rekha



  • 8.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:15 PM

    Here is the query:

    select name, code from inv_investments where object_code='project'

     

    here is the XML per project.

     

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">

      <Header action="read" externalSource="NIKU" objectType="project" version="6.0.11">

        <!-- you change the order by simply swap 1 and 2 number in the name attribute -->

        <args name="order_by_1" value="name"/>

        <args name="order_by_2" value="projectID"/>

        <args name="include_tasks" value="false"/>

        <args name="include_dependencies" value="false"/>

        <args name="include_subprojects" value="false"/>

        <args name="include_resources" value="false"/>

        <args name="include_baselines" value="false"/>

        <args name="include_allocations" value="false"/>

        <args name="include_estimates" value="false"/>

        <args name="include_actuals" value="false"/>

        <args name="include_custom" value="false"/>

     

      </Header>

      <Query>

        <Filter criteria="EQUALS" name="projectID">${code}</Filter>

      </Query>

    </NikuDataBus>

     

    hope that helps,

    Federico



  • 9.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:29 PM

    Pena,

     

    I am using this Query to get all project name and ID, But it is still getting timed out

     

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">

      <Header version="6.0.11" action="read" objectType="project" externalSource="NIKU">

        <!-- you change the order by simply swap 1 and 2 number in the name attribute -->

        <args name="order_by_1" value="name"/>

        <args name="order_by_2" value="projectID"/>

      </Header>

      <Query>

      </Query>

    </NikuDataBus>

     

     

    Thanks,

    Rekha



  • 10.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:31 PM

    Hi Rekha

    that is because there is nothing between your <Query></Query> tags.

    see the example i provided above.  Relpace ${code} with the actual project code.

    Cheers,

    Federico



  • 11.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:38 PM

    Pena, sorry for the confusion here..

     

    I do not have access to database...

    So , first I need a SOAP  query to get all project code ..

     

    Thanks,

    Rekha



  • 12.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-08-2015 05:41 PM

    Hi Rekha,

    you have 2 options, you could go to the project list to get the project ID's. but if you want to run a query without DB access, you can do it through here

    https://xogbridge.itroisolutions.com   there is a video on the splash screen that will show you how to do this.

    cheers,

    Federico



  • 13.  Re: CA Clarity - XOG SOAP call - Getting read time out

    Posted 06-09-2015 12:29 AM

    Have someone build you an NSQL to just get the ProjectID and Program Name.  Call the query service first to get the list of project ID/Names. Loop over the results set to call the Object service to get what you need from the projects.

     

    V/r,

    Gene