Skip to main content

Notifications

Business Central forum
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Upgrade customized C/AL BCv14 to BCv19 error on Sync-NAVApp empty table migration extension with The input parameter OldName is not allowed to be null

Posted on by 60

Trying an upgrade from BC Cronus v14 CU18 with a 2 custom tables to BC v19.4 on premise,

using the following guide https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-14-synchronize-final-extensions

On Task 14: Task 14: Synchronize final extensions

Sync-NAVApp -ServerInstance BC19CronusAllObj -Name "bc14baseapptablesonly" -Version 1.1.0.0

gives the error 

Sync-NAVApp : Changes to the tenant database could not be applied. Affected tables will not be available.
The first error was:
Cannot delete the O365 Device Setup Instructions table from the Demo Test5 Database NAV (14-0) database because it contains data
for the company.
Retry the operation when the problem has been resolved.

when trying to force the sync

Sync-NAVApp -ServerInstance BC19CronusAllObj -Name "bc14baseapptablesonly" -Version 1.1.0.0 -Mode ForceSync -Force 

gets the error

Sync-NAVApp : The following SQL error occurred after the SQL command was canceled:
Either the parameter @objname is ambiguous or the claimed @objtype (OBJECT) is wrong.
Error: The input parameter 'OldName' is not allowed to be null.

Message App Sync Exception -- Microsoft.Dynamics.Nav.Types.Exceptions.NavSqlException: The following SQL error occurred after the SQL command was canceled:
Either the parameter @objname is ambiguous or the claimed @objtype (OBJECT) is wrong.
Error: The input parameter 'OldName' is not allowed to be null.
---> System.Data.SqlClient.SqlException: Either the parameter @objname is ambiguous or the claimed @objtype (OBJECT) is wrong.
Error: The input parameter 'OldName' is not allowed to be null.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

....

Statement: exec sp_rename N'"dbo"."Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13"', N'Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972', N'OBJECT'; IF (SELECT OBJECTPROPERTY(OBJECT_ID(N'dbo."Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$Key1"'), N'IsPrimaryKey'))=1
EXEC sp_rename N'dbo."Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$Key1"', N'Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972$Key1', 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'Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972'));
exec sp_rename @KeyName, N'Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972$Key1', 'OBJECT';
END; IF OBJECT_ID(N'dbo.Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemId', 'UQ') IS NOT NULL BEGIN exec sp_rename N'"dbo"."Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemId"', N'Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972$$systemId', N'OBJECT' END
IF OBJECT_ID(N'dbo.MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemId', 'D') IS NOT NULL BEGIN exec sp_rename N'"dbo"."MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemId"', N'MDF$Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972$$systemId', N'OBJECT' END
IF OBJECT_ID(N'dbo.MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemCreatedAt', 'D') IS NOT NULL BEGIN exec sp_rename N'"dbo"."MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemCreatedAt"', N'MDF$Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972$$systemCreatedAt', N'OBJECT' END
IF OBJECT_ID(N'dbo.MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemCreatedBy', 'D') IS NOT NULL BEGIN exec sp_rename N'"dbo"."MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemCreatedBy"', N'MDF$Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972$$systemCreatedBy', N'OBJECT' END
IF OBJECT_ID(N'dbo.MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemModifiedAt', 'D') IS NOT NULL BEGIN exec sp_rename N'"dbo"."MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemModifiedAt"', N'MDF$Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972$$systemModifiedAt', N'OBJECT' END
IF OBJECT_ID(N'dbo.MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemModifiedBy', 'D') IS NOT NULL BEGIN exec sp_rename N'"dbo"."MDF$Printer Selection$4bde5a55-7fec-4105-b8c8-d2c531b07c13$$systemModifiedBy"', N'MDF$Printer Selection$437dbf0e-84ff-417a-965d-ed2bb9650972$$systemModifiedBy', N'OBJECT' END

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans