Error enabling adapter notification

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

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

Hi Holger,

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

Regards
Stanley