strange error at jdbc receiver

[Former Member]

error is

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'o_tpc09_orderdtl' (structure 'STATEMENT'): java.sql.SQLException: INSERT u4E0E VALUES u7684u5217u6570u76EEu4E0Du5339u914Du3002

message is

ns0:mm0072send>
<STATEMENT>
<dbTableName action="INSERT">
<TABLE>o_tpc09_orderdtl</TABLE>
<access>
<orddtlno/>
<ordno/>
<custcd>00319800</custcd>
<busiclasscd>11</busiclasscd>
<busichannelcd/>
<busdstrctcd/>
<busitemcd/>
<gdsdate>20090407</gdsdate>
<vichno/>
<cigcd>310101</cigcd>
<ctrdtlno>1000000210</ctrdtlno>
<gdsprice>2,000.00</gdsprice>
<gdsqnt>5.0000</gdsqnt>
<cigtypecd>01</cigtypecd>
<gdsamt>10,000.00</gdsamt>
<setldtlno/>
<setlflg>0</setlflg>
<selno>0</selno>
<idxno>5000000000</idxno>
<bpendflg>0</bpendflg>
<bpendid>0</bpendid>
<dbpendid>0</dbpendid>
<unitid>05</unitid>
<sapflag>0</sapflag>
<billdate>20090407</billdate>
</access>
u2212
<access>
<orddtlno/>
<ordno/>
<custcd>00319800</custcd>
<busiclasscd>11</busiclasscd>
<busichannelcd/>
<busdstrctcd/>
<busitemcd/>
<gdsdate>20090409</gdsdate>
<vichno/>
<cigcd>310101</cigcd>
<ctrdtlno>0000000010</ctrdtlno>
<gdsprice>2,000.00</gdsprice>
<gdsqnt>10.0000</gdsqnt>
<cigtypecd>01</cigtypecd>
<gdsamt>20,000.00</gdsamt>
<setldtlno/>
<setlflg>0</setlflg>
<selno>0</selno>
<idxno>5000000010</idxno>
<bpendflg>0</bpendflg>
<bpendid>0</bpendid>
<dbpendid>0</dbpendid>
<unitid>05</unitid>
<sapflag>0</sapflag>
<billdate>20090409</billdate>
</access>
u2212
<access>
<orddtlno/>
<ordno/>
<custcd>00319800</custcd>
<busiclasscd>11</busiclasscd>
<busichannelcd/>
<busdstrctcd/>
<busitemcd/>
<gdsdate>20090409</gdsdate>
<vichno/>
<cigcd>310101</cigcd>
<ctrdtlno>0000000010</ctrdtlno>
<gdsprice>2,000.00</gdsprice>
<gdsqnt>10.0000</gdsqnt>
<cigtypecd>01</cigtypecd>
<gdsamt>20,000.00</gdsamt>
<setldtlno/>
<setlflg>0</setlflg>
<selno>0</selno>
<idxno>5000000011</idxno>
<bpendflg>0</bpendflg>
<bpendid>0</bpendid>
<dbpendid>0</dbpendid>
<unitid>05</unitid>
<sapflag>0</sapflag>
<billdate>20090409</billdate>
</access>
u2212
<access>
<orddtlno/>
<ordno/>
<custcd/>
<busiclasscd>11</busiclasscd>
<busichannelcd/>
<busdstrctcd/>
<busitemcd/>
<gdsdate>20090409</gdsdate>
<vichno/>
<cigcd>310101</cigcd>
<ctrdtlno>0000000110</ctrdtlno>
<gdsprice>2,000.00</gdsprice>
<gdsqnt>1.0000</gdsqnt>
<cigtypecd>01</cigtypecd>
<gdsamt>2,000.00</gdsamt>
<setldtlno/>
<setlflg>0</setlflg>
<selno>0</selno>
<idxno>5000000012</idxno>
<bpendflg>0</bpendflg>
<bpendid>0</bpendid>
<dbpendid>0</dbpendid>
<unitid>05</unitid>
<sapflag>0</sapflag>
<billdate>20090409</billdate>
</access>
u2212
<access>
<orddtlno/>
<ordno/>
<custcd/>
<busiclasscd>11</busiclasscd>
<busichannelcd/>
<busdstrctcd/>
<busitemcd/>
<gdsdate>20090409</gdsdate>
<vichno/>
<cigcd>310102</cigcd>
<ctrdtlno>0000000120</ctrdtlno>
<gdsprice>1,500.00</gdsprice>
<gdsqnt>1.0000</gdsqnt>
<cigtypecd>01</cigtypecd>
<gdsamt>1,500.00</gdsamt>
<setldtlno/>
<setlflg>0</setlflg>
<selno>0</selno>
<idxno>5000000012</idxno>
<bpendflg>0</bpendflg>
<bpendid>0</bpendid>
<dbpendid>0</dbpendid>
<unitid>05</unitid>
<sapflag>0</sapflag>
<billdate>20090409</billdate>
</access>
</dbTableName>
</STATEMENT>
</ns0:mm0072send>

Edited by: Shen Peng on Jun 16, 2009 5:56 PM

Edited by: Shen Peng on Jun 16, 2009 5:57 PM

Edited by: Shen Peng on Jun 16, 2009 5:58 PM

[Former Member]

because error data format of decimal:

50,000.00

should be 50000.00

[Former Member]

Hi,

This error due to incorrect JDBC structure. Pls check your JDBC structure and try again.

Abid

[former_member200962]

there seems to be a mismatch between the JDBC receive structure and your DB table structure...please check the JDBC structure again..

Regards,

Abhishek.