Data Upgrading from 2013 to 2013 R2

gandhi_nkl

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 "TEST2013R2" 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 "TEST2013R2" 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 "TEST2013R2" 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

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



Someone please help me on this issue.

postsaurav

Hi,

The SQL Is updating the metadata. Do not restart the service.

Run the synctenant cmdlet from Administration Shell.

gandhi_nkl

postsaurav wrote:

Hi,

The SQL Is updating the metadata. Do not restart the service.

Run the synctenant cmdlet from Administration Shell.

Hi,

Can you please explain me in detail.

Regards,
Muthu

erarunarya

Go to Nav Administrator Shell.
Use sync-NavTenant command.
Enter Instance Name on prompt for example dynamicsNav71.
This will solve this issue.

gandhi_nkl

erarunarya wrote:

Go to Nav Administrator Shell.
Use sync-NavTenant command.
Enter Instance Name on prompt for example dynamicsNav71.
This will solve this issue.

Hi,

Thanks for your reply...

I have done the Sync-NAVTenant, but not yet my issue got solved.

Getting below Error, my service's are running,SQL server also working fine.

Please help me on this..

PS C:\Windows\system32> Sync-NAVTenant

cmdlet Sync-NAVTenant at command pipeline position 1
Supply values for the following parameters:
ServerInstance: Test2013R2
Sync-NAVTenant : A connection to SQL server is no longer usable.
This could be caused by one of the following reasons:
* The server has been shut down manually or because of an error.
* The SQL server connection settings are not correct.
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.
Try to connect again later or contact your system administrator.
At line:1 char:1
+ Sync-NAVTenant
+ ~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (0:Int32) [Sync-NAVTenant], FaultE
xception`1
+ FullyQualifiedErrorId : MicrosoftDynamicsNavServer$TEST2013R2,Mi
crosoft.Dynamics.Nav.Management.Cmdlets.SyncNavTenant

PS C:\Windows\system32>

gandhi_nkl

gandhi_nkl wrote:

erarunarya wrote:

Go to Nav Administrator Shell.
Use sync-NavTenant command.
Enter Instance Name on prompt for example dynamicsNav71.
This will solve this issue.

Hi,

Thanks for your reply...

I have done the Sync-NAVTenant, but not yet my issue got solved.

Getting below Error, my service's are running,SQL server also working fine.

Please help me on this..

PS C:\Windows\system32> Sync-NAVTenant

cmdlet Sync-NAVTenant at command pipeline position 1
Supply values for the following parameters:
ServerInstance: Test2013R2
Sync-NAVTenant : A connection to SQL server is no longer usable.
This could be caused by one of the following reasons:
* The server has been shut down manually or because of an error.
* The SQL server connection settings are not correct.
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.
Try to connect again later or contact your system administrator.
At line:1 char:1
+ Sync-NAVTenant
+ ~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (0:Int32) [Sync-NAVTenant], FaultE
xception`1
+ FullyQualifiedErrorId : MicrosoftDynamicsNavServer$TEST2013R2,Mi
crosoft.Dynamics.Nav.Management.Cmdlets.SyncNavTenant

PS C:\Windows\system32>

Hi,

Thanks for your support..

Sync-NAVtenant not helped me on this...

I have successfully done the same data migration in my laptop.
I can not do R and D on server, because SQL is running and also all other customer database available in server..

anyway my issue got resolved.

aliehs023

May i ask how do you resolved this error? thank you for the response!

"
MicrosoftDynamicsNavServer$DynamicsNAV80
Confirm synchronization of default tenant in ForceSync mode
[Y] Yes [N] No Suspend [?] Help (default is "Y"): Y
Sync-NavTenant : A connection to SQL server is no longer usable.
This could be caused by one of the following reasons:
* The server has been shut down manually or because of an error.
* The SQL server connection settings are not correct.
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.
Try to connect again later or contact your system administrator.
At line:1 char:1
+ Sync-NavTenant -ServerInstance DynamicsNAV80 -Mode Force
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (0:Int32) [Sync-NAVTenant], NavCom
mandException
+ FullyQualifiedErrorId : MicrosoftDynamicsNavServer$DynamicsNAV80,Microso
ft.Dynamics.Nav.Management.Cmdlets.SyncNavTenant

PS C:\Windows\system32> "

THANKS!

gandhi_nkl

Hi,
while opening the database I received below message,
“a connection to the server has been established. preparing your workspace”

Solution:-
waited more than half an hour, after that database got opened automatically.

Regards,
Muthu