Disable Event Subscribers

jordi79jordi79 Member Posts: 277
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

  • HatchetHarryHatchetHarry Member Posts: 24
    you can turn off the events in the "Events subscription" Page.
  • jordi79jordi79 Member Posts: 277
    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.
  • jordi79jordi79 Member Posts: 277
    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.
Sign In or Register to comment.