cancel
Showing results for 
Search instead for 
Did you mean: 

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
0 Kudos

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

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member191435
Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member191435
Contributor
0 Kudos

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.