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'
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
Feedback sent
We appreciate your effort and will try to fix the article