Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV09 R2 Client very s...
Microsoft Dynamics NAV (Archived)

NAV09 R2 Client very slow loading

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi, Nav2009 R2 + LS Retail 6.4, client takes too much time to load. If network is disabled it loads normally and fast. No polices running on domain. Anyone can advice?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV09 R2 Client very slow loading

    If you are running window authentication for user more that 50 then it will take time.For verify this thing you can check Windows Login table open it if it takes time then you need to delete user's and make database user's.

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: NAV09 R2 Client very slow loading

    Hi,

    Just try these points as well... & keep your finger crossed... :|

    1. Another thing you may want to check is the "Metadata Provider Cache Size" on the Service Tier. It defaults to 150 meaning that it will only cache 150 objects. Setting it to something like 500 or 1000 may improve performance for you.

    2. If you have an antivirus, don't let it check the SQL files (.MDF,.NDF,.LDF,.LOG,.TRN,.BAK)

    3. Disable Named Pipes in SQL server and use Sockets and not default as Nettype in NAV server.

    4. Turn off firewalls on sql and nav-servers.

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV09 R2 Client very slow loading

    Try to enter your Proxy data unter Windows Internet Settings and check if the automatic detection is disabled,

    MS does online license checks during the client start. If your Firewall blocks, you have to add crl.microsoft.com in your whitelist.

    This helped here. Before 20s - now 3s to start the RTC or Classic-SQL.

  • Syed Aley Mehdi Profile Picture
    Syed Aley Mehdi 60 on at
    RE: NAV09 R2 Client very slow loading

    Hey Kareem,

    I could be because of the Transaction Server is enabled. Transaction Server Requires network. It is sending data to the server on real time basis, even the Logoff and Logon Transactions while Login or Logoff in the POS.

    Regards,

    Syed Aley Mehdi

  • mandyk Profile Picture
    mandyk 5 on at
    RE: NAV09 R2 Client very slow loading

    Hi, try Disable the check for publisher certificate revocation and disable for server certificate revocation.

    These option can be found in internet option --> advanced tab under security section. need to scroll downs little bit. 

    Main reason, if those option are enable (default is checked), the OS tries to check revocation certificate for the apps (i.e. nav client/NAS/RTC client) over the internet. When the access to internet is blocked by firewall then, it takes a while to times up and continue to load the apps. Do remember this option is not computer scope level, but account/login level. Thus if there are two user with two different window login, then each of them need to do the same things.

    I have been experiencing this, for NAV classic, NAS service, BizTalk adminstrator, SQL management studio.

    As susggestion, you can try to use MS process monitor tools to find out the accessing URL and so fort. 

    Hopefully can help.

    Rgs,

    Andy K.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV09 R2 Client very slow loading

    Here are the steps to solve the problem:

    1. Run the process monitor.
    2. Select the option to "Show Network Activity" and remove the selection for other options
    3. Filter the process name "navsql.exe" and the operation "TCP Reconnect"
    4. Run Navsql, then check the process monitor.
    5. If you find that navsql is trying to connect certain IP on http/8080, you need to block this connection, in my case, I created a new windows firewall rule to block all packets from finsql.exe from any IP to any IP, from any port to port 80,8080.
    6. Voila, navsql now opens within seconds, and now if you check the process monitor you will find the operation is "TCP disconnect" instead of "TCP Reconnect".
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV09 R2 Client very slow loading

    Here are the steps to solve the problem,:

    1. Run the process monitor.
    2. Select the option to "Show Network Activity" and remove the selection for other options
    3. Filter the process name "navsql.exe" and the operation "TCP Reconnect"
    4. Run Navsql, then check the process monitor.
    5. If you find that navsql is trying to connect certain IP on http or port 8080, you need to block this connection, in my case, I created a new windows firewall rule to block all packets from finsql.exe from any IP to any IP, from any port to port 80,8080.
    6. Voila, navsql now opens within seconds, and now if you check the process monitor you will find the operation is "TCP disconnect" instead of "TCP Reconnect"
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV09 R2 Client very slow loading

    Hi Youssef, can you plz elaborate more on the steps followed resolving the issue?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV09 R2 Client very slow loading

    Happy to help. In general, it's very strange behavior of standalone application. It would be interesting to know why requests happen.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV09 R2 Client very slow loading

    Finally it's solved, I ended up blocking a specific range of ports with the http on the fin.exe and finsql.exe. Thanks Numpine and Sandeep.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans