Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello everyone,
I get the following error when I try to open my PBIX file. How can i fix this error?
Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Çağrı Tarihi (12192)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Çağrı Tarihi (12192)' column.
Database consistency checks (DBCC) failed while checking the 'xView db2 102 CDR (12157)' table.
Database consistency checks (DBCC) failed while checking the '998c563a-5816-4dfb-854f-465d7c857c46' database.
PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED
PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED
True
Feedback Type:
Frown (Error)
Timestamp:
2023-06-05T10:56:20.2927354Z
Local Time:
2023-06-05T13:56:20.2927354+03:00
Session ID:
878baf3e-f8a1-401a-8822-e98cfaa5d48f
Release:
May 2023
Product Version:
2.117.984.0 (23.05) (x64)
Stack Trace:
Microsoft.AnalysisServices.OperationException
konum: Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
konum: Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, ICurrentFileManager currentFileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
konum: Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()
konum: Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
konum: Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.117.984.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.OperationException - PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED","MethodDef":"HandleError - PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED","ErrorOffset":"255"}
OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 tr-TR)
CLR Version:
4.8 or later [Release Number = 528372]
Peak Virtual Memory:
69.6 GB
Private Memory:
229 MB
Peak Working Set:
469 MB
IE Version:
11.789.19041.0
User ID:
592ece83-446b-4a1a-ac85-36103e6aab91
Telemetry Enabled:
True
DPI Scale:
125%
Supported Services:
Power BI
Hi @ercetevlim ,
Is your problem resolved? If so, please accept the helpful reply as solution, then we will close the thread, others who has the same problem will benefit here.
Best regards,
Community Support Team_yanjiang
No, problem has continue
Hi @ercetevlim ,
By my research, you can try the methods mentioned in the below post:
Troubleshoot database consistency errors reported - SQL Server | Microsoft Learn
Database consistency checks (DBCC) failed whil... - Microsoft Fabric Community
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Feedback Type:
Frown (Error)
Error Message:
Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Çağrı Tarihi (12192)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Çağrı Tarihi (12192)' column.
Database consistency checks (DBCC) failed while checking the 'xView db2 102 CDR (12157)' table.
Database consistency checks (DBCC) failed while checking the 'a86ff904-7ee3-457a-938e-4379a62f1a77' database.
Stack Trace:
Microsoft.AnalysisServices.OperationException
konum: Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
konum: Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, ICurrentFileManager currentFileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
konum: Microsoft.PowerBI.Client.Program.<>c_DisplayClass6_0.<RunApplication>b_0()
konum: Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c_DisplayClass3_0.<HandleExceptionsWithNestedTasks>b_0()
konum: Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
Stack Trace Message:
Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Çağrı Tarihi (12192)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Çağrı Tarihi (12192)' column.
Database consistency checks (DBCC) failed while checking the 'xView db2 102 CDR (12157)' table.
Database consistency checks (DBCC) failed while checking the 'a86ff904-7ee3-457a-938e-4379a62f1a77' database.
Invocation Stack Trace:
konum: Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
konum: Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
konum: Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
konum: Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
konum: Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c_DisplayClass14_0.<HandleException>b_0()
konum: Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
konum: Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
konum: Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
konum: Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
konum: Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.117.984.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.OperationException - PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED","MethodDef":"HandleError - PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED","ErrorOffset":"255"}
PowerBINonFatalError_ErrorDescription:
PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED
PowerBINonFatalError_MethodDefDescription:
PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED
PowerBIUserFeedbackServices_IsReported:
True
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
90 | |
83 | |
80 | |
49 |
User | Count |
---|---|
146 | |
137 | |
109 | |
68 | |
55 |