Message: |
com.microsoft.sqlserver.jdbc.SQLServerException:
ContextInfo: Error Getting Available Product Categories from Database.
Partial SQL statement= SELECT DISTINCT AC.CATEGORY_ID, AC.DISPLAY_NAME, AC.IMAGE_ON_URL, AC.IMAGE_OFF_URL, AC.IMAGE_URL , AC.TM_ORDER_NUMBER AS CTGRY_ORD_NUM FROM TBL_AVAILABLE_CATEGORY AC, TBL_USER_AVAILABLE_CATEGORY UAC, TBL_TM TM WITH (READUNCOMMITTED) WHERE AC.CATEGORY_ID = UAC.CATEGORY_ID AND AC.TM_ID = UAC.TM_ID AND AC.TM_ID = TM.TM_ID AND AC.STAT = 0 AND UAC.USER_TYPE = 'STANDARD' AND TM.LOCALE_ID = 'en_us' AND TM.SBU_ID = 'FE' AND TM.TM_ID = 91 AND (AC.UNPUBL_FLG = 0 OR AC.UNPUBL_FLG IS NULL) ORDER BY CTGRY_ORD_NUM SQLState: S0001 Vendor Code: 207
|