none
ERROR Message - Help please! RRS feed

  • Question

  • I keep getting this error message when I try to refresh my preview.  

    It has not yet even loaded the whole worksheet once I click Save and upload from the query editor - is it due to the volume of information I am trying to import from website?

    Feedback Type:
    Frown (Error)

    Error Message:
    Container exited unexpectedly with code 0x4000001F.
    Used features: (none).

    Stack Trace:
    Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0x4000001F.
    Used features: (none). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0x4000001F.
       at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
       at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
       --- End of inner exception 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.WaitFor[T](IMessageChannel channel)
       at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
       at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()
       at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

    Stack Trace Message:
    Container exited unexpectedly with code 0x4000001F.
    Used features: (none).

    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.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo)
       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__DisplayClass1.<HandleException>b__0()
       at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
       at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
       at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialogBase`1.DelayedInitializationExceptionHandler.HandleException(Exception e)
       at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Exception.ExceptionResultHtmlControl.<OnViewLoaded>b__0()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClassf.<Post>b__e(Object null)
       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.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.RunDialog(Form form)
       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
       at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
       at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__FabricatedMethod8(IWindowHandle )
       at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>c__DisplayClass6.<ShowModal>b__5()
       at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
       at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.ShowModal(IWindowHandle owner)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass5.<ShowModalQueriesEditorWindow>b__1(IUndoScope undoScope)
       at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.<>c__DisplayClass2.<InvokeUndoableAction>b__0()
       at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
       at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
       at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass5.<ShowModalQueriesEditorWindow>b__0()
       at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
       at Microsoft.Mashup.Client.Excel.DialogManager.TryShowModalEditor(IWindowHandle ownerWindow, IWorkbook workbook, Query query, Boolean isNewQuery, Boolean navigatorExpanded)
       at Microsoft.Mashup.Client.Excel.ExcelQueryServices.<>c__DisplayClass1b.<EditQuery>b__1a(IWorkbook workbook)
       at Microsoft.Mashup.Client.Excel.ExcelQueryServices.TryInvokeOnWorkbook(Action`1 action)
       at Microsoft.Mashup.Client.Excel.ExcelQueryServices.EditQuery(Query query, Boolean invokeAsFunction)
       at Microsoft.Mashup.Client.Excel.TaskPaneControls.QueriesTaskPaneControlBase.<>c__DisplayClass50.<EditQuery>b__4f()
       at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
       at Microsoft.Mashup.Client.Excel.TaskPaneControls.TaskPaneControl.NotifyGetDataPresence(Action action)
       at Microsoft.Mashup.Client.Excel.TaskPaneControls.QueriesTaskPaneControlBase.EditQuery(Query query, Boolean invokeAsFunction)
       at Microsoft.Mashup.Client.Excel.TaskPaneControls.QueriesTaskPaneControlBase.<>c__DisplayClass53.<EditQueryAsync>b__52()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClassf.<Post>b__e(Object null)
       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.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    Supports Premium Content:
    False

    Formulas:


    section Section1;

    shared IdTable = (Page as number) as table =>

    let
        Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://www.adsc-iafd.com/membership/membership-directory/"& Number.ToText(Page)))}),
        #"Filtered Rows1" = Table.SelectRows(Source, each Text.Contains([Column1], "<br /></td><td><a href=""?id=")),
        #"Extracted Text Between Delimiters" = Table.TransformColumns(#"Filtered Rows1", {{"Column1", each Text.BetweenDelimiters(_, "id=", """>"), type text}}),
        #"Renamed Columns" = Table.RenameColumns(#"Extracted Text Between Delimiters",{{"Column1", "Membership ID"}})
    in
        #"Renamed Columns";

    shared #"Full Membership Table" = let
        Source = {0..72},
        #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
        #"Cleaned Text" = Table.TransformColumns(Table.TransformColumnTypes(#"Converted to Table", {{"Column1", type text}}, "en-NZ"),{{"Column1", Text.Clean, type text}}),
        #"Trimmed Text" = Table.TransformColumns(#"Cleaned Text",{{"Column1", Text.Trim, type text}}),
        #"Renamed Columns" = Table.RenameColumns(#"Trimmed Text",{{"Column1", "Page"}}),
        #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Page", Int64.Type}}),
        #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each IdTable([Page])),
        #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Membership ID"}, {"Custom.Membership ID"}),
        #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Page"})
    in
        #"Removed Columns";

    shared MemberTable = (Id as number) as table =>
    let
        Source = Web.Page(Web.Contents("https://www.adsc-iafd.com/membership/membership-directory/?id="&Number.ToText(Id))),
        Data0 = Source{0}[Data],
        Children0 = Data0{0}[Children],
        Children2 = Children0{2}[Children],
        Children1 = Children2{1}[Children],
        Children7 = Children1{7}[Children],
        Children3 = Children7{1}[Children],
        Children4 = Children3{1}[Children],
        Children5 = Children4{1}[Children],
        Children6 = Children5{1}[Children],
        Children8 = Children6{1}[Children],
        Children9 = Children8{0}[Children],
        Children10 = Children9{1}[Children],
        Children11 = Children10{1}[Children],
        Children12 = Children11{1}[Children],
        Children = Children12{1}[Children],
        Children13 = Children{2}[Children],
        #"Expanded Children" = Table.ExpandTableColumn(Children13, "Children", {"Text"}, {"Children.Text"}),
        #"Replaced Value" = Table.ReplaceValue(#"Expanded Children",null,"",Replacer.ReplaceValue,{"Children.Text"}),
        #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",null,"",Replacer.ReplaceValue,{"Text"}),
        #"Merged Columns" = Table.CombineColumns(#"Replaced Value1",{"Children.Text", "Text"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Member"),
        #"Filtered Rows" = Table.SelectRows(#"Merged Columns", each [Member] <> null and [Member] <> ""),
        #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Kind", "Name"}),
        #"Transposed Table" = Table.Transpose(#"Removed Columns")
       
    in
        #"Transposed Table";

    shared Full_Membership_Table = let
        Source = Excel.CurrentWorkbook(){[Name="Full_Membership_Table"]}[Content],
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Custom.Membership ID", Int64.Type}}),
        #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each MemberTable([Custom.Membership ID])),
        #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10"}, {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10"}),
        #"Filtered Rows" = Table.SelectRows(#"Expanded Custom", each [Column6] = "back")
    in
        #"Filtered Rows";

    Monday, November 26, 2018 8:03 AM

Answers

  • Hi Charlene. I was able to reproduce the error using the queries you shared above. When I run it locally, it looks like the mashup container process (the one that executes your M queries) is running out of memory. I'm not sure why this is throwing the strange error code you listed above, but that's what happens locally for me as well.

    One tip not related to this error: You should be able to have your Full_Membership_Table query reference the "Full Membership Table" query directly in its Source step. e.g.

    shared Full_Membership_Table = let
        Source = #"Full Membership Table",
        ...

    Now back to the error. There are a few options I can think of.

    • Try using the 64-bit version of Excel or Power BI Desktop, to see if you can successfully refresh the full query.
    • Try limiting the number of pages you're pulling, to reduce the memory usage.
    • Break Full_Membership_Table up into multiple queries. They will each refresh in their own mashup container process, which should divvy up the memory consumption across containers.
    • Modify the MemberTable query to use Web.Contents by itself (instead of Web.Page plus Web.Contents). Web.Page uses Internet Explorer behind the scenes, which can be quite memory intensive (especially when you're making 1400+ web requests).

    Ehren

    Friday, November 30, 2018 12:05 AM
    Owner