You’re offline. This is a read only version of the page.
6,562
Hey Friends,
Though it's not recommended but now we need to change a global dimension in between of the Project which has around entries in lacks. As per the standard process I navigated to General Ledger Setup -> Action -> Change Global Dimension. After around 1 hr of execution I am getting this error
A connection to SQL server is no longer usable.
This could be caused by one of the following reasons:
* The server has been shut down manually or because of an error.
* The SQL server connection settings are not correct.
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.
I did every possible way to sort it out like -
1. Adding Port in Firewall Exception
2. Increasing SQL Command timeout.
3.Giving db_datareader, db_datawriter, db_ddladmin to the service account and NT Authority\Network Service account with default schema as $ndo$navlistener.
4.Restarting NAV And SQL Services.
I too stopped all those SQL Jobs going behind and I was the single user doing this Operation still every time I landed up with the same Issue.
I too went through msdn.microsoft.com/.../dn951484(v=nav.90).aspx where Event ID 216 and 112 was the case which was logging up into Event Viewer and did whatever was recommended but still on the same place.
Always Thanks to MICROSOFT COMMUNITY.
*This post is locked for comments
Finally I managed to solve this Issue. This was all about the Inconsistency in Data which was totally Clueless.
On the Server.
Where are you running this process on your machine or on the server ?
Hi Anmol,
Yes and thats why I increased the SQl Command Timeout to a very huge value but still facing this.
You try to run this on Server itself and it may be the service is getting restarted due to timeout or long process
NAV Server and SQL Server both are on the same Machine.
I mean did you execute that function by logging onto NAV Server or SQL server by opening Navision from those servers.
Hi Suresh,
Thanks for your comment. As I mentioned I executed this from
General Ledger Setup -> Action -> Change Global Dimension.
Have you tried running the process from NAV Server or SQL Server ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (