Forum Discussion

dbeavon3's avatar
dbeavon3
Icon for Memorable Member rankMemorable Member
1 year ago
Solved

DirectLake on OL w/Import : Database consistency checks (DBCC) failed while checking the segment

I keep getting a random error, when refreshing a directlake partition in SSMS. Database consistency checks (DBCC) failed while checking the segment statistics. Technical Details: RootActivit...
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi dbeavon3,

     

    Thank you for the response, I completely understand the need to look under the hood. Unfortunately currently there is no direct or supported way to inspect the segment statistics used by DBCC in DirectLake models.

    Unlike imported models, where other tools like VertiPaq Analyzer or DAX Studio can expose segment and storage metadata but the DirectLake models do not yet expose this internal engine state, especially since the data remains external (like Delta Lake files in OneLake) and has not materialized in memory unless queried.

    If you are consistently hitting this issue on a specific table or structure, I recommend raising a support ticket with the full DBCC error details and the timestamp.

     

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa