locked
Error when filtered data at power pivot RRS feed

  • Question

  • See the end of this message for details on invoking 
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.AnalysisServices.Common.TableWidgetHeaderSortFilterControl.FocusFirstOrHeaderCell()
       at Microsoft.AnalysisServices.Common.TableWidgetHeaderSortFilterControl.ShowCustomFilterDialog(ToolStripItem menuItem)
       at Microsoft.AnalysisServices.Common.TableWidgetHeaderSortFilterControl.menuStrip_ItemClicked(Object sender, ToolStripItemClickedEventArgs e)
       at System.Windows.Forms.ToolStripDropDownItem.OnDropDownItemClicked(ToolStripItemClickedEventArgs e)
       at System.Windows.Forms.ToolStripDropDownItem.DropDown_ItemClicked(Object sender, ToolStripItemClickedEventArgs e)
       at System.Windows.Forms.ToolStrip.OnItemClicked(ToolStripItemClickedEventArgs e)
       at System.Windows.Forms.ToolStripDropDown.OnItemClicked(ToolStripItemClickedEventArgs e)
       at System.Windows.Forms.ToolStrip.HandleItemClick(ToolStripItem dismissingItem)
       at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
       at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
       at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
       at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
       at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
       at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.ToolStrip.WndProc(Message& m)
       at System.Windows.Forms.ToolStripDropDown.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)


    ************** Loaded Assemblies **************

    mscorlib
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    ----------------------------------------

    Microsoft.Office.PowerPivot.ExcelAddIn
        Assembly Version: 11.0.0.0
        Win32 Version: 2011.0110.2809.27 ((BI_O15_OfficeBox).120824-1607)
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Office.PowerPivot.ExcelAddIn.dll
    ----------------------------------------

    Microsoft.Office.Interop.Excel
        Assembly Version: 15.0.0.0
        Win32 Version: 15.0.4641.1001
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/15.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
    ----------------------------------------
    office
        Assembly Version: 15.0.0.0
        Win32 Version: 15.0.4641.1002
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/office/15.0.0.0__71e9bce111e9429c/office.dll
    ----------------------------------------
    Microsoft.AnalysisServices.XLHost.Modeler
        Assembly Version: 11.0.0.0
        Win32 Version: 11.0.2809.27 ((BI_O15_OfficeBox).120824-1656 )
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.XLHost.Modeler.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Excel.BackEnd
        Assembly Version: 11.0.0.0
        Win32 Version: 2011.0110.2809.27 ((BI_O15_OfficeBox).120824-1607)
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.BackEnd.DLL
    ----------------------------------------
    System
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    Microsoft.AnalysisServices.Common
        Assembly Version: 11.0.0.0
        Win32 Version: 11.0.2809.27 ((BI_O15_OfficeBox).120824-1656 )
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Common.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Excel.Common.FrontEnd
        Assembly Version: 11.0.0.0
        Win32 Version: 2011.0110.2809.27 ((BI_O15_OfficeBox).120824-1607)
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.Common.FrontEnd.DLL
    ----------------------------------------
    PresentationFramework
        Assembly Version: 3.0.0.0
        Win32 Version: 3.0.6920.5011 built by: Win7SP1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/PresentationFramework/3.0.0.0__31bf3856ad364e35/PresentationFramework.dll
    ----------------------------------------
    WindowsBase
        Assembly Version: 3.0.0.0
        Win32 Version: 3.0.6920.5011 built by: Win7SP1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
    ----------------------------------------
    PresentationCore
        Assembly Version: 3.0.0.0
        Win32 Version: 3.0.6920.5011 built by: Win7SP1
        CodeBase: file:///C:/Windows/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Core
        Assembly Version: 3.5.0.0
        Win32 Version: 3.5.30729.5420 built by: Win7SP1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
    ----------------------------------------
    Microsoft.Data.Recommendation.Client.Picasso
        Assembly Version: 11.0.0.0
        Win32 Version: 11.0.2809.27 ((BI_O15_OfficeBox).120824-1656 )
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Client.Picasso.DLL
    ----------------------------------------
    Microsoft.Data.Recommendation.Client.Core
        Assembly Version: 11.0.0.0
        Win32 Version: 2011.0110.2809.27 ((BI_O15_OfficeBox).120824-1607)
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Client.Core.DLL
    ----------------------------------------
    Microsoft.Data.Recommendation.Common
        Assembly Version: 11.0.0.0
        Win32 Version: 2011.0110.2809.27 ((BI_O15_OfficeBox).120824-1607)
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Common.DLL
    ----------------------------------------
    System.Configuration
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    Microsoft.AnalysisServices.Excel.BackEnd.XmlSerializers
        Assembly Version: 11.0.0.0
        Win32 Version: 2011.0110.2809.27 ((BI_O15_OfficeBox).120824-1607)
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.BackEnd.XmlSerializers.dll
    ----------------------------------------
    System.Data
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Web
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
    ----------------------------------------
    kxsx0f_d
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Xml.Linq
        Assembly Version: 3.5.0.0
        Win32 Version: 3.5.30729.5420 built by: Win7SP1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll
    ----------------------------------------
    wnpf-ytm
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    obyzvsot
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    y8zky0sr
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    5eevylst
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    e3honmzg
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    mzshdta-
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    8e5_limn
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    asfijzsb
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    fchrk3r2
        Assembly Version: 11.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    Microsoft.Office.Excel.DataModel
        Assembly Version: 15.0.0.0
        Win32 Version: 15.0.4420.1017
        CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/Microsoft%20Shared/OFFICE15/DataModel/Microsoft.Office.Excel.DataModel.dll
    ----------------------------------------
    Microsoft.Excel.Amo
        Assembly Version: 11.0.0.0
        Win32 Version: 11.0.2809.27 ((BI_O15_OfficeBox).120824-1656 )
        CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/Microsoft%20Shared/OFFICE15/DataModel/Microsoft.Excel.Amo.DLL
    ----------------------------------------
    Microsoft.Excel.AdomdClient
        Assembly Version: 11.0.0.0
        Win32 Version: 11.0.2809.27 ((BI_O15_OfficeBox).120824-1656 )
        CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/Microsoft%20Shared/OFFICE15/DataModel/Microsoft.Excel.AdomdClient.DLL
    ----------------------------------------
    System.Runtime.Serialization
        Assembly Version: 3.0.0.0
        Win32 Version: 3.0.4506.5420 (Win7SP1.030729-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Serialization/3.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
    ----------------------------------------
    WindowsFormsIntegration
        Assembly Version: 3.0.0.0
        Win32 Version: 3.0.6920.4902 built by: NetFXw7
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsFormsIntegration/3.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
    ----------------------------------------
    Microsoft.DataWarehouse
        Assembly Version: 11.0.0.0
        Win32 Version: 11.0.2809.27 ((BI_O15_OfficeBox).120824-1656 )
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.DataWarehouse.DLL
    ----------------------------------------
    Microsoft.SqlServer.Configuration.SString
        Assembly Version: 11.0.0.0
        Win32 Version: 11.0.2809.27 ((BI_O15_OfficeBox).120824-1656 )
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.SqlServer.Configuration.SString.DLL
    ----------------------------------------
    SMDiagnostics
        Assembly Version: 3.0.0.0
        Win32 Version: 3.0.4506.5420 (Win7SP1.030729-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/SMDiagnostics/3.0.0.0__b77a5c561934e089/SMDiagnostics.dll
    ----------------------------------------
    Microsoft.Data.Recommendation.Client.Picasso.Sampler
        Assembly Version: 11.0.0.0
        Win32 Version: 2011.0110.2809.27 ((BI_O15_OfficeBox).120824-1607)
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Client.Picasso.Sampler.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Excel.Common.FrontEnd.XmlSerializers
        Assembly Version: 11.0.0.0
        Win32 Version: 2011.0110.2809.27 ((BI_O15_OfficeBox).120824-1607)
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.Common.FrontEnd.XmlSerializers.dll
    ----------------------------------------
    CustomMarshalers
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
        CodeBase: file:///C:/Windows/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.
    Wednesday, October 1, 2014 7:32 AM

Answers

All replies