on 09-03-2015 6:50 PM
Issue is with the structure,i have changed the structure Access and keys nodes should be under table node,now its working fine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.