Data Upgrading from 2013 to 2013 R2

Hi All

Data Upgrading from NAV 2013 to NAV 2013 R2.

Followed steps below :-

  1. Done object migration from 2013 to 2013 R2

  2. Open 2013 DB in 2013 R2 development environment, uploaded 2013 R2 developer license.

  3. Created NAV service instance and opened DB in 2013 R2

  4. Imported Upgrade700701.1 objects in 2013R2 DB and Transfer Old data process

  5. Delete Objects except table from tool

  6. Imported merged objects in 2013 R2 DB and compiled

  7. Done Build Server Application objects

  8. Restarted NAV Service instance (given all permission to the network service and administrator)

9 ) Trying to open DB but getting below Error’s

i) 1st time error –“a connection to the server has been established. preparing your workspace”

Given cancel and tried

ii) 2nd Error


Microsoft Dynamics NAV


The operation could not complete because a record in the General Ledger Setup table was locked by another user. Please retry the activity.


OK


iii) went to event viewer following error showing…

Type: Microsoft.Dynamics.Nav.Client.NavClientClosingException

Fatal: False

ShowError: True

Message: The server “Shravan2013R2March” was unable to process the request. The application will close.

StackTrace:

at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.DoExecute(Func`1 execute)

at Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.RunCore()

Source: Microsoft.Dynamics.Nav.Client.WinClient

HResult: -2146233088


Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException

Message: The server “Shravan2013R2March” was unable to process the request. The application will close.

StackTrace:

at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.OpenConnection(ConnectFailedEventArgs connectFailedArgs, ConnectionRequest connectionRequest, SpnSetting spnSettingToTry, Boolean allowSpnSettingsSwap, UserSettings& userSettings)

at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.OpenConnection(ConnectFailedEventArgs connectFailedArgs, ConnectionRequest connectionRequest, SpnSetting spnSettingToTry, Boolean allowSpnSettingsSwap, UserSettings& userSettings)

at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.OpenConnection(ConnectionRequest connectionRequest, UserSettings& userSettings)

at Microsoft.Dynamics.Nav.Client.ServiceConnection.OpenConnection()

at Microsoft.Dynamics.Nav.Client.ServiceConnection.Initialize()

at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSessionInitializer.InitializeService(IService service)

at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSessionInitializer.OpenConnectionToServer()

at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.OpenServerConnectionCore()

at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.OpenServerConnectionWithMultipleLoginAttempts()

at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.InitializeUISession()

at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.SetupSessions()

at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.InitCore()

at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.InitCore()

at Microsoft.Dynamics.Framework.UI.ClientSessionCore.Init()

at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.Run()

at Microsoft.Dynamics.Nav.Client.WinClient.NavClientErrorHandler.ExecuteAndCatchExceptions(Func`1 execute)

Source: Microsoft.Dynamics.Nav.Client.ServiceConnection

HResult: -2146233088


Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException

Message: The server “Shravan2013R2March” was unable to process the request. The application will close.

HResult: -2146233088


Type: System.NullReferenceException

Message: Object reference not set to an instance of an object.

StackTrace:

at Microsoft.Dynamics.Nav.Runtime.NCLCaptionStrings.GetValueOrDefault()

at Microsoft.Dynamics.Nav.Runtime.NavSqlDatabaseSync.SynchronizeTableChanges(NavDatabase tenantDatabase, Boolean changedSortingProperties, IEnumerable`1 tableChanges, Int32[] companyTokens, SyncMode syncMode, Boolean databaseConvertedFromNav2013)

at Microsoft.Dynamics.Nav.Runtime.NavSqlDatabaseSync.SynchronizeTenantDatabase(NavDatabase tenantDatabase)

at Microsoft.Dynamics.Nav.Runtime.NavDatabase.EnsureDatabaseInSync()

at Microsoft.Dynamics.Nav.Runtime.NavUser.GetAllUsers(NavDatabase database)

at Microsoft.Dynamics.Nav.Runtime.NavUserCache.RefreshList()

at Microsoft.Dynamics.Nav.Runtime.NavUserCache.TryGetNavUser(Func`2 match, NavUser& user)

at Microsoft.Dynamics.Nav.Runtime.NavUserAuthentication.InternalAuthenticate()

at Microsoft.Dynamics.Nav.Runtime.NavUserAuthentication…ctor(NavTenant tenant, NavClientCredentialType credentialType, Object token)

at Microsoft.Dynamics.Nav.Service.NSServiceBase.ValidateAndCreateSession(ConnectionRequest connectionRequest, Boolean requireNavUser)

at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.CreateNewSessionCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, Boolean requireNavUser, Object[] inputs, Object[]& outputs)

Source: Microsoft.Dynamics.Nav.Ncl

HResult: -2147467261

  1. yet to import Upgrade700701.2 objects in 2013 R2 DB and transfer new data process– pending

Someone please help me on this issue.

Regards,

Muthu

Please give it some time as it is recreating the metadata…

Hi Mohana,

I kept as it is also, but after sometime below error coming…


Microsoft Dynamics NAV


The following SQL error was unexpected.

Cannot drop the index ‘dbo.Shravan Eng Live 2011$Detailed Cust_ Ledg_ Entry.$14’, because it does not exist or you do not have permission.


OK


Please help me on this…

Regards,

Muthu