locked
CRM 4.0 to CRM 2011 migration. After upgrade to 2011 there are errors in menu Customization -> Entity -> Fields, Forms, Views etc RRS feed

  • Question

  • After upgrade to 2011 there are errors in menu Customization -> Customize system -> Components -> Entity -> Fields, Forms, Views etc. When I want to see fiields, forms, views and other (but not all, I don't know why) there is an error:

    [2011-09-05 11:15:19.347] Process: w3wp |Organization:73b26af9-a07b-de11-94f0-00304886c434 |Thread:   17 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | SysCustomizationGridDataProvider.LoadData
    > *** MSCRM:ASSERTEX *** - Must have at least one sort column defined to sort.
    [2011-09-05 11:15:19.832] Process: w3wp |Organization:73b26af9-a07b-de11-94f0-00304886c434 |Thread:   17 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError
    >MSCRM Error Report:
    --------------------------------------------------------------------------------------------------------
    Error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

    Error Message: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Error Details: Exception of type 'System.Web.HttpUnhandledException' was thrown.

    Source File: Not available

    Line Number: Not available

    Request URL: http://srvcrm:5555/CentrumSystemwKomputerowychZET/tools/systemcustomization/Attributes/attributeList.aspx?appSolutionId=%7bFD140AAF-4DF4-11DD-BD17-0019B9312238%7d&entityId=%7b70816501-EDB9-4740-A16C-6A5EFBC05D84%7d&pagemode=iframe

     

    Stack Trace Info: [NullReferenceException: Object reference not set to an instance of an object.]
      

    at Microsoft.Crm.Application.Controls.SystemCustomization.SysCustomizationGridDataProvider.RowComparer.Compare(Object obj1, Object obj2)
       at System.Array.SorterObjectArray.SwapIfGreaterWithItems(Int32 a, Int32 b)

    [InvalidOperationException: Failed to compare two elements in the array.]
      
    at System.Array.SorterObjectArray.SwapIfGreaterWithItems(Int32 a, Int32 b)
       at System.Array.SorterObjectArray.QuickSort(Int32 left, Int32 right)
       at System.Array.Sort(Array keys, Array items, Int32 index, Int32 length, IComparer comparer)
       at System.Array.Sort(Array array, IComparer comparer)
       at Microsoft.Crm.Application.Controls.SystemCustomization.SysCustomizationGridDataProvider.LoadData()
       at Microsoft.Crm.Application.Controls.GridUIProvider.PrepareGridData()
       at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output)
       at ASP.centrumsystemwkomputerowychzet_tools_systemcustomization_attributes_attributelist_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in http://server/CentrumSystemwKomputerowychZET/tools/systemcustomization/Attributes/attributeList.aspx:line 20
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.Page.Render(HtmlTextWriter writer)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.centrumsystemwkomputerowychzet_tools_systemcustomization_attributes_attributelist_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\root\82ce50f4\e77f4ed8\App_Web_oaj250jm.1.cs:line 0
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


    [2011-09-05 11:15:19.957] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   17 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ExceptionConverter.ConvertMessageAndErrorCode
    >System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error.
    Reference number for administrators or support: #CCD8ABBE:
    System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidOperationException:
    Failed to compare two elements in the array. ---> System.NullReferenceException: Object reference not set to an instance of an object.
    >   at Microsoft.Crm.Application.Controls.SystemCustomization.SysCustomizationGridDataProvider.RowComparer.Compare(Object obj1, Object obj2)
    >   at System.Array.SorterObjectArray.SwapIfGreaterWithItems(Int32 a, Int32 b)
    >   --- End of inner exception stack trace ---
    >   at System.Array.SorterObjectArray.SwapIfGreaterWithItems(Int32 a, Int32 b)
    >   at System.Array.SorterObjectArray.QuickSort(Int32 left, Int32 right)
    >   at System.Array.Sort(Array keys, Array items, Int32 index, Int32 length, IComparer comparer)
    >   at System.Array.Sort(Array array, IComparer comparer)
    >   at Microsoft.Crm.Application.Controls.SystemCustomization.SysCustomizationGridDataProvider.LoadData()
    >   at Microsoft.Crm.Application.Controls.GridUIProvider.PrepareGridData()
    >   at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)
    >   at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output)
    >   at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output)
    >   at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output)
    >   at ASP.centrumsystemwkomputerowychzet_tools_systemcustomization_attributes_attributelist_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in http://server/CentrumSystemwKomputerowychZET/tools/systemcustomization/Attributes/attributeList.aspx:line 20
    >   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
    >   at System.Web.UI.Page.Render(HtmlTextWriter writer)
    >   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    >   at System.Web.UI.Page.HandleError(Exception e)
    >   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    >   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    >   at System.Web.UI.Page.ProcessRequest()
    >   at System.Web.UI.Page.ProcessRequest(HttpContext context)
    >   at ASP.centrumsystemwkomputerowychzet_tools_systemcustomization_attributes_attributelist_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\root\82ce50f4\e77f4ed8\App_Web_oaj250jm.1.cs:line 0
    >   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    >   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    [2011-09-05 11:15:19.972] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   17 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ExceptionConverter.ConvertMessageAndErrorCode
    >System.InvalidOperationException: Microsoft Dynamics CRM has experienced an error.

    Reference number for administrators or support: #9C726DE2: System.InvalidOperationException: Failed to compare two elements in the array. ---> System.NullReferenceException: Object reference not set to an instance of an object.
    >   at Microsoft.Crm.Application.Controls.SystemCustomization.SysCustomizationGridDataProvider.RowComparer.Compare(Object obj1, Object obj2)
    >   at System.Array.SorterObjectArray.SwapIfGreaterWithItems(Int32 a, Int32 b)
    >   --- End of inner exception stack trace ---
    >   at System.Array.SorterObjectArray.SwapIfGreaterWithItems(Int32 a, Int32 b)
    >   at System.Array.SorterObjectArray.QuickSort(Int32 left, Int32 right)
    >   at System.Array.Sort(Array keys, Array items, Int32 index, Int32 length, IComparer comparer)
    >   at System.Array.Sort(Array array, IComparer comparer)
    >   at Microsoft.Crm.Application.Controls.SystemCustomization.SysCustomizationGridDataProvider.LoadData()
    >   at Microsoft.Crm.Application.Controls.GridUIProvider.PrepareGridData()
    >   at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)
    >   at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output)
    >   at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output)
    >   at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output)
    >   at ASP.centrumsystemwkomputerowychzet_tools_systemcustomization_attributes_attributelist_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in http://server/CentrumSystemwKomputerowychZET/tools/systemcustomization/Attributes/attributeList.aspx:line 20
    >   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
    >   at System.Web.UI.Page.Render(HtmlTextWriter writer)
    >   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    Knows anybody why? I'll be gratefull for help.

    Tuesday, September 6, 2011 5:56 AM

