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'