Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Lost SQL Server connection while compiling all objects

(0) ShareShare
ReportReport
Posted on by 1,112

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.

*This post is locked for comments

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Lost SQL Server connection while compiling all objects

    As I already said that this a complete migration process (NAV16 CU26 to NAV16 CU32). The old database (CU26) was stored in C Drive & we have changed the location (D Drive) & convert it into CU32.

    This will have no Effect.

    SQLServer & NAVServer were installed in a same machine previously in CU26 Case.  Now we have two different Server for CU32. One is for SQL & another is for NAVServer.

    This may be cause for any of the X reason.

  • subrata.bauri Profile Picture
    subrata.bauri 1,112 on at
    RE: Lost SQL Server connection while compiling all objects

    I want to add more in this post.

    As I already said that this a complete migration process (NAV16 CU26 to NAV16 CU32). The old database (CU26) was stored in C Drive & we have changed the location (D Drive) & convert it into CU32.

    SQLServer & NAVServer were installed in a same machine previously in CU26 Case.  Now we have two different Server for CU32. One is for SQL & another is for NAVServer.

  • subrata.bauri Profile Picture
    subrata.bauri 1,112 on at
    RE: Lost SQL Server connection while compiling all objects

    Hi Rock,

    Thanks for your reply. Actually, I can't find the culprit object where compile stuck. Even It stops compiling when progress bar is 100%.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Lost SQL Server connection while compiling all objects

    OK So what you need to do is you have to recompile the Objects and see where exactly it terminates. Object where it stops, that;s the culprit and then you need to manually check that Object.

  • subrata.bauri Profile Picture
    subrata.bauri 1,112 on at
    RE: Lost SQL Server connection while compiling all objects

    Hi Rock,

    The Nav Service is run by DOMAIN\Administrator and it has proper rights on SQL Server as well as on the required database. Rights are cross verified, otherwise I can't be able to access the database thru RTC Client or can't compile a single object.

    The SQL Server and NST Server are on two different machine.

    As you said that there may be a data inconsistency, so I'd like to know *how to find the wrong data* in my db.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Lost SQL Server connection while compiling all objects

    Subraata,

    There could be many possibilities on this. Compilation wont b the ultimate cause. Check out this link

    forum.mibuso.com/.../global-dimension-change

    Service Account and permission to Service account must cross verify.

  • subrata.bauri Profile Picture
    subrata.bauri 1,112 on at
    RE: Lost SQL Server connection while compiling all objects

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans