Have you ever had a situation where you need to restart your NAV Server in a three-tier setup in order to get it to pick up new FOBs after importing? In this blog post, I’ll look at some of the reasons why this can occur and give you some techniques for fixing it. No login for dbo alias The other day...
I came across something that was a bit weird in an implementation where every user in a Citrix deployed RoleTailored client suddenly connected to the TEST system instead of the LIVE system. I thought I’d share this gotcha to save others from making the same mistake. When you start Dynamics NAV 2009’s...
I came across an error today that was a monstrous nightmare to track down. First of all, it worked in the Classic client but not in the RoleTailored client. Sigh. Don’t you just hate that? It means going through the pain of debugging the RoleTailored client. The error was caused because the FieldRef...
If God had wanted me to work, he wouldn’t have given me Angry Birds. I figured it was about time I wrote something about Dynamics NAV again, so setting my continuing mission to get three stars on all levels to one side, I’ve finally taken time to pass on a couple of tips around .NET Interop and...
Have you ever tried to create a NAV 2009 Server service that runs under a domain account and when you try to start it, the service starts and them immediately stops again. Then, if you look in the Windows Event Log for the error message you see something like this… The service MicrosoftDynamicsNavServer...
I recently tried using UPLOADINTOSTREAM to load a file from the RoleTailored client into a temporary file on the NAV Server so that I could then process it. This is needed in NAV 2009 because it has three tiers and the tier on which the code executes does not necessarily have access to the files that...
In the RoleTailored client on a Page, the xRec does not contain a record when you are inserting new records into a sub page. Previously if you wanted to know where you had pressed F3 to insert a line you could take a look at xRec and would know which line you were on when you pressed F3. Unfortunately...
NAV Supports various data types for parameters to functions, one of which is an Option. An option data type is stored internally as a number but will appear on screen, in reports as text. In other systems this is referred to as an enumerated type. Option type fields make it easy to write self-explanatory...
In my last Web service gotcha post , I wrote about how a User Personalisation record is needed to ensure dates are handled correctly when executing Web services. Today I discovered that if you fill in the Company field on the user personalisation, you get a whole new set of problems. My process was executing...
If you are planning on using the new NAV 2009 Web services capabilities as a means of running scheduled tasks, you must ensure that the Windows user account that is to be used to execute the task has a User Personalisation record with the correct Language ID. 5129 is the English (New Zealand) language...