Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Job Queue Service Error in Navision 2018

Posted on by 4,230

Hi Community,

My company has been running Currencies Exchange Rates via Job Queue Entries for many years now. We used API to pull the rates from our local Central Bank API address. One thing in particular that I don't understand is how come at random weekends, the currency rate job queue will show status as "Error" for some companies and not all (We have around 20 over companies in NAV residing on the same server and DB, and only 4 companies' Currency Rates were down, sometimes it can be 12 companies randomly). I have checked with my IT admin, that there was no restarting of server being done.

pastedimage1655686262743v1.png

May I ask is there anywhere in SQL server or Navision that I can trace the root cause of this error?

When Microsoft push server updates, will this affect Navision in anyway?

Looking forward to your replies!

Thank you!

  • Suggested answer
    Rakesh Dobariya Profile Picture
    Rakesh Dobariya 60 on at
    RE: Job Queue Service Error in Navision 2018

    Hello ZHU,

    Provided information is supportive , hence joshtechsolutions has asked solution that how they able to keep eye on important Job queue, at least concern person supposed to know that Job Queue has been stopped or run successfully ,

    Later on stage with NAS setting they able to set  on "automatically" if in case server get restarted due to any unforeseen event like power failure or vital patch/ update for windows,

    Realtime its happed with me, It has often electricity issue at one of our client site, mostly at night thus few services get stopped and i have to start it again manually , secondly job queue also has to restart,  had resolved through NAS configuration. 

    Refer below content for reference,

    Configuring NAS Services Settings

    You can configure NAS services by using the settings in Microsoft Dynamics NAV Server Administration tool. In a multitenent Microsoft Dynamics NAV Server instance deployment, some NAS services settings, such as enabling NAS services and running NAS services with admin rights, are specified when you mount the tenant on the Microsoft Dynamics NAV Server instance.    

    I think debugging for multiple company Job Queue is might helpful but prevention or avoidance is much more helpful in this case.

    Moreover zhu  your input is valuable.

    Regards,

    Rakesh Dobariya 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,933 Super User 2024 Season 2 on at
    RE: Job Queue Service Error in Navision 2018

    Hi, just adding to Rakesh's reply, I'm not sure if this works in NAV2018, for BC On-Premise version, the job queue can be debugged with the following method.

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-json-files

    pastedimage1655768381485v2.png

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-attach-debug-next#attach-configuration

    pastedimage1655768270742v1.png

    Aonther info:

    https://dynamics.is/?p=2471

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Rakesh Dobariya Profile Picture
    Rakesh Dobariya 60 on at
    RE: Job Queue Service Error in Navision 2018

    Hello,

    I have faced the same issue with one of our client, we have found that due to  Microsoft push server updates, few updates required to restart depended and independent services as a part of version upgrade/ Patches installation in your case,

    Solution is as per below,

    Solution 1 :

    Customization in NAV : Auto email or notification supposed to be triggered in case of Job queue status get changes

    Solution 2 :

    If you using Power BI you can add set auto email trigger based on below two tables,

    1. )  "Job Queue Category" (table No.471) and

    2. )  "Job Queue Entry" (table No.472)

    Moreover this service is based on "NAS" configuration,

    ----------------------------------------------

    On the General tab, the Services Default Company specifies the default company that is used by NAS Services and also other types of client connections.

    NAS services sessions execute in the time zone specified by the ServicesDefaultTimeZone parameter for Microsoft Dynamics NAV Server. See.

    For more information about these settings, see General Tab Settings.

    =========================

    For more information refer below link,

    ==========================

    navhelp90.fenwickcloud.com.au/main.aspx

    Regards,

    Rakesh Dobariya

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans