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

Former Member — Fri, 05 Dec 2014 10:56:05 GMT

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 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">

- <STATEMENT1>

- <PO_HDR ACTION="UPDATE_INSERT">

- <ACCESS>

<PH_SUPP_CODE>100234</PH_SUPP_CODE>

<PH_NO>4520001873</PH_NO>

<PH_DATE>2014-12-03</PH_DATE>

<PH_DEL_SCH>2014-12-20</PH_DEL_SCH>

<PH_ITEM_TYPE>CB</PH_ITEM_TYPE>

<PH_TOT_AMT>100</PH_TOT_AMT>

<PH_TYPE>A</PH_TYPE>

<PH_DISCOUNT_TYPE>A</PH_DISCOUNT_TYPE>

<PH_FRE_TYPE>A</PH_FRE_TYPE>

<PH_APPR_STATUS>A</PH_APPR_STATUS>

<MOD_DATE>2014-12-03</MOD_DATE>

</ACCESS>

+ <KEY>

<PH_NO>4520001873</PH_NO>

</KEY>

</PO_HDR>

</STATEMENT1>

- <STATEMENT2>

- <PO_DTL ACTION="UPDATE_INSERT">

- <ACCESS>

<PD_NO>4520001873</PD_NO>

<PD_QTY>1.000</PD_QTY>

<OFFICE_CODE>DD</OFFICE_CODE>

<PD_SLNO>00020</PD_SLNO>

<PD_RATE>10</PD_RATE>

<PD_STATUS>A</PD_STATUS>

<MOD_DATE>2014-12-03</MOD_DATE>

</ACCESS>

- <KEY>

<PD_NO>4520001873</PD_NO>

<PD_SLNO>00020</PD_SLNO>

</KEY>

</PO_DTL>

</STATEMENT2>

- <STATEMENT2>

- <PO_DTL ACTION="UPDATE_INSERT">

- <ACCESS>

<PD_NO>4520001873</PD_NO>

<PD_ITEM_CODE>C144</PD_ITEM_CODE>

<PD_QTY>2.000</PD_QTY>

<OFFICE_CODE>DD</OFFICE_CODE>

<PD_SLNO>00010</PD_SLNO>

<PD_RATE>10</PD_RATE>

<PD_STATUS>A</PD_STATUS>

<MOD_DATE>2014-12-03</MOD_DATE>

</ACCESS>

- <KEY>

<PD_NO>4520001873</PD_NO>

<PD_ITEM_CODE>C144</PD_ITEM_CODE>

<PD_SLNO>00010</PD_SLNO>

</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">

- <STATEMENT1>

- <PO_HDR ACTION="UPDATE_INSERT">

- <ACCESS>

<PH_SUPP_CODE>105116</PH_SUPP_CODE>

<PH_NO>4530002236</PH_NO>

<PH_DATE>2014-12-04</PH_DATE>

<PH_DEL_SCH>2014-12-05</PH_DEL_SCH>

<PH_ITEM_TYPE>CB</PH_ITEM_TYPE>

<PH_TOT_AMT>100</PH_TOT_AMT>

<PH_TYPE>A</PH_TYPE>

<PH_DISCOUNT_TYPE>A</PH_DISCOUNT_TYPE>

<PH_FRE_TYPE>A</PH_FRE_TYPE>

<PH_APPR_STATUS>A</PH_APPR_STATUS>

<MOD_DATE>2014-12-04</MOD_DATE>

</ACCESS>

- <KEY>

<PH_NO>4530002236</PH_NO>

</KEY>

</PO_HDR>

</STATEMENT1>

- <STATEMENT2>

- <PO_DTL ACTION="UPDATE_INSERT">

- <ACCESS>

<PD_NO>4530002236</PD_NO>

<PD_ITEM_CODE>MB38</PD_ITEM_CODE>

<PD_QTY>6000.000</PD_QTY>

<OFFICE_CODE>DD</OFFICE_CODE>

<PD_SLNO>00010</PD_SLNO>

<PD_RATE>10</PD_RATE>

<PD_STATUS>A</PD_STATUS>

<MOD_DATE>2014-12-04</MOD_DATE>

</ACCESS>

- <KEY>

<PD_NO>4530002236</PD_NO>

<PD_ITEM_CODE>MB38</PD_ITEM_CODE>

<PD_SLNO>00010</PD_SLNO>

</KEY>

</PO_DTL>

</STATEMENT2>

- <STATEMENT2>

- <PO_DTL ACTION="UPDATE_INSERT">

- <ACCESS>

<PD_NO>4530002236</PD_NO>

<PD_ITEM_CODE>MB56</PD_ITEM_CODE>

<PD_QTY>8000.000</PD_QTY>

<OFFICE_CODE>DD</OFFICE_CODE>

<PD_SLNO>00060</PD_SLNO>

<PD_RATE>10</PD_RATE>

<PD_STATUS>A</PD_STATUS>

<MOD_DATE>2014-12-04</MOD_DATE>

</ACCESS>

- <KEY>

<PD_NO>4530002236</PD_NO>

<PD_ITEM_CODE>MB56</PD_ITEM_CODE>

<PD_SLNO>00060</PD_SLNO>

</KEY>

</PO_DTL>

</STATEMENT2>

- <STATEMENT2>

- <PO_DTL ACTION="UPDATE_INSERT">

- <ACCESS>

<PD_NO>4530002236</PD_NO>

<PD_ITEM_CODE>MB54</PD_ITEM_CODE>

<PD_QTY>12000.000</PD_QTY>

<OFFICE_CODE>DD</OFFICE_CODE>

<PD_SLNO>00040</PD_SLNO>

<PD_RATE>10</PD_RATE>

<PD_STATUS>A</PD_STATUS>

<MOD_DATE>2014-12-04</MOD_DATE>

</ACCESS>

- <KEY>

<PD_NO>4530002236</PD_NO>

<PD_ITEM_CODE>MB54</PD_ITEM_CODE>

<PD_SLNO>00040</PD_SLNO>

</KEY>

</PO_DTL>

</STATEMENT2>

- <STATEMENT2>

- <PO_DTL ACTION="UPDATE_INSERT">

- <ACCESS>

<PD_NO>4530002236</PD_NO>

<PD_ITEM_CODE>MB65</PD_ITEM_CODE>

<PD_QTY>1000.000</PD_QTY>

<OFFICE_CODE>DD</OFFICE_CODE>

<PD_SLNO>00070</PD_SLNO>

<PD_RATE>10</PD_RATE>

<PD_STATUS>A</PD_STATUS>

<MOD_DATE>2014-12-04</MOD_DATE>

</ACCESS>

- <KEY>

<PD_NO>4530002236</PD_NO>

<PD_ITEM_CODE>MB65</PD_ITEM_CODE>

<PD_SLNO>00070</PD_SLNO>

</KEY>

</PO_DTL>

</STATEMENT2>

</ns0:MT_POCreate_IB>

Can somebady Help out on this situation..

thanks in Advance

regards,

RajiReddy.

Re: 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

former_member191435 — Fri, 05 Dec 2014 11:07:05 GMT

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

Re: 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

Former Member — Mon, 08 Dec 2014 07:19:42 GMT

Hi Srinivas,

Please check the above mapping, the concurrence of key field PD_ITEM_COD is (0-1) Only. it is not mandatory...

thanks,

Raj

Re: 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

former_member191435 — Mon, 08 Dec 2014 07:33:53 GMT

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.

Question Re: 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 in Technology Q&A

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

Re: 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

Re: 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

Re: 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