Dynamics Community Forum Thread Details

Upgrade from v14 to v25 error in command Sync-NAVApp finalextension (Task 14)

I' trying to update BC14 version to BC25.

During Task 14 when execute this command:

Sync-NAVApp -ServerInstance $ServerInstance -Tenant Default -Name "bc14baseapptablesonly" -Version 1.0.0.1

this error is displayed:

Statement: exec sp_rename N'"dbo"."COMPANYNAME$Purchase Header$93456c23-dc9a-4bd3-aa53-83d7bde201df$ext"', N'TEMP$COMPANYNAME$Purchase Header$93456c23-dc9a-4bd3-aa53-83d7bde201df$ext', N'OBJECT'; IF (SELECT OBJECTPROPERTY(OBJECT_ID(N'dbo."COMPANYNAME$Purchase Header$93456c23-dc9a-4bd3-aa53-83d7bde201df$ext$Key1"'), N'IsPrimaryKey'))=1
EXEC sp_rename N'dbo."COMPANYNAME$Purchase Header$93456c23-dc9a-4bd3-aa53-83d7bde201df$ext$Key1"', N'TempPrimaryKeyIndexb280d', N'OBJECT';
ELSE BEGIN
DECLARE @KeyName sysname = (SELECT [name] from sys.indexes idx where idx.is_primary_key = 1 and idx.object_id = object_ID(N'TEMP$COMPANYNAME$Purchase Header$93456c23-dc9a-4bd3-aa53-83d7bde201df$ext'));
exec sp_rename @KeyName, N'TempPrimaryKeyIndexb280d', 'OBJECT';
END
exec sp_rename N'"dbo"."TEMP$COMPANYNAME$Purchase Header$93456c23-dc9a-4bd3-aa53-83d7bde201df$ext"."TempPrimaryKeyIndexb280d"', N'TEMP$COMPANYNAME$Purchase Header$93456c23-dc9a-4bd3-aa53-83d7bde201df$ext$Key1', N'INDEX'

ParentException: NavSqlException (HResult: 0x80131500)
An unexpected error occurred after a database command was cancelled.
ExceptionStackTrace:
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ThrowNavSqlException(SqlExceptionAdapter exceptionAdapter, Boolean transactionNoLongerValid, String commandText, Boolean isLastExceptionARollbackCause, Boolean logExceptions)
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.MapException(SqlExceptionAdapter exceptionAdapter, String commandText, Boolean isRollbackAction)
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTraceAsync[T,TState](EventTask task, Func`3 function, String commandText, SqlCommand sqlCommand, Boolean isAdoCommand, TState state)
InnerException:
RootException: SqlException (HResult: 0x80131904)
Either the parameter @objname is ambiguous or the claimed @objtype (OBJECT) is wrong.
Error: The input parameter 'OldName' is not allowed to be null.
Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong.

I've repeated all task multiple times but same error.

Any solution?

Categories:

Dynamics 365 Business Central migration

Quick Links