Project

General

Profile

Actions

Bug #61

closed

Super Selection Order Administration - Order Cancellation History View Details

Added by chin-yeh almost 14 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
eCosway mall - control center
Target version:
Start date:
01/25/2011
Due date:
01/28/2011
% Done:

100%

Estimated time:
Resolution:
Wont fix

Description

SQL error - Funtion itself already hit error.

Actions #1

Updated by chin-yeh almost 14 years ago

  • Status changed from New to In Progress

Log:

11:51:49,469 INFO  [STDOUT] DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: addr;WHERE SHRFNBR =  AND;OR
11:51:49,470 ERROR [STDERR] wpwong: HumanResource.java: 25-01-2011 11:51:49: getShopperInfo: get permanent address error! sql= SELECT SHRFNBR, SHLOGID, SHSHTYP, SHOPPER_GRP, addr.SANICK SHOPPER_NAME, SHOPPER_IC, SHLVSTMP, SHLOSTMP,  SHRSTMP, SHCSTMP, SHLUSTMP, SHPREFERREDCURR, USER_GRP, USER_LEVEL, NEW_IND, BONUS_PAY_METHOD, ORDER_LIMIT,  a.STATUS, LOGIN_ATTEMPT, EDO_IND, PAY_BY_CHEQUE, BROADCAST_IND, BL_ECOSWAY_ID  FROM SHOPPER a LEFT JOIN BLACKLIST_MEM b ON SHLOGID=BL_ECOSWAY_ID, SHADDR addr  WHERE SHRFNBR =  AND addr.SASHNBR = SHRFNBR  AND SAADRFLG='P' AND SHSHTYP in ('R','S')  AND a.STATUS in ('A','P','S','T','L')
11:51:49,470 ERROR [STDERR] ,errSystem=CWC: executeQuery(A database manager error occurred.)
11:51:49,470 ERROR [STDERR]  : Exception in Obtaining User right=0 >= 0

Actions #2

Updated by chin-yeh almost 14 years ago

  • Start date changed from 01/27/2011 to 01/25/2011
Actions #3

Updated by chin-yeh almost 14 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from chin-yeh to Chooi-Mey
  • % Done changed from 0 to 100
  • Resolution set to Wont fix

try not to query the old records as most of the old records are orphaned. because of that, it could not retrieve the relevant data from its linking data.

use this order number, SUF402485682 instead.

Actions #4

Updated by Chooi-Mey almost 14 years ago

  • Status changed from Feedback to Closed

Tested with specify order no.

Actions

Also available in: Atom PDF