Disable Event Subscribers

jordi79
jordi79 Member Posts: 280
edited 2019-02-25 in NAV Three Tier
Hi,

We are using NAV2017. We are facing some performance issues which is traced to Workflow subscriber events. Is there a way to disable Event Subscribers apart from making modifications directly into the Event Subscriber codeunit?

Jordi

Comments

  • HatchetHarry
    HatchetHarry Member Posts: 24
    you can turn off the events in the "Events subscription" Page.
  • jordi79
    jordi79 Member Posts: 280
    HatchetHarry wrote: »
    you can turn off the events in the "Events subscription" Page.

    The page is non editable, and the table this page refers to is a virtual table. There is no way to turn it off on this page. At least in NAV2017 this is not possible.
  • jordi79
    jordi79 Member Posts: 280
    BlackTiger wrote: »
    Ability to disable/enable events on-the-fly will create a TOTAL MESS in NAV data.

    I understand. I am not turning off events, but I am disabling the subscriptions to these events. As some of these subscriptions to these evetns are causing performance issues. E.g. in workflow, when a GenJnlLine is deleted, it performs a check on a table. Imagine, if 50,000 lines are posted in GenJnlLine, this check is done 50,000 times. And not to mention, if there is a subscription, (I think...) it also disables the SQL bulk delete feature, and delete is sent to SQL sequentially 50,000 times.

Categories