This NAV 2013 error may result if the user is attempting to connect to a NAV database using the Developer Client and the SQL permission dbowner has not been granted for the user at the database level. This resource reports the SQL permission dbowner is required in order for a user to manage NAV… Continue reading TableData 2000000001 does not exist.
Category: Dynamics NAV
6 More Reasons You Should Consider Upgrading NAV
The Hidden Costs of NOT Upgrading NAV Obsolete Technology It gets harder and harder to bridge the gap between old technology and new technology the further upgrading is put off.Microsoft and Add-On Software vendors create upgrade tools that support upgrading from the current version to the new version. This is called an “Upgrade Path”. Sometimes,… Continue reading 6 More Reasons You Should Consider Upgrading NAV
Open Questions on Configuring the NAS on NAV 2009 RTC and NAV 2013
Yesterday I wrote an article about the importance of setting the MetadataProviderCacheSize on the Microsoft Dynamics NAV Server (NAS) or Service Tier to something much great than the default of 150 http://www.archerpoint.com/blog/Posts/performance-tuning-microsoft-dynamics-nav-2009-and-nav-2013. If you read my article, you know that I am recommending a value of 5,000. However, there are several additional properties, which can bet set on… Continue reading Open Questions on Configuring the NAS on NAV 2009 RTC and NAV 2013
Performance Tuning Microsoft Dynamics NAV 2009 and NAV 2013
We recently discovered that a single property on the Service Tier for Microsoft Dynamics NAV 2009 RTC and Microsoft Dynamics NAV 2013 has a bigger impact on performance than almost anything else we have done to date in performance tuning Microsoft Dynamics NAV in a 3-Tier environment. The setting that every client and partner should… Continue reading Performance Tuning Microsoft Dynamics NAV 2009 and NAV 2013
NAV Web Services – Pages vs. XMLports
There are two major methods for publishing complex NAV functionality as a web service: publishing a Page object, and publishing a Codeunit object with a function that uses an XMLport as a parameter. Which one should you use? Like Obi-Wan Kenobi and Captain America here, Pages and XMLports are both awesome, but they should be… Continue reading NAV Web Services – Pages vs. XMLports
NAV 2013 Report Designer – Pandora’s Box?
Having tried reading documentation on RTC reporting in NAV 2013, I would liken it to trying to find meaning in Gertrude Stein’s poem “Roast Beef”. I quickly gave up on the documentation, and tried another approach. I just dived in, head first! “So, how different can RTC reporting in NAV 2009 and NAV 2013 be? … Continue reading NAV 2013 Report Designer – Pandora’s Box?