Order ID migration

02/09/2011

12:29 PM Bug #76 (Closed): Refund Merchandise - REFUND - insert sql error on order no value not in string format

Tested. Chooi-Mey

09:53 AM Bug #76 (Resolved): Refund Merchandise - REFUND - insert sql error on order no value not in string format

the problems have been fixed and verified chin-yeh

10:48 AM Bug #74 (Closed): Online Office - Cancel Order - Order No fail search

Chooi-Mey

10:47 AM Bug #77 (Closed): Cancel Order - View Order Details - NumberFormat Exception

Chooi-Mey

09:56 AM Feature #79: conduct trial run on offline batches

*8-Feb's result*:
# DailyEV - hang
# genMthlyEacctMovement - hang
chin-yeh

02/08/2011

05:41 PM Bug #76 (In Progress): Refund Merchandise - REFUND - insert sql error on order no value not in string format

No problem found on code Chee-Hoong

04:11 PM Bug #76: Refund Merchandise - REFUND - insert sql error on order no value not in string format

no more insert SQL error now. however, can you check which part of codes are causing the following error:
* go to My... chin-yeh

02:41 PM Bug #76: Refund Merchandise - REFUND - insert sql error on order no value not in string format

sql fixed, class file redeployed and web.xml touched Chee-Hoong

12:34 PM Bug #76: Refund Merchandise - REFUND - insert sql error on order no value not in string format

please double check if it's been fixed chin-yeh

12:01 PM Bug #76 (Feedback): Refund Merchandise - REFUND - insert sql error on order no value not in string format

sql insert fixed Chee-Hoong

09:44 AM Bug #76: Refund Merchandise - REFUND - insert sql error on order no value not in string format

do fix this bug also:... chin-yeh

09:36 AM Bug #76: Refund Merchandise - REFUND - insert sql error on order no value not in string format

Steps to reproduce:
# login to My Account
# go to *My Orders* -> *Refund Merchandise - REFUND*
# enter *any alphan... chin-yeh

04:20 PM Bug #78 (Closed): Cancel Order - throws exception when submit "cancel order" request

cannot cancel multiple ID order chin-yeh

04:10 PM Bug #78 (Feedback): Cancel Order - throws exception when submit "cancel order" request

order cancelation success Chee-Hoong

10:00 AM Bug #78 (Closed): Cancel Order - throws exception when submit "cancel order" request

Steps to reproduce:
# login to *My Account*
# go to *My Order* -> *Cancel Order*
# search all orders for a particu... chin-yeh

02:48 PM Bug #75 (Closed): Online Office - View Order Details - NumberFormat Exception

Tested. Chooi-Mey

12:36 PM Bug #75: Online Office - View Order Details - NumberFormat Exception

tested ok chin-yeh

11:13 AM Bug #75 (Feedback): Online Office - View Order Details - NumberFormat Exception

the (NumberFormatException) error fixed and tested.
result successfully display. Chee-Hoong

12:39 PM Bug #74: Online Office - Cancel Order - Order No fail search

order listing and alphanumeric searching are both tested ok. chin-yeh

12:00 PM Bug #74: Online Office - Cancel Order - Order No fail search

.trim() function added for orderNo searching but doesnt work Chee-Hoong

09:53 AM Bug #74: Online Office - Cancel Order - Order No fail search

still not able to search alphanumeric order number. chin-yeh

12:15 PM Bug #77: Cancel Order - View Order Details - NumberFormat Exception

tested ok chin-yeh

12:05 PM Bug #77 (Feedback): Cancel Order - View Order Details - NumberFormat Exception

NumberFormatException fixed.
result successfully displayed Chee-Hoong

10:47 AM Feature #79 (Closed): conduct trial run on offline batches

conduct daily trial run for offline batches. It's been scheduled to run from *8-Feb* to *11-Feb*
* schedule to run... chin-yeh

09:15 AM Bug #57 (Closed): Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

chin-yeh

01/31/2011

05:42 PM Bug #77 (Closed): Cancel Order - View Order Details - NumberFormat Exception

17:35:38,666 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
17:35:38,666 ERROR [STDERR] Caused by: java... Chooi-Mey

05:40 PM Bug #76: Refund Merchandise - REFUND - insert sql error on order no value not in string format

Error hit during perform return submission. Chooi-Mey

05:38 PM Bug #76 (Closed): Refund Merchandise - REFUND - insert sql error on order no value not in string format

... Chooi-Mey

05:25 PM Bug #57: Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

the US credit card is tested after the URL can be link.
no error and transaction is success with receipt displayed o... Chee-Hoong

04:41 PM Bug #57: Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

the US credit card is tested after the URL can be link.
no error and transaction is success with receipt displayed o... Chee-Hoong

03:39 PM Bug #57: Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

Do capture the full error message next time.
By the way, the error occured because the receipt URLs were not autho... chin-yeh

03:30 PM Bug #57 (Feedback): Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

payment reach end of stage with receipt displayed (for "others" credit card)
url link not found for US credit card
Chee-Hoong

05:11 PM Bug #74 (Feedback): Online Office - Cancel Order - Order No fail search

this bug is fixed. alphaNumeric validation added for searching.
however, trim() function doesnt work for user input. Chee-Hoong

03:28 PM Bug #74 (In Progress): Online Office - Cancel Order - Order No fail search

checking Chee-Hoong

03:00 PM Bug #74 (Feedback): Online Office - Cancel Order - Order No fail search

the 2 errors still exists:
# *My Order* -> *Cancel Order*
!cancel_order.JPG!
# *My Order* -> *Cancel Order* -> s... chin-yeh

12:29 PM Bug #74 (In Progress): Online Office - Cancel Order - Order No fail search

view order status bug fixed.
alphaNumeric validation added.
search result will return "all" if
is no any user inpu... Chee-Hoong

04:38 PM Bug #73 (Closed): Super Selection Order Adminstration - View order detrails - NumberFormatException

Tested. Chooi-Mey

02:31 PM Bug #73: Super Selection Order Adminstration - View order detrails - NumberFormatException

chin-yeh wrote:
> deployed the fix already. the fix will check if the order number is numeric before do any numeric ... chin-yeh

11:30 AM Bug #73 (Feedback): Super Selection Order Adminstration - View order detrails - NumberFormatException

deployed the fix already. the fix will check if the order number is numeric before do any numeric parsing.
how to ve... chin-yeh

11:24 AM Bug #73 (In Progress): Super Selection Order Adminstration - View order detrails - NumberFormatException

steps to reproduce:
# login to control center
# go to *Super Selection Order Administration* -> *Order Enquiry*
# dis... chin-yeh

02:31 PM Bug #75 (In Progress): Online Office - View Order Details - NumberFormat Exception

checking Chee-Hoong

02:26 PM Bug #75 (Closed): Online Office - View Order Details - NumberFormat Exception

From Order listing, click on one of the order record (with alphanumeric order no), it link to blank details page with... Chooi-Mey

02:14 PM Bug #66 (Closed): Online Office - View Order Status

Tested. Chooi-Mey

12:07 PM Bug #66 (Feedback): Online Office - View Order Status

the view order status bug fixed.
alphanumeric validation added. Chee-Hoong

01/28/2011

04:50 PM Bug #57 (In Progress): Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

please double check if it's been fixed. chin-yeh

04:36 PM Bug #57 (Feedback): Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

fixed, tested, and commited Chee-Hoong

03:47 PM Bug #57: Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

Chee-Hoong wrote:
> invalid data type fixed.
has it been fixed? chin-yeh

04:38 PM Bug #66 (In Progress): Online Office - View Order Status

still fixing Chee-Hoong

04:05 PM Bug #72 (Closed): BO Administration - Business Status India - Page Error

Chooi-Mey

03:46 PM Bug #72 (Feedback): BO Administration - Business Status India - Page Error

this bug exists in the existing environment also. chin-yeh

04:04 PM Bug #71 (Closed): Ecenter Administration - Withdrawal Approval - SQL Error - Function itself hit exception.

Chooi-Mey

