Topic:   com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service...
Apr 17, 2013 16:39 2 Replies 4618 Views Neelima
Prev Next
Topic Replies (2)
  1. 1
    idnkx user

    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

    1
    idnkx user

    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'

Leave a Reply
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect