locked
Out of Memory when trying to delete columns or worksheet in PowerPivot RRS feed

  • Question

  • When trying to do a simple delete of a column, I get the following exception thrown.. I have only three tables imported, with around 50,000 rows each. 6GB Ram, Excel 32 bit...

    ============================
    Error Message:
    ============================

    Exception of type 'System.OutOfMemoryException' was thrown.

    ============================
    Call Stack:
    ============================

       at System.Text.StringBuilder.ToString()
       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteCaptureLogInBackground(OperationType type, Boolean cancellable, Boolean raiseEvents)
       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw, Boolean raiseEvents)
       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteAMOCode(OperationType type, OperationCancellability cancellable, AMOCode code, Boolean raiseEvents)
       at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitUpdates()
       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.CommitUpdates()
       at Microsoft.AnalysisServices.BackEnd.DataModelingView.RemoveColumns(List`1 items)
       at Microsoft.AnalysisServices.Common.TableWidgetGridControl.DeleteColumns(List`1 columnsToRemove)

    So, when I try to delete the worksheet involved, I get this... 

    Seems like I am stuck, and the only option would be to start the whole model again??

    Not as robust as I was expecting :/


    ============================
    Error Message:
    ============================

    Exception of type 'System.OutOfMemoryException' was thrown.
    ----------------------------
    Exception of type 'System.OutOfMemoryException' was thrown.

    ============================
    Call Stack:
    ============================

       at System.Text.StringBuilder.ToString()
       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteCaptureLogInBackground(OperationType type, Boolean cancellable, Boolean raiseEvents)
       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw, Boolean raiseEvents)
       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteAMOCode(OperationType type, OperationCancellability cancellable, AMOCode code, Boolean raiseEvents)
       at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitUpdates()
       at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitInternal(Boolean finalCommit)
    ----------------------------
       at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitInternal(Boolean finalCommit)
       at Microsoft.AnalysisServices.Common.SheetTabs.DeleteSheetFromSandbox(String key, Boolean isActive)

    ============================



    Monday, May 14, 2012 11:56 PM

Answers

  • I had this problem earlier. For my solution, I un-processed the cube. Then deleted the columns. 

    Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

    • Marked as answer by Josh Ashwood Thursday, May 17, 2012 10:19 AM
    Tuesday, May 15, 2012 4:25 PM

All replies

  • You might think that this is a silly question, but why would you want to delete a column from a table that is being used in a data model?
    Tuesday, May 15, 2012 11:53 AM
  • I had this problem earlier. For my solution, I un-processed the cube. Then deleted the columns. 

    Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

    • Marked as answer by Josh Ashwood Thursday, May 17, 2012 10:19 AM
    Tuesday, May 15, 2012 4:25 PM
  • You might think that this is a silly question, but why would you want to delete a column from a table that is being used in a data model?

    Requirements change, you may have previously imported a column you don't want anymore, boss changes requirements... 

    Or, just because you can :)


    Josh Ash

    Wednesday, May 16, 2012 10:37 PM