Skip to Content
0
Jun 19, 2007 at 01:24 PM

Oracle JDBC receiver error

183 Views

Hi,

I am trying to setup a file to Oracle JDBC receiver scenario. In this case I am trying to just insert a single line to Oracle. I get no error in SXMB_MONI, no error in the message mapping test, and no error in the Test configuration in the ID.

Here is the error I get in the RWB comm channel monitoring for my adapter:

<i>No "action" attribute found in XML document ("action" attribute missing or wrong XML structure)

MP: exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

Exception caught by adapter framework: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure).

Here is my structure for the oracle receiver:

DTOracleReceiver_INSERT
    TEMP_DATA_XI                                             1
         action   (attribute)          xsd:string
         access
               NCODE                  xsd:string              1
               VNAME                  xsd:integer            1
               DDATE                   xsd:date                1
               NPRICE                  xsd:decimal           1
               LSTATES               xsd:string               1

TEMP_DATA_XI is my table name in Oracle

action is set to constant "INSERT" in the message mapping.

When I look at the payload in the OracleReceiver adapter, this is what shows up:

<?xml version="1.0" encoding="UTF-8" ?> 
- <ns0:MTOracleReceiver_INSERT xmlns:ns0="http://test.com/jdbc">
- <TEMP_DATA_XI action="INSERT">
    - <access>
        <NCODE>200</NCODE> 
        <VNAME>Inserttest</VNAME> 
        <DDATE>2007-06-15 09:25:43.0</DDATE> 
        <NPRICE>20.00</NPRICE> 
        <LSTATES>test of JDBC receiver</LSTATES> 
     </access>
  </TEMP_DATA_XI>
  </ns0:MTOracleReceiver_INSERT>

Any thoughts or ideas on how to fix this error? Any help would be greatly appreciated.

Thanks,

Jake