You’re offline. This is a read only version of the page.
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
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.
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.
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%.
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.
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.
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.
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
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,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (