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
Back to discussions
Expand all | Collapse all

Error enabling adapter notification

  • 1.  Error enabling adapter notification

    Posted Sat April 27, 2019 04:29 AM

    I’m trying to enable the my update adapter notification and i get the following error:

    [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 of my adapter
    error.PNG


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Error enabling adapter notification

    Posted Mon April 29, 2019 06:17 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


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


Related Content