Actions
Bug #55
closedShopper Purchase - order fail insert into transaction table
Start date:
01/24/2011
Due date:
01/28/2011
% Done:
100%
Estimated time:
Resolution:
Fixed
Description
- After payment done, order fail insert into transaction table due to the sql error on insert trx_order_no column as integer.
Log:
SQL State: 42821 14:33:46,319 INFO [STDOUT] DB2 SQL error: SQLCODE: -408, SQLSTATE: 42821, SQLERRMC: TRX_ORDER_NO 14:33:46,320 ERROR [STDERR] eCoswayOrder.class: 24-01-2011 02:33:46: createOrderSuccess: Error in executing the sql! sql=INSERT INTO transaction_012011(trx_ref_no,ecenter_id,member_id,trx_order_no,trx_esales,trx_type,trx_code,trx_desc,trx_amt,other_charges,trx_status,pay_method,user_id,approve_by,date_approved,comp_ind,post_ind,cl_date_fr,cl_date_to,cc_type,cc_comm_pct,cc_comm_amt,exch_rate,currency_type,trx_amt_local,reverse_amount,merchant_Id,source,po_ref,coy_id,trx_date,bank_trx_no,trx_req_amt,bank_acct_no,reset_ind,trx_point,tax_amt,sh_tax_amt,donated_member_id,shopper_id,sec_shopper_id,supplier_id,compute_ind,upd_ind,trx_pt,trx_qu,reason_code,qty_rtn,prod_refno_rtn,EV_TO_APPLY,first_inv_qu,purc_value_qu,card_currency,other_charge_usd,trx_time,sponsor_id,chg_addr_ind,dv_ind, iso_ind, remarks,ORIGINAL_TRX_AMT_LOCAL, ORIGINAL_OTHER_CHARGES_LOCAL) VALUES (53039889,null,'H720195',2934628,1.00,'N','1000','Order',13.65,207.2000,'P','D',null,null,null,'N','N',null,null,'VISA',1.75,1.10425,3.5,'MYR',3.90,0,30273,'S',null,null,current date,null,0,null,'N',0.00,0,0,null,'SH312541',null,null,'N','N',1.00,0,null,0,null,0.00,0,0.00,'USD',59.2000,current timestamp,'778954','N',null,null,null,13.6500,207.2000)
Actions