I have faced this error testing some updates I’m preparing for the automatic merging tool I did and Dynamics NAV came up with this error when I was trying to upload a 120MB file. Too large for NAV apparently.
In my case I was using NAV2013R2 at the time.
Up to NAV2009 we had at our disposal the option of closing sessions from the same form we could see the sessions on. But unfortunately this option disappeared in NAV2013.
The page where we can see the same info is now the debugger, and does not have a “Kill session” option we are looking for.
What can we do in this version then?
A new function was introduced called “STOPSESSION”. It enables us to do the same thing we could do before.
So yeah. The Microsoft NAV Team has finally confirmed the compatibility of SQL Server 2014 with:
- Microsoft Dynamics NAV 2013 R2
- Microsoft Dynamics NAV 2013
- Microsoft Dynamics NAV 2009 R2
They have also announced that the only compatible products are SQL Standard Edition and the SQL Enterprise Edition.
For more information regarding the product you can check out this link.
At this point I think it is known to all of us that the users have a tendency to leave Microsoft Dynamics NAV open even if they are not in need of using it. This might be due to a distraction and they start doing something else, or just because it’s coffee time
But the licenses have the user number very well defined and not all the companies can afford to have more sessions open than needed. This is specially true when external applications interact with the ERP in order for the system to run the company business logic.
But what can we do?