Answers

  • I have experienced the same problem and found that it is because of there is a saved query in the database that doesn't contain a definition for which columns should be returned. At the moment I have updated the saved query table for the query with name 'Attributter' to be <columnset><ascend>schemaname</ascend></columnset>. I looked up this value on a blank organisation that was working correctly. Note that I am working with a Norwegian base language so the name is probably Attributes in English.

    I will now contact Microsoft and see what they advise. It is hard to believe that there haven't been more problems with the upgrade.

     

    Anyway, good luck,

    Neil Marston

    • Marked as answer by MScrm CRM Monday, November 7, 2011 7:52 AM
    Wednesday, November 2, 2011 10:46 AM

All replies

  • I have experienced the same problem and found that it is because of there is a saved query in the database that doesn't contain a definition for which columns should be returned. At the moment I have updated the saved query table for the query with name 'Attributter' to be <columnset><ascend>schemaname</ascend></columnset>. I looked up this value on a blank organisation that was working correctly. Note that I am working with a Norwegian base language so the name is probably Attributes in English.

    I will now contact Microsoft and see what they advise. It is hard to believe that there haven't been more problems with the upgrade.

     

    Anyway, good luck,

    Neil Marston

    • Marked as answer by MScrm CRM Monday, November 7, 2011 7:52 AM
    Wednesday, November 2, 2011 10:46 AM
  • Thank you for your answer. I have made the same correction - it is OK. I have changed also in this way fields "ColumnSetXML" and "layoutXML" in another saved queries (for FORMS, VIEWS and RELATIONS) for entities customization - there were errors too.

    I am working with Polish version. Of course there are another problems too - see my other threads in this subject.

    Greetings

    Tomasz Stanaszek

    Wednesday, November 2, 2011 2:46 PM
  • Hi sorry I have the same error and I could not fix it, can you give me more instructions?
    Saturday, November 12, 2011 7:21 PM
  • I had same problem and this answer was really helpful to find the solution. I had one working environment with English base language which I compared to not working Finnish version.

    Following query helped me to find all broken rows and copy pasting the correct definition to columnsetxml field fixed the errors. Remember to restart your web application after the changes to get rid of those nasty errors.

    SELECT     *
    FROM         SavedQuery
    WHERE     (FetchXml IS NULL) AND (ColumnSetXml IS NULL)

    Monday, December 12, 2011 11:57 AM