Added by chin-yeh almost 14 years ago. Updated almost 14 years ago.
100%
Description
SQL error - Funtion itself already hit error.
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
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.
Tested with specify order no.