web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Job Queue Service Erro...
Small and medium business | Business Central, N...
Suggested Answer

Job Queue Service Error in Navision 2018

(0) ShareShare
ReportReport
Posted on by joshtechsolutions 4,989

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!

I have the same question (0)
  • Suggested answer
    Rakesh Dobariya Profile Picture
    Rakesh Dobariya 60 on at

    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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 97,376 Super User 2026 Season 1 on at

    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

    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 

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. OussamaSabbouh 2,068 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Dhiren Nagar 1,194 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. YUN ZHU 1,123 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans