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:

  1. Run script as below to rebuild the index

Exec sp_msforeachtable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REBUILD'

GO

 

 

 

 

 

 

 

 

 

      

   

  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 :)