Polling Notification issue with tables not there

, ,
1

I’m trying to enable a couple of polling notifications, but when I do it says it can’t create the table because it already exists. However, the tables were deleted from the db, and do not show up. The JDBC adapter is thinking there are, and therefor the error. Any ideas how to correct this situation?

[ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification LoadTendering.EDIServices.EDI204.jdbc.notifications:insert204Notification.
[ADA.1.316] Cannot execute the SQL statement “CREATE TRIGGER WMTinsert204bauaudi ON dbo.tblEDITransactions for insert as begin INSERT INTO SAPBC_user.WMBinsert204bauaudi (EDITransactionID) SELECT inserted.EDITransactionID FROM inserted end”. "
(42S01/2714) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]There is already an object named ‘WMTinsert204bauaudi’ in the database."
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]There is already an object named ‘WMTinsert204bauaudi’ in the database.

2

Hey,
We are also getting the same error.
Pls let me know if you know the solution.

Thanks,
Sreedhar Pedakanti

3

Sreedhar,

Here’s what I found (or what our resident expert with WM told me about). The triggers that it’s trying to create still existed on the table it’s trying to create a trigger for. In my case, tblEDITransactions table. I went into Enterprise Manager, did a manage trigger on that table. There they were. I deleted the triggers for that table.

I then was able to enable the notifications. Seems to simple, but like lots of other things, you just need to discover that the first time. Hope this helps.

Ron