Failed to create clustered index during database upgrade.

Created by Hazel Ng, Modified on Tue, 17 Nov, 2020 at 11:40 AM by Hazel Ng

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article