03:41 PM Bug #71 (Feedback): Ecenter Administration - Withdrawal Approval - SQL Error - Function itself hit exception.

similiar to the issue #69 chin-yeh

03:56 PM Bug #70 (Closed): "Ecenter Administration - Withdrawal - SQL Error - Function itself hit exception

Chooi-Mey

03:39 PM Bug #70 (Feedback): "Ecenter Administration - Withdrawal - SQL Error - Function itself hit exception

similiar to the issue #68 which did not provide the required parameters. chin-yeh

03:54 PM Bug #69 (Closed): Ecenter Administration - Deposit Approval Management - SQL Error - Function itself hit exception.

Chooi-Mey

03:36 PM Bug #69 (Feedback): Ecenter Administration - Deposit Approval Management - SQL Error - Function itself hit exception.

additional log:... chin-yeh

03:53 PM Bug #68 (Closed): Ecenter Administration - Deposit Management - SQL Error - Function itself hit exception.

Chooi-Mey

02:39 PM Bug #68 (Feedback): Ecenter Administration - Deposit Management - SQL Error - Function itself hit exception.

now can see page content after fixed the null pointer exception.
however, the SQL error is still there. This is b... chin-yeh

12:17 PM Bug #68 (In Progress): Ecenter Administration - Deposit Management - SQL Error - Function itself hit exception.

chin-yeh

03:49 PM Bug #74: Online Office - Cancel Order - Order No fail search

this issue is similiar to #66 chin-yeh

12:25 PM Bug #65 (Closed): Chart Of Account Administration - GL Control Adminstration - SQL error - function itself hit exception

Function probably not in used anymore. Can be ignored. Chooi-Mey

12:14 PM Bug #65 (Feedback): Chart Of Account Administration - GL Control Adminstration - SQL error - function itself hit exception

Based on the error, the column, CREDIT_CARD_USD does not exists in the GL_CONTROL table. Existing control center also... chin-yeh

11:23 AM Bug #65 (In Progress): Chart Of Account Administration - GL Control Adminstration - SQL error - function itself hit exception

chin-yeh

12:22 PM Bug #67 (Closed): Currency Administration - Country GL Control Approval - SQL error - function itself hit exception.

This function might not in used anymore. Can be ignored. Chooi-Mey

12:16 PM Bug #67 (Feedback): Currency Administration - Country GL Control Approval - SQL error - function itself hit exception.

see issue #65 for the updates chin-yeh

11:49 AM Bug #63 (Closed): Adjustment Management - ISO Order Adjustment - SQL Error. - Function itself already hit error.

Chooi-Mey

11:47 AM Bug #63 (Feedback): Adjustment Management - ISO Order Adjustment - SQL Error. - Function itself already hit error.

chin-yeh wrote:
> Chooi-Mey wrote:
> > The sql query got error on "The data types of the operands for the operation... chin-yeh

11:27 AM Bug #63 (In Progress): Adjustment Management - ISO Order Adjustment - SQL Error. - Function itself already hit error.

Chooi-Mey wrote:
> The sql query got error on "The data types of the operands for the operation ">=" are not compati... chin-yeh

10:54 AM Bug #63: Adjustment Management - ISO Order Adjustment - SQL Error. - Function itself already hit error.

The sql query got error on "The data types of the operands for the operation ">=" are not compatible" for this part :... Chooi-Mey

10:36 AM Bug #63 (Feedback): Adjustment Management - ISO Order Adjustment - SQL Error. - Function itself already hit error.

the trx_order_no value did not enclosed with single quotes in the SQL query. the fixes are already deployed and tested. chin-yeh

11:23 AM Bug #64 (Closed): Order Administration - Order Cancellation Status - View Details - Jsp null point exception

Tested with specified order no. Chooi-Mey

11:12 AM Bug #64 (Feedback): Order Administration - Order Cancellation Status - View Details - Jsp null point exception

most of the old records are already orphaned. query this order No instead, SUF2433456/2433456 chin-yeh

10:33 AM Bug #61 (Closed): Super Selection Order Administration - Order Cancellation History View Details

