problem with XML SQL JDBC adapter

[Former Member]

Hello All.

I have quite strange problem with my PI.

Whole scenario is SOAP -> JDBC, asynchronous. Everything works fine on DEV server. After transporting objects (using CTS) to QA env I'm getting this error:

JDBC Message processing failed, due to Error processing request in sax parser:
 No 'action' attribute found in XML document 
(attribute "action" missing or wrong XML structure)

But document seems to be correct. I've compared it to DEV server documents - they are identical. What could be wrong??

Document looks like this:

<ns2:BIPMessage xmlns:ns2="http://mynamespace.com/xi/sn" 
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" 
xmlns:xs="http://www.w3.org/2001/XMLSchema" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <synchSlLok>
   <STATEMENTNAME>
     <SYNCH_SL_LOK ACTION="INSERT">
        <TABLE>SYNCH_SL_LOK</TABLE> 
         <ACCESS>
            <ID_TRANS>22050</ID_TRANS> 
            <ID_LOK>1234</ID_LOK> 
            <ID_CBK>1000050911</ID_CBK> 
            <NR_LOK>1234</NR_LOK> 
            <OPIS_LOK>12312312312312</OPIS_LOK> 
            <TYP>D</TYP> 
            <OPERACJA>U</OPERACJA> 
          </ACCESS>
      </SYNCH_SL_LOK>
    </STATEMENTNAME>
  </synchSlLok>
  </ns2:BIPMessage>

TIA

Best Regads

Maciej

[aashish_sinha]

Hi,

i was also facing the same error few days back in a JDBC -RFC-JDBC Synchronous scenario. In that scenario, i was using 2 modules in JDBC sender module tab. It was working fine. later i change polling interval and then i started getting same error. it happened coz of sequence of Module got changed somehow.

So please check in Receiver JDBC adapter and SOAP sender adapter CC if anything is changed. If this scenario is working in DEV as it is then it should work after transport.

Else have a look here

Regards

Aashish Sinha

Edited by: Aashish Sinha on Mar 15, 2011 10:42 AM

[Former Member]

Use following link

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

And use u201Cactionu201D as attribute..

Thanks,

Bhupesh

[Former Member]

Yes, you have to set the xml structure with field name <ACTION> and not with <SYNCH_SL_LOK ACTION>