Lost SQL Server connection while compiling all objects

(0) Share

Report

Posted on by subrata.bauri

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

All responses (7)

Answers (0)

Suggested answer

RockwithNav 6,562 on at

Like (0)

Report

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 1,112 on at

Like (0)

Report

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 1,112 on at

Like (0)

Report

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 6,562 on at

Like (0)

Report

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 1,112 on at

Like (0)

Report

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 6,562 on at

Like (0)

Report

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 1,112 on at

Like (0)

Report

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