Actions
Bug #76
closedRefund Merchandise - REFUND - insert sql error on order no value not in string format
Start date:
01/31/2011
Due date:
02/08/2011
% Done:
100%
Estimated time:
Resolution:
Fixed
Description
17:29:11,494 INFO [STDOUT] DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: SUF402410617 17:29:11,495 ERROR [STDERR] wpwong: ReturnMechandise.java: 31-01-2011 05:29:11: shopperRefundGoods: Insert transaction_BP_rtn, sql error=INSERT INTO transaction_BP_rtn (TRX_REF_NO, TRX_ORDER_NO, TRX_ESALES, TRX_TYPE, TRX_CODE, TRX_DESC, TRX_STATUS, USER_ID, POST_IND, SOURCE, PO_REF, TRX_DATE, SHOPPER_ID, SUPPLIER_ID, UPD_IND, TRX_PT, TRX_QU, REASON_CODE,TRX_AMT,TRX_AMT_LOCAL, MERCHANT_ID, QTY_RTN, PROD_REFNO_RTN, FIRST_INV_QU, PURC_VALUE_QU, TRX_EV_APPLIED, member_id, trx_time, refund_remarks, rtn_type, rtn_mode, rtn_freight_charges, rtn_custom_duty, rtn_service_tax, comp_ind, compute_ind, trx_point, exch_rate, currency_type, sponsor_id, other_charges, other_charge_USD, TOTAL_SP_EARNED, TOTAL_SP_UTILIZED,TOTAL_VP2_EARNED, TOTAL_VP2_UTILIZED, cl_date_fr, coy_id, iso_ind,total_rp_earned,total_rp_utilized,total_rp1_earned,total_rp1_utilized) VALUES( 53039923,SUF402410617,-20.0,'T', '1800','Refund','P','CN857380','N','M','PO000007172910 ',current date,null,'CHC5026','Y',0.0, -20.00,'I change my mind',8.650000,67.440000,30273,1.0,00000000,0,-20.00,-20.0,'CN857380', current timestamp,null,'F',null,0.00,0.00,0.00,'N','N',0.00,7.800000,'HKD',null,0.0,0.0,0.0,0.0,0.0,0.0,'2010-11-04 00:00:00.000','SUF402410617',null,0.00,0.00,0.00,0.00)
Actions