Tested with specify order no. Chooi-Mey

10:31 AM Bug #62 (Closed): Refund Order Report - SQL Error. - Function itself already hit error.

Not in used function. Can be ignored. Chooi-Mey

09:35 AM Bug #62 (Feedback): Refund Order Report - SQL Error. - Function itself already hit error.

Based on the log entries, the SQL query did not specify the table name. If there's no matching records, the module wo... chin-yeh

01/27/2011

06:26 PM Bug #62 (In Progress): Refund Order Report - SQL Error. - Function itself already hit error.

chin-yeh

04:09 PM Bug #62 (Closed): Refund Order Report - SQL Error. - Function itself already hit error.

SQL Error. - Function itself already hit error.
Log:... chin-yeh

06:25 PM Bug #61 (Feedback): Super Selection Order Administration - Order Cancellation History View Details

try not to query the old records as most of the old records are orphaned. because of that, it could not retrieve the ... chin-yeh

04:07 PM Bug #61 (In Progress): Super Selection Order Administration - Order Cancellation History View Details

Log:... chin-yeh

04:05 PM Bug #61 (Closed): Super Selection Order Administration - Order Cancellation History View Details

SQL error - Funtion itself already hit error.
chin-yeh

05:41 PM Bug #73: Super Selection Order Adminstration - View order detrails - NumberFormatException

This refer to function Super Selection Order Adminstration - Order Enquiry - view details Chooi-Mey

05:32 PM Bug #73 (Closed): Super Selection Order Adminstration - View order detrails - NumberFormatException

... Chooi-Mey

05:39 PM Bug #74 (Closed): Online Office - Cancel Order - Order No fail search

1) (Login with CN857380) Without input order no and search, it hit Select Statement error : For input string: "SUF293... Chooi-Mey

05:01 PM Bug #57 (In Progress): Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

invalid data type fixed. Chee-Hoong

03:50 PM Bug #57: Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

>[nicholas] invalid argument changed from int to string chin-yeh

03:49 PM Bug #57 (Closed): Bo Registration - EasyPayStatusCheck.jsp hit error for the browser response back time

Bo Registration:
============
EasyPayStatusCheck.jsp hit error for the browser response back time.
Log:... chin-yeh

04:27 PM Bug #72 (Closed): BO Administration - Business Status India - Page Error

Page Error. If this function no longer in use, ignore it
Log:... chin-yeh

04:26 PM Bug #71 (Closed): Ecenter Administration - Withdrawal Approval - SQL Error - Function itself hit exception.

SQL Error - Function itself hit exception.
Log:... chin-yeh

04:25 PM Bug #70 (Closed): "Ecenter Administration - Withdrawal - SQL Error - Function itself hit exception

SQL Error - Function itself hit exception
Log:... chin-yeh

04:24 PM Bug #69 (Closed): Ecenter Administration - Deposit Approval Management - SQL Error - Function itself hit exception.

SQL Error - Function itself hit exception.
Log:... chin-yeh

04:21 PM Bug #68 (Closed): Ecenter Administration - Deposit Management - SQL Error - Function itself hit exception.

SQL Error - Function itself hit exception.
Log:... chin-yeh

04:20 PM Bug #67 (Closed): Currency Administration - Country GL Control Approval - SQL error - function itself hit exception.

SQL error - function itself hit exception.
Log:... chin-yeh

04:18 PM Bug #66 (Closed): Online Office - View Order Status

1) (Login with CN857380) Without input order no and search, it hit Select Statement error : For input string: "SUF293... Chooi-Mey

04:18 PM Bug #65 (Closed): Chart Of Account Administration - GL Control Adminstration - SQL error - function itself hit exception

SQL error - function itself hit exception. Check with app team.
Log:... chin-yeh

04:15 PM Bug #64: Order Administration - Order Cancellation Status - View Details - Jsp null point exception

Log:... chin-yeh

04:14 PM Bug #64 (Closed): Order Administration - Order Cancellation Status - View Details - Jsp null point exception

