on 12-05-2014 10:56 AM
Hi all,
I am working on proxy to jdbc scenario where i am seeing error log in jdbc adapter of communication channel monitering like below:
Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'PO_DTL' (structure 'STATEMENT2'): com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PD_ITEM_CODE' at row 1
Error processing request in sax parser: Error when executing statement for table/stored proc. 'PO_DTL' (structure 'STATEMENT2'): com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PD_ITEM_CODE' at row 1
Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'PO_DTL' (structure 'STATEMENT2'): com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PD_ITEM_CODE' at row 1
When data is pushed from the proxy it comes to IE then AE then go to TARGET, The data is successful in SXMB_MONI, but i got a error in RWB.
Some data is successful in RWB, but some data will not flows(with getting above error) .
for data Flow check below attachment...
The below XML is FAILED in RWB
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_POCreate_IB xmlns:ns0="http://DTDC.com/India/MM/FI_MM_005/POCreate/SAP_2_CTBS">
</ACCESS>
+ <KEY>
</KEY>
</PO_HDR>
</STATEMENT1>
- <STATEMENT2>
- <STATEMENT2>
</ACCESS>
- <KEY>
</KEY>
</PO_DTL>
</STATEMENT2>
</ns0:MT_POCreate_IB>
The below XML is suessful in RWB
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_POCreate_IB xmlns:ns0="http://DTDC.com/India/MM/FI_MM_005/POCreate/SAP_2_CTBS">
</ACCESS>
- <KEY>
</KEY>
</PO_HDR>
</STATEMENT1>
- <STATEMENT2>
</ACCESS>
- <KEY>
</KEY>
</PO_DTL>
</STATEMENT2>
- <STATEMENT2>
</ACCESS>
- <KEY>
</KEY>
</PO_DTL>
</STATEMENT2>
- <STATEMENT2>
</ACCESS>
- <KEY>
</KEY>
</PO_DTL>
</STATEMENT2>
- <STATEMENT2>
</ACCESS>
- <KEY>
</KEY>
</PO_DTL>
</STATEMENT2>
</ns0:MT_POCreate_IB>
Can somebady Help out on this situation..
thanks in Advance
regards,
RajiReddy.
Hi Raj,
In your PD_DTL tag ITEM_CODE is key field... it is mandatory ... it needs to be populated in the structure.
But in your first occurrence of this your are not populating the value of ITEM_CODE... this is the reason it is failing...
So, Send data from Proxy to that field.....So, please compare your success and error payloads of the first occurrence of PD_DTL records.....
Let me know if you require anything from our side.
Thanks,
Sreenivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
PD_ITEM_COD is Key field. So, you have to send some data to this field otherwise it will throws an error.
Please ask ECC people who are sending the data needs to be send that source field.... Otherwise ask your database people is that field is Key field in the structure.
Let me know if you need further help.
Thanks,
Sreenivas.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.