mibuso.com
Home› NAV Three Tier
Options

Data Upgrading from 2013 to 2013 R2

gandhi_nklgandhi_nkl Member Posts: 44
edited 2015-04-08 in NAV Three Tier
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.
Thanks & Regards,
Muthu

Answers

  • Options
    postsauravpostsaurav Member Posts: 708
    Hi,

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

    Run the synctenant cmdlet from Administration Shell.
    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • Options
    gandhi_nklgandhi_nkl Member Posts: 44
    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
    Thanks & Regards,
    Muthu
  • Options
    erarunaryaerarunarya Member Posts: 21
    Go to Nav Administrator Shell.
    Use sync-NavTenant command.
    Enter Instance Name on prompt for example dynamicsNav71.
    This will solve this issue.
  • Options
    gandhi_nklgandhi_nkl Member Posts: 44
    edited 2015-04-08
    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>
    Thanks & Regards,
    Muthu
  • Options
    gandhi_nklgandhi_nkl Member Posts: 44
    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.
    Thanks & Regards,
    Muthu
  • Options
    aliehs023aliehs023 Member Posts: 1
    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!
  • Options
    gandhi_nklgandhi_nkl Member Posts: 44
    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
    Thanks & Regards,
    Muthu
Sign In or Register to comment.