Order ID migration

Error insert transaction table. 1) Transaction_undefined table name; 2) trx_order_no = 'xxxx ' fail to match due to space trailer.

Log:

14:38:06,684 INFO  [STDOUT] SQL State: 42704
14:38:06,684 INFO  [STDOUT] DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2INST1.TRANSACTION_UNDEFINED
14:38:06,684 ERROR [STDERR] bp_bo_refundMerchandiseView.jsp: execute sql error= SELECT upd_ind FROM transaction_undefined WHERE trx_order_no = '402410585      ' and trx_code ='1000' and trx_status = 'A' and trx_type <> 'M' error=CWC: executeQuery(A database manager error occurred.)
14:38:06,695 INFO  [STDOUT] A database manager error occurred.
14:38:06,695 INFO  [STDOUT] SQL State: 42601
14:38:06,695 INFO  [STDOUT] DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: CN857380' or SHOPPER_ID = 'CN857380') ';and (MEMBER_ID = ';<space>
14:38:06,695 ERROR [STDERR] wpwong: MallOrderBean.java: 24-01-2011 02:38:06: getMultiplePayment: errDesc=Execute sql error!!! sql= select CHG_ADDR_IND, ECENTER_ID, TRX_DATE, PAY_METHOD, (TRX_AMT + value(OTHER_CHARGES,0)) TOTALLOCALAMT, CURRENCY_TYPE, EXCH_RATE,  (TRX_AMT_LOCAL + value(OTHER_CHARGE_USD,0)) TOTALUSDAMT, CC_TYPE, CARD_CURRENCY, value(TM_NUMBER, '-NA-') as CALLBACKTELNO, value(TM_STATUS, '-NA-') AS CALLBACKSTATUS, value(TM_ERROR, -99) AS CALLBACKREASONCODE from TRANSACTION_undefined where TRX_ORDER_NO = '402410585       and (MEMBER_ID = 'CN857380' or SHOPPER_ID = 'CN857380') ' and TRX_CODE = '1000' and TRX_TYPE <> 'M'
14:38:06,696 ERROR [STDERR] ,errSystem=CWC: executeQuery(A database manager error occurred.)