Event Subscription running 2 times

fazlehasan

This issue happened for a Dynamics NAV 2017 database in SQL Server 2017

There are couple of Event Subscriptions used in this database. One of the function is, on some NAV events some notifications / emails went out.

Users complained that notification emails did not went out.

Opened the Event Subscriptions page, found to my surprise that it was EMPTY!

Didn't know what to do to bring them back? so I just compiled a codeunit which has some event Subscriber functions.

Then I observed that the Event Subscription page showing subscriptions again.

But afterwards Users started experiencing that all the events are called TWICE!

I randomly compiled a table to see what happens, thinking that it can be a Synchronizing issue between NAV and SQL.

And then everything was good again.

I have no clue what happened, never seen this kind of issue.

Any explanation?

Thanks. .

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]