Database consistency checks (DBCC) failed while checking the data segments

Question

We are suddenly getting the error "Database consistency checks (DBCC) failed while checking the data segments." in one of our SSAS Tabular Data Models in production server. 

Trying to redeploy also gives the same error in SSDT.  I am not able to delete the database either. 

We are using SQL Server 2016. 

What are my options to get around this?

Answer 1

I was able to delete the database using a XMLA query and then re-deploy/process the database. 

Still curious to know why exactly the error would occur though. Something to do with the data?

Answer 2

Still curious to know why exactly the error would occur though. Something to do with the data?

A DBCC error indicates some form of corruption. Most of the resolutions listed here https://docs.microsoft.com/en-us/sql/analysis-services/instances/database-consistency-checker-dbcc-for-analysis-services involve either re-processing or deleting and re-deploying. If you get this on a consistent basis your best option would be to raise a support ticket with Microsoft.

---

http://darren.gosbell.com - please mark correct answers

Answer 3

Hi VivDev,

Thanks for sharing the solution.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]