Lost SQL Server connection while compiling all objects

navuser1
navuser1 Member Posts: 1,334
in NAV Three Tier
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.
Now or Never

Answers

  • navuser1
    navuser1 Member Posts: 1,334
    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
    Now or Never
  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    Check this out

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

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/

Categories