Insert Adapter Notification Issue

Feedback & ideas
,
1

Hi Friends,
This is first time I am working with Insert notification. By following Jdbc User guide I could create notification service success fully, Schedule it and also enabled it.

I could see the Buffer Table and Trigger is created in WMDB.

→ Now I have started inserting the records through Adapter service and also using Insert command.

Problem: Though I have inserted so many records in to the table, I do not see that new records are being moved in to the Buffer table. Buffer table is always empty and no further action like publishing and so…

I see the log entries as below.

2009-04-30 09:23:38 CAT [ART.0116.3507D] Adapter Runtime (Notification): useConnection Connection:com.wm.adapter.wmjdbc.connection.JDBCConnection@d0fffc for Notification:Acme.adapterServices:terinalConfigNotification UUID:25d67e0034c111dea63ffff22e5ea3bd.
2009-04-30 09:23:38 CAT [ART.0116.3508D] Adapter Runtime (Notification): getConnection Connection:com.wm.adapter.wmjdbc.connection.JDBCConnection@d0fffc for Notification:Acme.adapterServices:terinalConfigNotification UUID:25d67e0034c111dea63ffff22e5ea3bd.
2009-04-30 09:23:38 CAT [ART.0116.3504D] Adapter Runtime (Notification): Execution finish for Notification:Acme.adapterServices:terinalConfigNotification UUID:25d67e0034c111dea63ffff22e5ea3bd.
2009-04-30 09:23:38 CAT [ART.0116.3507D] Adapter Runtime (Notification): useConnection Connection:null for Notification:Acme.adapterServices:terinalConfigNotification UUID:25d67e0034c111dea63ffff22e5ea3bd.
2009-04-30 09:24:38 CAT [ART.0116.3502D] Adapter Runtime (Notification): Execution begin for Notification:Acme.adapterServices:terinalConfigNotification UUID:25d67e0034c111dea63ffff22e5ea3bd.

Even I have created a dedicated Connection to notification service…didn’t help.

Please suggest me if I am missing any step or any action…

Thanks in Advance

2

Perhaps there is a typo/error in the DB trigger? Verify that the DB trigger is working correctly using DB tools.

3

Hi Rob,
Thanks for your reply.

I can see the trigger description as follows:

CREATE TRIGGER WMTTConfigbe5tdzs ON TPT_TERMINALCONFIG for insert as begin INSERT INTO dbo.WMBTConfigbe5tdzs (SENDERID, RECEIVERID, TERMINALCONTACT, FROM_EMAILID, TO_GROUPEMAILID, CC_GROUPEMAILID) SELECT inserted.SENDERID, inserted.RECEIVERID, inserted.
TERMINALCONTACT, inserted.FROM_EMAILID, inserted.TO_GROUPEMAILID, inserted.CC_GROUPEMAILID FROM inserted, deleted end

I got this by the command sp_helptext WMTTConfigbe5tdzs

I am not good in SQL, but if you see the trigger description at the end inserted, deleted end. Here I don’t under stand why it has writer deleted?

Would you think something wrong with the WM generated trigger?
If yes then I think it is problem with JDBC Adapter?

I am working on JDBC Adapter 6.5, please suggest me if I need to apply any fix.

Thanks
Ramana