October 16, 2014
ArcherPoint Microsoft Dynamics NAV Developer Digest - vol 22
The ArcherPoint technical staff—made up of developers, project managers, and consultants – is constantly communicating internally, with the goal of sharing helpful information with one another. As they run into issues and questions, find the answers, and make new discoveries, they post them companywide on Yammer for everyone’s benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this group—so we thought, wouldn’t it be great to share them with the rest of the Microsoft Dynamics NAV Community? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from the ArcherPoint staff. We hope these insights will benefit you, too. Problem with NAV printing to a PDF printer: Question: Has anyone encountered this before? I know that this might not necessarily be a NAV issue, but the issue only occurs in NAV. We have an Adobe PDF printer on our terminal servers. Periodically, users will get a NAV error, “You have selected the wrong instance of this printer.” This issue is not easily reproducible, but when it occurs, it really holds thing up. They only thing that seems to fix it is selecting and reselecting the printer before NAV finally allows it to print to PDF. I have done a little Googling on this issue and it seems to only happen on terminal servers. Reply: "instance" of a printer sounds like it could be a driver issue between two installs, such as NAV and Citrix. Users receive SMTP errors: Question: Users are trying to setup Document approvals and are getting SMTP errors. Does anyone know what could be wrong? Answer: They need to contact their email administrator - either internal IT, or external if their email is hosted someplace other than their own server. Either a recent change has been made to the SMTP server (if this was working in the past), or this is a new user that has not been set up on their SMTP server. Questions to ask them - is it just one user, or everyone? When did this stop working? This is not something that can be fixed from NAV. Problem with excessive growth of the Session Event table: Problem: Need some help from anybody familiar with the Session Event table 2000000111 in NAV 2013. I discovered a problem where a web services user is recording 2-3 logon/logoff events per second and the table has grown from zero to over four million records just a few days. They are simultaneously experiencing very high CPU utilization on the SQL server and I suspect it's related, but don't really know. The external web portal is logging on and logging off 2-3 times per second through web services. I have found the setting on the NST config that will purge this table of older records, it's called Session Event Table Retain Period. Suggested solutions: I'm having a similar issue at a client site and suspect the growth is due to a third-party add-on. The parameter in CustomSettings.config has not had any effect. There is code on the OnDelete trigger of this table in SQL ... this must be bypassed in order to delete records without generating new ones. Another possibility: Would web service calls be a possible culprit? I wouldn't think normal RTC connections would make the table grow much, but if each and every web service call is logged, that might do it. Is the Session Timeout property is set properly? Maybe the session timeout is a good thing to try since that should clean up the old entries. Be sure to read more ArcherPoint developer blogs. If you have any further questions about customizing in NAV, please feel free to contact any of the NAV experts at ArcherPoint.
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- How to Make Measures Total Correctly in Power BI Tables
- The Microsoft Technology Stack – What It Is and Why You Should Care
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard