Adapter Polling Notification Error

, ,
1

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.

2

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

3

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.