BC Upgrade from v14 to v22

julkifli33

Hi All,
I am doing BC upgrade on premise v14 to v22.

but during this step
Publish-NAVApp -ServerInstance BC220-Development -Path "C:\ACN Folder\BC220 CU 15 AU\Applications\System Application\Source\Microsoft_System Application.app"
Publish-NAVApp -ServerInstance BC220-Development -Path "C:\ACN Folder\BC220 CU 15 AU\Applications\BaseApp\Source\Microsoft_Base Application.app"
Publish-NAVApp -ServerInstance BC220-Development -Path "C:\ACN Folder\BC220 CU 15 AU\Applications\Application\Source\Microsoft_Application.app"

Sync-NAVTenant -ServerInstance BC220-Development -Mode Sync -Tenant Default -Force
Sync-NAVApp -ServerInstance BC220-Development -Tenant Default -Name "System Application" -Version 22.15.64637.0

error here -->
Sync-NAVApp -ServerInstance BC220-Development -Tenant Default -Name "Base Application" -Version 22.15.64637.0


I always got this error
Sync-NAVApp : An unexpected error occurred after a database command was cancelled.

here is the event viewer

The description for Event ID 705 from source MicrosoftDynamicsNavServer$BC220-Development cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: 

Server instance: BC220-Development
Category: Sql
ClientSessionId: 00000000-0000-0000-0000-000000000000
ClientActivityId: 00000000-0000-0000-0000-000000000000
ServerSessionUniqueId: 5f9e30fd-edc6-45cf-9756-92172409b52a
ServerActivityId: 6614ba11-e481-4111-9d51-c7a077052dca
EventTime: 10/15/2024 13:24:47
Message Action completed successfully, but it took longer than the given threshold.
  Execution time: 910 ms
  Threshold: 750 ms
  Message: Long running SQL statement
  Task ID: 10
  Connection ID: 1
  SQL server session ID: 54
  Client Type: Background
  Database Server Name: SERVERNAME
  Database Name: BC220-Development
  Current Company Name: 
  Statement: Rollback
  
ProcessId: 4708
Tag: 000007S
ThreadId: 94
CounterInformation: 
CustomParameters: {
}
GatewayCorrelationId: 

The message resource is present but the message was not found in the message table

\

any idea?

Duikmeester

Does the error occur after about 10 hours? That is the default SQL connection timeout.

julkifli33

Hi @Duikmeester
no. when i sync app

Sync-NAVApp : An unexpected error occurred after a database command was cancelled.
At line:1 char:1
+ Sync-NAVApp -ServerInstance BC220-Development -Tenant Default -Name " ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Sync-NAVApp], InvalidOperationException
    + FullyQualifiedErrorId : MicrosoftDynamicsNavServer$BC220-Development/Default,Microsoft.Dynamics.Nav.Apps.Management.Cmdlets.SyncNavApp

I checked from event viewer, something wrong with the index

Message:
  The following SQL error was unexpected:
  Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong.
  Caution: Changing any part of an object name could break scripts and stored procedures.
  Caution: Changing any part of an object name could break scripts and stored procedures.
  Caution: Changing any part of an object name could break scripts and stored procedures.
  Caution: Changing any part of an object name could break scripts and stored procedures.
  Caution: Changing any part of an object name could break scripts and stored procedures.
  Caution: Changing any part of an object name could break scripts and stored procedures.
  SQL statement:
  exec sp_rename N'"dbo"."A_C_N_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972"."$1"', N'$Key2', N'INDEX'; exec sp_rename N'"dbo"."A_C_N_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972"."$2"', N'$Key3', N'INDEX'; exec sp_rename N'"dbo"."A_C_N_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972"."$3"', N'$Key4', N'INDEX'; exec sp_rename N'"dbo"."A_C_N_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972"."$4"', N'$Key5', N'INDEX'; exec sp_rename N'"dbo"."A_C_N_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972"."$7"', N'$Key8', N'INDEX'; exec sp_rename N'"dbo"."A_C_N_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972"."$8"', N'$Key9', N'INDEX'; exec sp_rename N'"dbo"."A_C_N_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972"."$9"', N'$Key10', N'INDEX'

Wisa123

@julkifli33
Sorry to hijack this thread.

A year later, and same problem here for me. In my case its Table "Company Information", so should be straight forwards, no extra indizes/keys.

If you have made any progress regarding this issue, i would love to know.

Thanks, Wisa