Project

General

Profile

Actions
Copy link

Bug #61

closed

Super Selection Order Administration - Order Cancellation History View Details

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

Status:
Closed
Priority:
Normal
Assignee:
Chooi-Mey
Category:
eCosway mall - control center
Target version:
1.0
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
Copy link
 #1

Updated by chin-yeh over 13 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
Copy link
 #2

Updated by chin-yeh over 13 years ago

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

Updated by chin-yeh over 13 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
Copy link
 #4

Updated by Chooi-Mey over 13 years ago

  • Status changed from Feedback to Closed

Tested with specify order no.

Actions
Copy link

Also available in: Atom PDF