Critical .pbix failure: Database consistency checks failed... error occurred while loading Vertipaq

[jasonnaylor]

I receive the following error attempting to open a .pbix file I've been working on for months, just saved & closed it about an hour ago and now I can't open it:

Little bit scary.

I've pasted the contents of the error below, as suggested. Anything obvious I can do/try here?

---

Feedback Type:
Frown (Error)

Error Message:
Database consistency checks (DBCC) failed while checking the string store.
An error occurred while loading Vertipaq data objects for multiple tables.

Stack Trace:
Microsoft.AnalysisServices.OperationException
at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, IFileManager fileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__3()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message:
Database consistency checks (DBCC) failed while checking the string store.
An error occurred while loading Vertipaq data objects for multiple tables.

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.110.805.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.OperationException - PFE_XM_DBCC_STRINGSTORE_CORRUPT,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA","MethodDef":"HandleError - PFE_XM_DBCC_STRINGSTORE_CORRUPT,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA","ErrorOffset":"201"}

PowerBINonFatalError_ErrorDescription:
PFE_XM_DBCC_STRINGSTORE_CORRUPT,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA

PowerBINonFatalError_MethodDefDescription:
PFE_XM_DBCC_STRINGSTORE_CORRUPT,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA

PowerBIUserFeedbackServices_IsReported:
True

---

Feedback Type:
Frown (Error)

Timestamp:
2023-02-14T21:45:57.9438681Z

Local Time:
2023-02-15T10:45:57.9438681+13:00

Session ID:
75eecf52-b5e8-4d03-a28d-8dc8e4f7953d

Release:
October 2022

Product Version:
2.110.805.0 (22.10) (x64)

Stack Trace:
Microsoft.AnalysisServices.OperationException
at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.<OpenFileInternal>d__33.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.110.805.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.OperationException - PFE_XM_DBCC_STRINGSTORE_CORRUPT,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA","MethodDef":"HandleError - PFE_XM_DBCC_STRINGSTORE_CORRUPT,PFE_XM_ERROR_WHILE_PARALLEL_LOADING_IMBI_TABLE_DATA","ErrorOffset":"201"}

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
70.2 GB

Private Memory:
518 MB

Peak Working Set:
783 MB

IE Version:
11.789.19041.0

User ID:
c035e48d-b5df-48c8-ab31-5ec15c96616c

Workbook Package Info:
1* - en-NZ, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Enabled Preview Features:
PBI_enableWebView2
PBI_sparklines

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_relationshipEditPane

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-yetao1-msft]

Hi @jasonnaylor 

Looks like your .pbix model has been broken. Did this issue happened in each .pbix file or just a special one?

Here is a workaround from PG that you can try:

- start Desktop
- find the corresponding workspace folder
- set Vertipaq\DisableConsistencyChecks to 1 in msmdsrv.ini
- open the problematic report
- probably a simple refresh would fix the IMBI dictionaries; OR export as PBIT and reopen as usual

Best Regards,
Community Support Team _ Ailsa Tao

[jasonnaylor]

Hey @v-yetao1-msft this is very promising and thanks for responding, just one question!

When you say "- find the corresponding workspace folder" and edit the msmdsrv.ini file I'm assuming you mean something like this:

C:\Users\xxxxxx\AppData\Local\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\AnalysisServicesWorkspace_4f92daed-35b5-4f5e-aa50-7138630fe7d7\Data\msmdsrv.ini

I opened and had a peek in that file, there is no <DisableConsistencyChecks> object in there. I added one in, but still didn't help.

I found some other objects in that file and I changed the value of those but still no luck.

I like where this is going though. Did I find the correct file, and is there a reason I don't have the <DisableConsistencyChecks> node in my file?

[The_Bishop]

I had the same experience of not having that section, too @jasonnaylor. I am stuck!

[fpdean]

I was having this issue too with a large pbix file. I noticed that the disk space on the PC I was using was low and, when I opened the file in Power BI Desktop on a PC with plenty of available disk space the file opened with no issue.