none
Attempted to read or write protected memory. This is often an indication that other memory is corrupt RRS feed

  • Question

  • Hi, I got this when attempting to load a very simple Power Query unpivot in Excel 2016 365 Pro.

    What does it mean?

    Stack Trace:
    
    System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
       at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsC2R.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.TryPromptForRange(String prompt, String title, String initialRangeText, String& rangeText, IntPtr& workbookPointer)
       at Microsoft.Mashup.Client.Excel.Shim.NativeApplicationServices.TryPromptForRange(IWin32Window ownerWindow, String initialRange, String& selectedRange, IWorkbook& workbook)
       at Microsoft.Mashup.Client.Excel.Shim.IApplicationServicesExtensions.TryPromptForRangeOnSameWorkbook(IApplicationServices applicationServices, IWin32Window ownerWindow, WindowsHost windowsHost, String initialRange, IWorkbook initialWorkbook, String& selectedRange)
       at Microsoft.Mashup.Client.Excel.LoadToDialog.Show(IWin32Window owner, WindowsHost windowsHost, ExcelServices excelServices, IWorkbook initialWorkbook, InitialFillTargets dataIn, Boolean allowExistingWorksheet, Boolean isDataModelSupported, Boolean workbookSupportsDataModel, Boolean showCancelConfirmation, Boolean promptOnSettingChanges, InitialFillTargets& dataOut)
       at Microsoft.Mashup.Client.Excel.DialogManager.ShowLoadToDialog(IWin32Window ownerWindow, InitialFillTargets startingTargets, Boolean allowExistingWorksheet, IWorkbook workbook, Boolean showCancelConfirmation, Boolean promptOnSettingChanges, InitialFillTargets& userTargets)
       at Microsoft.Mashup.Client.Excel.DialogManager.ShowLoadToDialog(IWin32Window ownerWindow, InitialFillTargets startingTargets, Boolean allowExistingWorksheet, IWorkbookIdentity workbookIdentity, Boolean showCancelConfirmation, InitialFillTargets& userTargets)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowLoadOptionsDialog(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, IEnumerable`1 queries, FillDefaults fillDefaults, InitialFillTargets& initialFillTargets)
       at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
       at Microsoft.Mashup.Client.Excel.DialogManager.AddExcelTable(IWin32Window ownerWindow, IWorkbook workbook, String tableName, String newQueryName)
       at Microsoft.Mashup.Client.Excel.DialogManager.AddExcelTable(IWindowContext windowContext, IWorkbook workbook)
       at Microsoft.Mashup.Client.Excel.Shim.IWindowContextExtensions.TryInvokeOnParentWorkbook(IWindowContext windowContext, Action`1 action)
       at Microsoft.Mashup.Client.Excel.NativeRibbonHandler.<>c__DisplayClass1.<OnRibbonButtonAction>b__0()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
    
    Invocation Stack Trace:
    
       at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
       at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.InvokeAndReturnHResult(Action action)
    
    

    Monday, February 13, 2017 10:14 AM

Answers

  • Hi,

    Thank you very much for your response.

    Can you please narrow down the problematic scenarios into a simple one? For example, do you have a synthetic example of dependent queries that causes the issue? Or is it just 2 dependent queries that trying to update them in parallel causes the issue?

    Dan.

    -Excel Team.

    Wednesday, April 19, 2017 2:00 PM

All replies

  • Hi,

    Thank you for reporting this issue.

    Unfortunately I cannot investigate the issue with the limited information you have sent.

    Can you provide us the following:

    1. Your Windows version.

    2. Your Excel version (go to File > Account > Product Information).

    3. Repro steps for what you were trying to do.

    4. Problematic workbook. Please make sure you don't share any sensitive information or details with us through your workbook. Scramble the data if there's a need to do that.

    Dan.

    -Excel Team

    Thursday, February 16, 2017 12:26 PM
  • Hi - 

    1. Your Windows version. 10 Home 1607 14393.953 64bit

    2. Your Excel version (go to File > Account > Product Information).

    1609 build 7369.2120

    3. Repro steps for what you were trying to do.

    It happens in many scenarios, mostly when more than one power query updating at the same time.  e.g. if the second is dependent on the first, both then never complete updating (just hangs)

    4. Problematic workbook. 

    I'm afraid I can't post in public

    Wednesday, March 22, 2017 2:17 PM
  • Hi,

    Thank you very much for your response.

    Can you please narrow down the problematic scenarios into a simple one? For example, do you have a synthetic example of dependent queries that causes the issue? Or is it just 2 dependent queries that trying to update them in parallel causes the issue?

    Dan.

    -Excel Team.

    Wednesday, April 19, 2017 2:00 PM