Project

General

Profile

Actions

Bug #55

closed

Shopper Purchase - order fail insert into transaction table

Added by chin-yeh over 13 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
eCosway mall
Target version:
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 #1

Updated by chin-yeh over 13 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

[nicholas] insert table error fixed

Actions #2

Updated by chin-yeh over 13 years ago

  • Assignee changed from Chee-Hoong to Chooi-Mey

verify if it's been fixed

Actions #3

Updated by chin-yeh over 13 years ago

  • Status changed from Resolved to Feedback
Actions #4

Updated by Chooi-Mey over 13 years ago

  • Status changed from Feedback to Closed

Tested.

Actions

Also available in: Atom PDF