Response Mapping in Agentry

[CRVMANISH]

Hello Experts,

I am getting response mapping error for SOAP in agentry.

2015/06/26 19:09:00.515:       + User=POC_WM-SOAUSER

2015/06/26 19:09:00.515:         + Application=POC_WM

2015/06/26 19:09:00.515:           + BackEnd=HTTPXML-SOAP_HTTP_XML

2015/06/26 19:09:00.515:             XML node '<DEPT_CODE>' does not map to a property in the current 'BusinessObject' object - Skipping

Below is my actual XML response

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
   <env:Header/>
   <env:Body>
      <OutputParameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.oracle.com/apps/xxnwc/soaprovider/plsql/xxnwc_mob_eamdept/inbound_main/">
         <DEPT_LIST>
            <DEPT_LIST_ITEM>
               <DEPT_CODE>RWWP-MNT</DEPT_CODE>
               <DEPT_DESC>Riyadh Waster Water Plant Above Ground Maintenance Department</DEPT_DESC>
            </DEPT_LIST_ITEM>
            <DEPT_LIST_ITEM>
               <DEPT_CODE>RWWN-MNT</DEPT_CODE>
               <DEPT_DESC>Riyadh Waster Water Network Below Ground Maintenance Department</DEPT_DESC>
            </DEPT_LIST_ITEM>
         </DEPT_LIST>
      </OutputParameters>
   </env:Body>
</env:Envelope>

Please suggest. Where i am doing wrong.

Regards

Manish

[bill_froelich]

Manish,

You need to remove all the < and > from the XPath reference.

Your Base XPath should be /env:Envelope/env:Body/env:OutputParamters/env:DEPT_LIST/env:DEPT_LIST_ITEM

and your XPath is just DEPT_CODE

Remember you need to include all your alias references in the xmlNamespaces of your XML backend connection.

--Bill

[CRVMANISH]

Thanks

I included all the namespace in backend connection.

Still giving same error

"XML node 'DEPT_CODE' does not map to a property in the current 'BusinessObject' object - Skipping "

Regards

Manish

[bill_froelich]

In situations like this I normally take the XML and use another tool to validate my XPath settings and confirm them before pasting them back into Agentry.

--Bill

[CRVMANISH]

Thanks for reply again

I tried using xpath validator but my XML response has one parameter called 'OutputParameters''

which works if i remove 2nd xmlns

<OutputParameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.oracle.com/apps/xxnwc/soaprovider/plsql/xxnwc_mob_eamdept/inbound_main/">

Regards

Manish

[bill_froelich]

Did you get it to work then?

--Bill

[CRVMANISH]

Still Not.

I am not able to remove xmlns from OutputParameters from xml response, will have to check with Oracle Service Base(OSB) team

Regards

Manish

[CRVMANISH]

Hello Experts,

I am getting NULL context node for XML.

Below is the log

2015/07/08 15:30:59.382:             The root object is 'Departments'
2015/07/08 15:31:00.057:             The Unique ID property for the 'Departments' object is 'WORKORDERID'
2015/07/08 15:31:00.807:             Found 3 properties in the 'Departments' object
2015/07/08 15:31:01.242:             Found 1 property mapping in the 'NewDataHTTPRequest' HTTP request
2015/07/08 15:31:02.023:             The XML nodes in the 'NewDataHTTPRequest' HTTP request map to properties in the 'Departments' object as follows:
2015/07/08 15:31:02.408:             >XML node 'WORKORDERID' <-> 'WORKORDERID' property (3 - the Unique ID for the 'Departments' object)
2015/07/08 15:31:02.856:             Processing the XML property mapping for the 'Departments' object - row 1
2015/07/08 15:31:03.194:             Incoming: NULL context node
2015/07/08 15:31:04.071:             + Base XPath=soapenv:Envelope/env:Body/Body/OutputParameters/WORKODER/WORKODER_ITEM
2015/07/08 15:31:04.071:               Compiling XPath: /soapenv:Envelope/env:Body/Body/OutputParameters/WORKODER/WORKODER_ITEM
2015/07/08 15:31:04.937:               *** Could not set the context node for "WORKORDERID" from "soapenv:Envelope/env:Body/Body/OutputParameters/WORKODER/WORKODER_ITEM"
2015/07/08 15:31:05.392:             Base XPath: soapenv:Envelope/env:Body/Body/OutputParameters/WORKODER/WORKODER_ITEM (context node is NULL)
2015/07/08 15:31:05.747:             *** XML node for the unique ID not found: Can't determine object to store current object info in - Skipping row 0
2015/07/08 15:31:06.146:           + BackEnd=HTTPXML-SOAP_HTTP_XML
2015/07/08 15:31:06.146:             Exception during fetch server exchange step for fetch 'MainFetch': EXCEPTION_ACCESS_VIOLATION: EXCEPTION_ACCESS_VIOLATION, 0000000029529BE8, 0, R, 0000000000000000,  in class HTTPXMLBackEndUserFetchConnection at agent\userFetchConnectionSet.cpp:236
2015/07/08 15:31:06.890:           HTTPXML-SOAP_HTTP_XML: rollback transaction
2015/07/08 15:31:07.201:           *** Exception 'EXCEPTION_ACCESS_VIOLATION' caught, see events.logs

Regards

Manish

[CRVMANISH]

Hi

Need your help on above error.

Regards

Manish