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.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Adapter Polling Notification Error

  • 1.  Adapter Polling Notification Error

    Posted Tue September 27, 2011 09:58 AM

    Following error was encountered while enabling the adapter polling notification:

    [ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification Training.dbEntry:insertNotification.
    [ADA.1.114] The database objects for “Training.dbEntry:insertNotification” notification already exist. You can delete the objects and try enabling the notification again. To delete the existing database objects use the “pub.pollingNotificationUtils:dropDatabaseObjects” service.


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


  • 2.  RE: Adapter Polling Notification Error

    Posted Tue September 27, 2011 10:03 AM

    when i run the service “pub.pollingNotificationUtils:dropDatabaseObjects” and provide the notification as input and then try to enable the polling notification, following error was generated:

    [ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification Balaji.dbEntry:insertNotification.
    [ADA.1.316] Cannot execute the SQL statement "CREATE TRIGGER WMTnotifybhidb32 AFTER INSERT ON BALAJI.employeeDetails FOR EACH ROW BEGIN INSERT INTO WMBnotifybhidb32 (Name, EmpNo, Designation, JoinedOn, ReportingTo, PreviousEmployer, wm_rowid) VALUES (:new.Name, :new.EmpNo, :new.Designation, :new.JoinedOn, :new.ReportingTo, :new.PreviousEmployer, WMSnotifybhidb32.NEXTVAL); END;
    ". "
    (42000/942) ORA-00942: table or view does not exist
    "
    ORA-00942: table or view does not exist


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


  • 3.  RE: Adapter Polling Notification Error

    Posted Tue September 27, 2011 12:55 PM

    Check help on Oracle DB error: ORA-00942
    You can also check what user privileges your WM user has in ORACLE DB. I think this resolved my similar problem in the past.


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