Project

General

Profile

Actions

Bug #76

closed

Refund Merchandise - REFUND - insert sql error on order no value not in string format

Added by Chooi-Mey over 13 years ago. Updated over 13 years ago.

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

Also available in: Atom PDF