CA Clarity - XOG SOAP call - Getting read time out

[Rekha_C]

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

[Suman Pramanik]

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

[Legacy User]

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?

[Rekha_C]

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

[Legacy User]

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

[Eugene Greiff]

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

[Rekha_C]

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

[Legacy User]

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

[Rekha_C]

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

[Legacy User]

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

[Rekha_C]

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

[Legacy User]

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

[Eugene Greiff]

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