none
power query error in excel Container exited unexpectedly with code 0x4000001F. RRS feed

  • Question

  • i have a excel sheet setup i have a query that goes out to the fedex site and pulls in tracking info. sometimes the query will refresh, sometimes it will not. i have about 500 records in the table and it loads around 400 records and then sometimes errors. 

    can anyone help?

    the error log is below:

    Feedback Type:
    Frown (Error)

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

    Stack Trace:

    Server 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.MessageBasedInputStream.ReadNextChunkAndCheckIfClosed()
       at Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunk()
       at Microsoft.Mashup.Common.ChunkedInputStream.Read(Byte[] buffer, Int32 offset, Int32 count)
       at Microsoft.OleDb.Serialization.PageReader.Read(Byte[] buffer, Int32 offset, Int32 count)
       at Microsoft.OleDb.Serialization.PageReader.ReadChars(Int32 count)
       at Microsoft.OleDb.Serialization.PageReader.ReadArray(String[] values, Int32 offset, Int32 count)
       at Microsoft.OleDb.StringColumn.Deserialize(PageReader reader)
       at Microsoft.OleDb.NullableColumn.Deserialize(PageReader reader)
       at Microsoft.OleDb.Serialization.ColumnsPage.Deserialize(PageReader reader)
       at Microsoft.OleDb.Serialization.OleDbPageReader.Read(ColumnsPage page)
       at Microsoft.OleDb.Serialization.OleDbPageReader.Read(IPage page)
       at Microsoft.Mashup.Common.DelegatingPageReader.Read(IPage page)
       at Microsoft.Mashup.Engine.Interface.Tracing.TracingPageReader.Read(IPage page)
       at Microsoft.Mashup.OleDbProvider.DataHost.BufferingMashupEvaluator.BufferingMashupEvaluation.SerializeResult(IDataReaderSource dataReaderSource, Stream stream)
       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 [0]: 
       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)

    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.Excel.OleDbProvider.ExcelMashupClassFactory.TraceAndReportException(String method, Exception exception)
       at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IColumnsInfo.GetColumnInfo(DBORDINAL& countColumnInfos, DBCOLUMNINFO*& nativeColumnInfos, Char*& nativeStrings)


    Supports Premium Content:
    True

    Formulas:


    section Section1;

    shared fxtrack = (MyURL)=>

    let
        Source = Web.Page(Web.Contents(MyURL)),
        Data0 = Source{0}[Data],
        #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date/Time", type datetime}, {"Activity", type text}, {"Location", type text}, {"Details", type text}}),
        #"Kept First Rows" = Table.FirstN(#"Changed Type",1)
    in
        #"Kept First Rows";

    shared trackme = let
        Source = Excel.CurrentWorkbook(){[Name="trackme"]}[Content],
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Group Name", type text}, {"Channel/CC", type text}, {"Employee Name", type text}, {"Email", type text}, {"RCM", type text}, {"Supervisor", type text}, {"Second Supervisor", type text}, {"Outbound Tracking Number", type text}, {"URL", type text}}),
        #"Added Custom" = Table.AddColumn(#"Changed Type", "Fedex", each fxtrack([URL])),
        #"Removed Errors" = Table.RemoveRowsWithErrors(#"Added Custom", {"Fedex"}),
        #"Added Custom1" = Table.AddColumn(#"Removed Errors", "Custom", each try [Fedex]),
        #"Expanded Custom" = Table.ExpandRecordColumn(#"Added Custom1", "Custom", {"Value"}, {"Custom.Value"}),
        #"Expanded Custom.Value" = Table.ExpandTableColumn(#"Expanded Custom", "Custom.Value", {"Date/Time", "Activity", "Location", "Details"}, {"Custom.Value.Date/Time", "Custom.Value.Activity", "Custom.Value.Location", "Custom.Value.Details"}),
        #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom.Value",{"Fedex"}),
        #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom.Value.Activity", "Activity"}, {"Custom.Value.Location", "Location"}, {"Custom.Value.Details", "Details"}}),
        #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Custom.Value.Date/Time", type datetime}}),
        #"Renamed Columns1" = Table.RenameColumns(#"Changed Type1",{{"Custom.Value.Date/Time", "Date/Time"}})
    in
        #"Renamed Columns1";

    Thursday, September 27, 2018 4:55 AM

Answers

  • Hm. This one could be difficult to track down. Would it be possible for you to share a workbook that reproduces the problem (minus any sensitive data you're not willing to share)?

    One thing you could try would be to add a delay to each page request. For example:

    Source = Function.InvokeAfter(() => Web.Page(Web.Contents(MyURL)), #duration(0,0,0,2)),

    Ehren

    Wednesday, October 17, 2018 5:31 PM
    Owner

All replies

  • Hi there. What version of PQ are you using?

    Ehren

    Monday, October 1, 2018 7:29 PM
    Owner
  • hello. 

    thanks for the reply. I am using power query in excel 16.

    Wednesday, October 17, 2018 2:54 PM
  • Hm. This one could be difficult to track down. Would it be possible for you to share a workbook that reproduces the problem (minus any sensitive data you're not willing to share)?

    One thing you could try would be to add a delay to each page request. For example:

    Source = Function.InvokeAfter(() => Web.Page(Web.Contents(MyURL)), #duration(0,0,0,2)),

    Ehren

    Wednesday, October 17, 2018 5:31 PM
    Owner