IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  Error enabling adapter notification

    Posted Sat April 27, 2019 04:29 AM

    I’m getting the following error when i try to enable my update adapter notification:

    [ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification DPW_SAGE.adapters.DBNotification:sagePaymentUpdate.
    [ADA.1.349] Execution of DDL query of Notification failed during enable/disable. Please check the datatypes of columns selected in notification.
    Column name ‘WM_ROWID’ does not exist in the target table or view.

    attached is the screen shot for the adapter
    error.PNG


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Error enabling adapter notification

    Posted Mon April 29, 2019 06:15 AM

    Hi,

    which type of database are you using?

    Are there any BLOB- or CLOB-Columns selected in the notification?
    If so remove these from the notification.
    You can then use a simple select statement to read them while processing the notified document by using a unique column being present in the notification.

    Regards,
    Holger


    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: Error enabling adapter notification

    Posted Tue April 30, 2019 04:13 AM

    Hi Holger,

    We are using SQL database, and all the columns i selected are nvarchar. no blob or clob on the table.

    Regards
    Stanley


    #Integration-Server-and-ESB
    #webMethods


Related Content