Proxy to JDBC a small issue

[vijay_kumar133]

Hi friends,

I had a scnario where i am using proxy to JDBC this is sync scnario. when i am triggring the proxy with help of a report.

If the data is present every thing is working fine.. in one case if data is not there in the sender side . mean payloade is blank then the interface is throughing error. the error is..

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Inbound Message

-->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

Regards

Viajy

[Former Member]

Check ur Internal Table for any Content...

if Internal Table is not Initial then

Call Method Asynchronous.

else

write tat data is not populated something like tat

endif.

[vijay_kumar133]

hi friends the

Xml payloade contains.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_AMS_Inb xmlns:ns0="http://abc.com">

- <Statement>

- <tblleave action="INSERT">

<TABLE>tblleave</TABLE>

</tblleave>

</Statement>

</ns0:MT_AMS_Inb>

for this that error has come so for this what need to do to solve at this cases

Regards

Vijay

[MichalKrawczyk]

hi,

>>>>what need to do to solve at this cases

correct your mapping - what else

if it comes to jdbc with empty payload then the mapping didn't work probably so just correct it

Regards,

michal

[vijay_kumar133]

Hi Michal,

Thanks a lot for reply..

This is what i used my mapping please say me where i need to change my mapping part to over come this,,

http://picasaweb.google.co.uk/vmail.sap/Mapping_issue/photo#5226159804438871378

Please check this and say me what i need to change to over come this..

Regards

vijay

[vijay_kumar133]

Hi

One more thing..

The same mapping is working fine for asyncronious .. when i am using this in syncronious then this error is comming ..

Regards

Vijay

[vijay_kumar133]

Hi friends,

How to handle empty payloade in syncronious jdbc update...

Regards

Vijay

[Former Member]

Hi,

Why dont you check if the internal table is holding any data before triggering the proxy in your report ..

Regards

Shailesh

[Former Member]

Hi Vijay,

1. Your target message to JDBC adapter should look like-

<StatementName2>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName2>

So change the mapping/data type as requried.

2. Go to the runtime workbench and check the JDBC communication channel error messages. It will give you enough information as to what causes the error.

Regards.