Zurück
-
Titel
Database upgrade fails with creation or removal of constraints such as indexes -
Beschreibung
Database upgrade fails with creation or removal of constraints such as indexes. Below are a few errors that may occur:
- The operation failed because an index or statistics with name "IX_tblTaskError_TaskId" already exists on table dbo.tblTaskError (Microsoft SQL Server, Error: 1913)
- Column names in each table must be unique. Column name 'OldSlotCount' in table 'dbo.tblDiscoveryNode' is specified more than once.
- ERROR ExecuteSqlScriptTask.Execute: Exit (RunSQLScript threw an exception) : Microsoft.SqlServer.Management.Smo.FailedOperationException: ExecuteNonQuery failed for Database 'dbReporter'. ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: 'FK_tblNTFSChangeData_ID_tblNTFSChangeHistory' is not a constraint.
Anmeldung erforderlich
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.