Jsp null point exception - function itself hit exception. Check with app team. chin-yeh

04:11 PM Bug #63 (Closed): Adjustment Management - ISO Order Adjustment - SQL Error. - Function itself already hit error.

Adjustment Management - ISO Order Adjustment
================
SQL Error. - Function itself already hit error.
L... chin-yeh

04:04 PM Bug #60 (Closed): Super Selection Order Administration - Order Cancellation View Details Error Page when click on view the order.

fixed the SQL query and nullpointer bug chin-yeh

04:03 PM Bug #60 (Closed): Super Selection Order Administration - Order Cancellation View Details Error Page when click on view the order.

Error Page when click on view the order.
Log:... chin-yeh

04:02 PM Bug #59 (Closed): Super Selection Order Administration - Order Approval - extra single quote

fixed the SQL query chin-yeh

04:01 PM Bug #59 (Closed): Super Selection Order Administration - Order Approval - extra single quote

Super Selection Order Administration - Order Approval
========================
SQL error - extra single quote
Lo... chin-yeh

03:59 PM Bug #58 (Closed): Super Selection Order Administration - Order Enquiry - SQL error - extra single quote

fixed the sql query chin-yeh

03:58 PM Bug #58 (Closed): Super Selection Order Administration - Order Enquiry - SQL error - extra single quote

SQL error - extra single quote
Log:... chin-yeh

03:55 PM Bug #55 (Closed): Shopper Purchase - order fail insert into transaction table

Tested. Chooi-Mey

03:53 PM Bug #55 (Feedback): Shopper Purchase - order fail insert into transaction table

chin-yeh

03:46 PM Bug #55: Shopper Purchase - order fail insert into transaction table

verify if it's been fixed chin-yeh

03:45 PM Bug #55 (Resolved): Shopper Purchase - order fail insert into transaction table

>[nicholas] insert table error fixed chin-yeh

03:44 PM Bug #55 (Closed): Shopper Purchase - order fail insert into transaction table

- After payment done, order fail insert into transaction table due to the sql error on insert trx_order_no column as ... chin-yeh

03:55 PM Bug #56 (Closed): Merchandise Refund - Error insert transaction table

chin-yeh

03:48 PM Bug #56: Merchandise Refund - Error insert transaction table

fixed chin-yeh

03:47 PM Bug #56 (Closed): Merchandise Refund - Error insert transaction table

Error insert transaction table. 1) Transaction_undefined table name; 2) trx_order_no = 'xxxx ' fail to match due ... chin-yeh

03:55 PM Bug #54 (Closed): Merchandise Return View - Backend server log show SQL error.

tested chin-yeh

03:41 PM Bug #54: Merchandise Return View - Backend server log show SQL error.

>[nicholas] correct the invalid sql parameter at line num 104 chin-yeh

03:40 PM Bug #54 (Closed): Merchandise Return View - Backend server log show SQL error.

Merchandise Return View (Order No: 402410585)
- Backend server log show SQL error.
Log:... chin-yeh

03:54 PM Bug #53 (Closed): shopper_header_l.inc - JSP header include error

reopen if occurs again chin-yeh

03:38 PM Bug #53: shopper_header_l.inc - JSP header include error

Couldn't identify the problem. It could be thrown by other application as the existing file do not contains those codes chin-yeh

03:37 PM Bug #53 (Closed): shopper_header_l.inc - JSP header include error

shopper_header_l.inc:
================
- JSP header include error
Log:... chin-yeh

03:54 PM Bug #52 (Closed): BO Registration - fail go to payment page

tested chin-yeh

03:33 PM Bug #52 (Resolved): BO Registration - fail go to payment page

chin-yeh

03:33 PM Bug #52: BO Registration - fail go to payment page

>[nicholas] correct the method data type
>>[26-01-2011 CM] Tested. Can proceed to payment page. But it hit error for... chin-yeh

03:31 PM Bug #52 (Closed): BO Registration - fail go to payment page

Click on Submit at Payment Summary page, fail go to payment page and hit error "NoSuch Method" and also jsp error shp... chin-yeh