Getting data from Access into Excel: Container exited unexpectedly with code 0xC0000409. PID: 11396.

Question

Hi,

I have some Excels that take data out of an Access database using an ODBC connection. This used to work properly for a long time, and suddenly, without changing something, it gives error Container exited unexpectedly with code 0xC0000409. PID: 11396.

When trying to connect Access to a new Excel file it creates a similar however unspecified error.

I'm using Excel and Access version 2302 build 16130.20394.

See error log below.

Feedback Type:

Frown (Error)

Error Message:

Container onverwacht afgesloten met code 0xC0000409. PID: 11396.

Gebruikte functies: (geen).

Stack Trace:

Server stack trace:

Exception rethrown at [0]:

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

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 System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at Microsoft.Mashup.OleDbProvider.MashupCommandEvaluation.get_PageReader()

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)

Stack Trace Message:

Container onverwacht afgesloten met code 0xC0000409. PID: 11396.

Gebruikte functies: (geen).

Invocation Stack Trace:

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)

at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)

at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.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.Mashup.Client.Excel.OleDbProvider.ExcelMashupClassFactory.TraceAndReportException(String method, Exception exception)

at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

at Microsoft.OleDb.PInvokeInterop.ColumnsInfoTypeInfo.GetColumnInfo(IntPtr objHandle, DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

InnerException0.Stack Trace Message:

Container onverwacht afgesloten met code 0xC0000409. PID: 11396.

Gebruikte functies: (geen).

InnerException0.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__DisplayClass9_0.<CreateAction>b__0(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)

InnerException0.Invocation Stack Trace:

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)

at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)

at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.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.Mashup.Client.Excel.OleDbProvider.ExcelMashupClassFactory.TraceAndReportException(String method, Exception exception)

at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

at Microsoft.OleDb.PInvokeInterop.ColumnsInfoTypeInfo.GetColumnInfo(IntPtr objHandle, DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

InnerException1.Stack Trace Message:

Container onverwacht afgesloten met code 0xC0000409. PID: 11396.

Gebruikte functies: (geen).

InnerException1.Stack Trace:

at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()

at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)

at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()

at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitForT

at Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunkAndCheckIfClosed()

at Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunk()

at Microsoft.Mashup.Common.ChunkedInputStream.Read(Byte[] buffer, Int32 offset, Int32 count)

at System.IO.BinaryReader.FillBuffer(Int32 numBytes)

at System.IO.BinaryReader.ReadInt32()

at Microsoft.Mashup.Evaluator.ITableSourceSerializationExtensions.ReadITableSource(BinaryReader reader)

at Microsoft.Mashup.Evaluator.RemotePageReader.CreatePageReader(OwnedStream stream)

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.DataReaderSourceRemoteEvaluation.GetResult(Boolean enableFirewall)

at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)

InnerException1.Invocation Stack Trace:

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)

at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)

at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.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.Mashup.Client.Excel.OleDbProvider.ExcelMashupClassFactory.TraceAndReportException(String method, Exception exception)

at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

at Microsoft.OleDb.PInvokeInterop.ColumnsInfoTypeInfo.GetColumnInfo(IntPtr objHandle, DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

InnerException2.Stack Trace Message:

Container onverwacht afgesloten met code 0xC0000409. PID: 11396.

InnerException2.Stack Trace:

at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()

at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()

InnerException2.Invocation Stack Trace:

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)

at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)

at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.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.Mashup.Client.Excel.OleDbProvider.ExcelMashupClassFactory.TraceAndReportException(String method, Exception exception)

at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

at Microsoft.OleDb.PInvokeInterop.ColumnsInfoTypeInfo.GetColumnInfo(IntPtr objHandle, DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)

Error Additional Details:

EvaluationContainerLoader.cpp(116): Container starting with arguments: 17152 17268 55416002-d703-4c80-8df1-dc0fe85a3d27 9

EvaluationContainerLoader.cpp(59): Enumerating .net runtimes

EvaluationContainerLoader.cpp(78): v2.0.50727

EvaluationContainerLoader.cpp(78): v4.0.30319

EvaluationContainerLoader.cpp(82): Found match

EvaluationContainerLoader.cpp(149): Loading runtime

EvaluationContainerLoader.cpp(163): Starting runtime

EvaluationContainerLoader.cpp(176): Executing managed entry point

Container Managed entry point has started

Container has started to run

Pipes were set up

Running the evaluation host

Supports Premium Content:

False

Formulas:

section Section1;

shared Uren = let

Bron = Access.Database(File.Contents("D:\Documents\AccessData\Projecten\UrenData.mdb"), [CreateNavigationProperties=true]), 

\_Uren = Bron{[Schema="",Item="Uren"]}[Data], 

#"Andere kolommen verwijderd" = Table.SelectColumns(\_Uren,{"ProjectId", "UrenDatum", "Uren"}) 

in

#"Andere kolommen verwijderd"; 

shared Projecten = let

Bron = Access.Database(File.Contents("D:\Documents\AccessData\Projecten\UrenData.mdb"), [CreateNavigationProperties=true]), 

\_Projecten = Bron{[Schema="",Item="Projecten"]}[Data] 

in

\_Projecten;

Answer 1

It is suggested to raise a support ticket to Microsoft for such issue. It's difficient to test such issue without enviroment at hand.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. That support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.