Register or Login to Your Account
Hi, Error while testing select Adapter service in JDBC Adapters.. com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Testing.adapters:getTestData. [ADA.1.316] Cannot execute the SQL statement "SELECT t1.POWER_UNIT_GID,t1.POWER_UNIT_XID,t1.DESCRIPTION,t1.POWER_UNIT_NUM,t1.DATE_BUILT,t1.DOMICILE_COUNTRY_CODE_GID,t1.CORPORATION_GID,t1.PARK_LOCATION_GID,t1.POWER_UNIT_TYPE_GID,t1.TARE_WEIGHT,t1.TARE_WEIGHT_UOM_CODE,t1.TARE_WEIGHT_BASE,t1.IS_ACTIVE,t1.SIGHTING_LOCATION_GID,t1.SIGHTING_DATE,t1.PREV_SIGHTING_LOCATION_GID,t1.PREV_SIGHTING_DATE,t1.USER_DEFINED1_ICON_GID,t1.USER_DEFINED2_ICON_GID,t1.USER_DEFINED3_ICON_GID,t1.USER_DEFINED4_ICON_GID,t1.USER_DEFINED5_ICON_GID,t1.INDICATOR,t1.DOMAIN_NAME,t1.INSERT_USER,t1.INSERT_DATE,t1.UPDATE_USER,t1.UPDATE_DATE FROM GLOGOWNER.POWER_UNIT t1 WHERE (t1.IS_ACTIVE = Y) ". " (42000/904) ORA-00904: "Y": invalid identifier Any clues, what this error and how i can resolve it
My issue got resolved, i was trying with t1.IS_ACTIVE = Y. When i tried with single quotes, it worked fine. t1.IS_ACTIVE = 'Y'
Neelima
Hi,
Error while testing select Adapter service in JDBC Adapters..
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Testing.adapters:getTestData.
[ADA.1.316] Cannot execute the SQL statement "SELECT t1.POWER_UNIT_GID,t1.POWER_UNIT_XID,t1.DESCRIPTION,t1.POWER_UNIT_NUM,t1.DATE_BUILT,t1.DOMICILE_COUNTRY_CODE_GID,t1.CORPORATION_GID,t1.PARK_LOCATION_GID,t1.POWER_UNIT_TYPE_GID,t1.TARE_WEIGHT,t1.TARE_WEIGHT_UOM_CODE,t1.TARE_WEIGHT_BASE,t1.IS_ACTIVE,t1.SIGHTING_LOCATION_GID,t1.SIGHTING_DATE,t1.PREV_SIGHTING_LOCATION_GID,t1.PREV_SIGHTING_DATE,t1.USER_DEFINED1_ICON_GID,t1.USER_DEFINED2_ICON_GID,t1.USER_DEFINED3_ICON_GID,t1.USER_DEFINED4_ICON_GID,t1.USER_DEFINED5_ICON_GID,t1.INDICATOR,t1.DOMAIN_NAME,t1.INSERT_USER,t1.INSERT_DATE,t1.UPDATE_USER,t1.UPDATE_DATE FROM GLOGOWNER.POWER_UNIT t1 WHERE (t1.IS_ACTIVE = Y) ". "
(42000/904) ORA-00904: "Y": invalid identifier
Any clues, what this error and how i can resolve it
Neelima
My issue got resolved, i was trying with t1.IS_ACTIVE = Y.
When i tried with single quotes, it worked fine.
t1.IS_ACTIVE = 'Y'