AnsweredAssumed Answered

Getting Error on  SOAP XOG call to calrity for Project allocation realted Query ?

Question asked by Rekha_C on May 27, 2015
Latest reply on May 28, 2015 by nick_darlington

I am trying to fetch  resource allocation realated data  from Clarity using SOAP XOG call.

 

Query :

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

  <Header version="7.5" 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"/>

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

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

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

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

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

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

  </Header>

  <Query>

 

     <Filter name="projectID" criteria="EQUALS">ProjectID</Filter>

  <Filter name="resourceID" criteria="EQUALS">RID</Filter>

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

   </Query>

</NikuDataBus>

 

Response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

   <soapenv:Header/>

   <soapenv:Body>

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

         <Header action="write" externalSource="NIKU" objectType="project" version="13.1.0.0248"/>

         <Projects/>

         <XOGOutput>

            <Object type="project"/>

            <Status state="FAILURE"/>

            <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>

            <Records>

               <Record>

                  <KeyInformation>

                     <column name="id"/>

                     <column name="name"/>

                  </KeyInformation>

                  <ErrorInformation>

                     <Severity>FATAL</Severity>

                     <Description>Project Object read failed</Description>

                     <Exception>java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00920: invalid relational operator

 

 

  at com.ca.c

 

 

 

What can be possible mistakes I am making here ?

Help please

Many Thanks.

Outcomes