Lost SQL Server connection while compiling all objects

navuser1

Dear Sir,

I am going thru a upgradation process from NAV 16 CU26 to NAV 16 CU32. During this process the following error message I have received while trying to compile All Objects in CU32 platform.

---

Microsoft Dynamics NAV Development Environment

---

Your connection to the SQL server is no longer responding. This can be caused by one of the following reasons:
* The server has been shut down manually or because of an error.
* Your session was stopped by an administrator.
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.
Try again later or contact your system administrator.

---

OK

---

What is the actual reason behind this issue ? System allows if I compile Object (type) by Object.

Kindly reply.

navuser1

Event Log......

Server instance: NAV2016

Tenant ID: default

Session type: UnknownClient

Session ID: 2938

User: XYX\Administrator

Type: System.Data.SqlClient.SqlException

ClientConnectionId: e1b49bd7-27e7-4bb2-930d-4d39605f3b42

Class: 20

LineNumber: 0

Number: -1

Server: NAVBACKUP

State: 0

Source: .Net SqlClient Data Provider

ErrorCode: -2146232060

Message: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

StackTrace:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()

at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()

at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()

at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass12`1.<ExecuteFunction>b__11()

HResult: -2146232060

RockWithNAV

Check this out

https://community.dynamics.com/nav/f/34/p/289895/831607#831607