Dynamics Community Forum Thread Details

Onpremise - D365 - Upgrading from 9.0.51.06 to 9.1.20.11 Facing issue 'fndx_Sync_VersionNumber'.

Dears

I'm trying to update on premise D365 directly from 9.0.51.6 to 9.1.20.11 facing issue "System.Data.SqlClient.SqlException: Column 'CreatedOn' is partitioning column of the index 'fndx_Sync_VersionNumber'. Partition columns for a unique index must be a subset of the index key."

we have tried to delete all fndx_Sync_VersionNumber indexes and try to update again facing same issue.

Kindly advise me for this issue also suggest what kind of order we must install Cumulative updates 9.1

Either we need install one by one or we can directly install update 9.1.20.11 on top of D365 9.0.51.6 version.

kindly need you suggestion on the same

Error Log:

Error| Exception occurred during Microsoft.Crm.Tools.Admin.OrganizationDBUpdateInstaller: Error.ActionFailed Microsoft.Crm.Tools.Admin.InstallCDSStandardDatabaseUpdatesAction
InnerException:
Microsoft.Crm.CrmException: Error in Action: Bin\Microsoft.Crm.Setup.DiffBuilder.dll:Microsoft.Crm.Setup.DiffBuilder:UpdateMetadata on attempt 3. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Column 'CreatedOn' is partitioning column of the index 'fndx_Sync_VersionNumber'. Partition columns for a unique index must be a subset of the index key.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)