question

ChansonInno-7351 avatar image
0 Votes"
ChansonInno-7351 asked bvg commented

MS Excel Container unexpectedly exited. Exit code: 0xC0000005

Hello,

I just had Windows 10 Enterprise on my office desktop updated to version 1909 a few hours ago. I'd been using Power Query on several Excel files and was working very fine. As soon as the update completed successfully and the PC rebooted at least twice, I opened the Excel files again and this error Container unexpectedly exited. Exit code: 0xC0000005 was popping up. This error comes regardless of whether I'm refreshing the query, opening/importing a file, editing a query etc.

I've checked similar questions on the forum and they all don't answer my problem. I've also sent several frowns when the error message pops up.

I'm running Office 2016 x64 on a Windows 10 PC with 16GB RAM and HDD free space of 20GB.

Sample error message is below:


Feedback Type:
Frown (Error)

Error Message:
Container unexpectedly exited. Exit code: 0xC0000005.

Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Container unexpectedly exited. Exit code: 0xC0000005. ---> System.InvalidOperationException: Container unexpectedly exited. Exit code: 0xC0000005. ---> System.InvalidOperationException: Container unexpectedly exited. Exit code: 0xC0000005.
at Microsoft.Mashup.Evaluator.ContainerProcess.Start()
at Microsoft.Mashup.Evaluator.ProcessContainerFactory.Container..ctor(String exePath, String exitMutexName, Int32 containerID, ContainerJob job)
at Microsoft.Mashup.Evaluator.ProcessContainerFactory.CreateProcessContainer()
at Microsoft.Mashup.Evaluator.WorkingSetProcessContainerFactory.CreateProcessContainer()
at Microsoft.Mashup.Evaluator.ContainerPoolContainerFactory.CreatePooledContainer(TimeSpan ttlAdjustment)
at Microsoft.Mashup.Evaluator.ContainerPoolContainerFactory.CreateContainer()
at Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.CreateContainer()
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.CreateContainer()
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryCompleteWithException(Exception exception)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
at Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c_DisplayClass15.<CreateAction>b_14(Object o)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)
at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c_DisplayClass20.<GetPreviewResult>b1f()
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c
DisplayClassf.<InvokeOnWorkbook>be(IWorkbook workbook, IWindowContext windowContext)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook[T](Func`3 action, T defaultValue)
at Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c
DisplayClass20.<OnQuerySettingsResolved>b_1d()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


Supports Premium Content:
True

Formulas:


section Section1;

shared LoanTracking = let
Source = File.Contents("C:\TestFolder\Timelines.csv")
in
Source;

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered bvg commented

This is a generic access violation error, but we have sometimes seen it caused by antivirus software. Are you running any third-party (non-Microsoft) virus software?

· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I use Symantec Endpoint protection.

0 Votes 0 ·
Ehren avatar image Ehren ChansonInno-7351 ·

Try disabling Symantec and see if you still get the PQ error.

0 Votes 0 ·

Did this resolve your situation?

I have been frustrated for a while now as none of my excel power queries are working...

My error message is pasted below:

Feedback Type:
Frown (Error)

Error Message:
Container unexpectedly exited. Exit code: 0xC0000005.

Stack Trace:

Server stack trace:


Exception rethrown at [0]:
at Microsoft.OleDb.AsyncResult`1.get_Value()
at Microsoft.Mashup.OleDbProvider.DataHost.BufferingMashupEvaluator.BufferingMashupEvaluation.GetBufferedReaderSource(AsyncResult`1 result)
at Microsoft.Mashup.OleDbProvider.DataHost.BufferingMashupEvaluator.BufferingMashupEvaluation.OnEvaluationComplete(AsyncResult`1 result)

Exception rethrown at [1]:
at Microsoft.OleDb.AsyncResult`1.get_Value()
at Microsoft.Mashup.OleDbProvider.MashupRowset.get__Rowset()
at Microsoft.Mashup.OleDbProvider.MashupRowset.get_ColumnsInfo()
at Microsoft.OleDb.Rowset.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)
at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

....

0 Votes 0 ·
Show more comments