Failed to create clustered index during database upgrade.
Error as below:
Failed to create clustered index. Please try again. Contact our technical support if this error persist.
Error: Unable to find index entry in index ID 0, of table 1541580530, in database 'databasename'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE.
What to do:
- Run script as below to rebuild the index
Exec sp_msforeachtable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REBUILD'
2. Run script to repair the database
ALTER DATABASE [databasename] SET EMERGENCY
DBCC CHECKDB ([databasename])
ALTER DATABASE databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB (databasename, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE databasename SET MULTI_USER
**Please replace databasename with your database code.
3. Re-open qne application and try update again. Contact our support if the problem still persisted.
Full attachment as below:
Thank you :)