Error running database update: Create failed for Index…

The following exception may occur during an Acctivate database upgrade if records exist with duplicate “key values”.  This problem is not very common, but it can potentially block a database upgrade until the duplicate key values are resolved.

Error running database update: Create failed for Index 'INVRegister_RegNumber'. --> An exception occurred while executing a Transact_SQL statement or batch. --> The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.tbINVRegister' and the index name 'INVRegister_RegNumber'.  The duplicate key value is (2631). The statement has been terminated.

9.0UpdateIndexError

For example, older versions of Acctivate potentially allowed multiple inventory transactions to be posted with the same session number (i.e., duplicates).  We added a UNIQUE constraint on the session number in Acctivate 9.0 to prevent this from ever happening again.  However, the database cannot resolve the duplicate problems automatically during the upgrade.  The above message may appear and our support team may be required to re-assign the duplicate key values.

Error running database update: Create failed for Index ‘INVRegister_RegNumber’. –> An exception occurred while executing a Transact_SQL statement or batch. –> The CREATE UNIQUE INDEX

Posted in Database - Last modified on September 9, 2015Cassandra Creasy
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.