AnsweredAssumed Answered

XOG Idea Read:  Unexpected Character Literal

Question asked by mtognetti on Feb 1, 2018
Latest reply on Feb 2, 2018 by gcubed

Good Afternoon Community,

A fellow developer and I are working on a process to integrate data from one system into CA PPM and back again (two way communication) via SOAP protocols.

At this time we are working on a simple read to ensure we have connectivity, after this test we will look to call a WSDL created from an NSQL Query.  However, we are getting an error even on this basic read.  The xml looks like this:

<soap:Envelope xmlns:tns="" xmlns:soap="">
<NikuDataBus xmlns:xsi="" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
  <Header version="6.0.13" action="read" objectType="idea" externalSource="NIKU">
    <args name="include_resources" value="true"/>
    <args name="include_tasks" value="true"/>
    <args name="include_allocations" value="true"/>
    <Filter name="objectID" criteria="EQUALS">[Identifier]</Filter>

please note that identifier is the value from the table.column : inv_investments.code and is a string value

The error we are being returned is:

<soapenv:Envelope xmlns:soapenv="" xmlns:xsi="">
      <XOGOutput xmlns:xsi="" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
         <Object type="idea"/>
         <Status elapsedTime="0.001 seconds" state="FAILURE"/>
         <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
            <Description>[Error] :1:1: unexpected character literal</Description>
            <Exception type="java.lang.Exception">Invalid xml data</Exception>

We have been unable to identify the unexpected character literal.  We do not see (in the code) any of the Usual suspects (' ', <, >, &). 

We would appreciate any help and guidance you can provide.

Thank you.