JDBC Receiver Issue

[Former Member]

Hi All,

I am currently working RFC to JDBC UPDATE_INSERT I have created below structure getting the fatal error as in below ,Could any one please help me with this.

[Former Member · Accepted solution]

Issue is with the structure,i have changed the structure Access and keys nodes should be under table node,now its working fine

[maheswarareddykonda · Accepted solution]

i think you have missed my post, that is the same thing i have replied, please check

[maheswarareddykonda]

Hi,

Your structure seems wrong, can you make strcture like below.

<root>

  <StatementName1>

<dbTableName action=“UPDATE_INSERT”>

  <table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

  </StatementName1>

  <StatementName2>

<dbTableName action=”UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

             <key1>

             <col2></col2>

             <col4></col4>

             </key1>

</dbTableName>

  </StatementName2>

Note: <access> must be under <table> node , something like below

<MT_Test>

  <StatementName2>

      <dbTableName

             action=”UPDATE_INSERT”>

           <table>realDbTableName</table>

           <access>

           </access>

           <Key>

           </Key>

      </dbTableName>

[iaki_vila]

Hi Ak,

Please copy from the monitoring the XML generated, the issue is clear and it's generated by an incorrect structure. In this way, we will can help you better.

Regards.

[Muniyappan]

Can you check in message monitoring? if the output xml has value for MANDT?

it clearly tells that no value is getting passed to MANDT.

[Former Member]

I have checked in monitoring the MANDT field has value,even though its showing same error,and its not a mandatory field.

[Former Member]

Could any one please help me with the above issue.

[manoj_khavatkopp]

Hi ,

Why don't to check this with Squirel tool ?

Copy the SQL query which is being generated in you receiver communication channel and you can paste the same query in Squirel and check the error.

You have mentioned MANDT filed as optional filed in your structure but this may be mandatory filed on Database side  , Make sure MANDT field has value in both access level and key level also.

Br,

Manoj