Crash when ordering using aggreate column

[dhejov]

Plugin crashes when running a query using ordering on an aggregated column. Sample query:

<fetch top="50" aggregate="true" >
  <entity name="opportunity" >
    <attribute name="estimatedvalue" alias="Total" aggregate="sum" />
    <order alias="Total" />
    <link-entity name="account" from="accountid" to="customerid" >
      <attribute name="name" alias="acname" groupby="true" />
    </link-entity>
  </entity>
</fetch>

[rappen]

Just tried this, and it executed without problems.

What versions do you have:

• CRM
• XrmToolBox
• FetchXML Builder

[dhejov]

Hi, Following are the requested details: - CRM - Version 1612 (8.2.2.2062) (DB 8.2.2.1310) online - XrmToolBox - 1.2018.7.28 - FetchXML Builder - 1.2018.6.1 Please let me know if any additional details are needed. Regards Dhejo

…

On Sun, Sep 2, 2018 at 4:10 PM Jonas Rapp ***@***.***> wrote: Just tried this, and it executed without problems. [image: image] <https://user-images.githubusercontent.com/2572253/44960285-ec0bfb80-aefc-11e8-9bbd-293ba0255c9a.png> What versions do you have: - CRM - XrmToolBox - FetchXML Builder — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#219 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFBS6pf2Oou6mn4xcqagWMXUHbigL7eOks5uXDsxgaJpZM4WWTQX> .

-- With Regards, *Dhejo Vanissery*

[rappen]

I just had a friend try it on a CRM 8.2.2, and it worked there too.
What kind of "crash" are you experiencing? Any error message or something?

[dhejov]

Hi, Below is the exception text: ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at System.Object.GetType() at Cinteros.Xrm.CRMWinForm.CRMGridView.GetValueType(Object value) at Cinteros.Xrm.CRMWinForm.CRMGridView.PopulateColumnsFromEntities(EntityCollection entities, List`1 columns) at Cinteros.Xrm.CRMWinForm.CRMGridView.GetTableColumns(EntityCollection entities) at Cinteros.Xrm.CRMWinForm.CRMGridView.Refresh() at Cinteros.Xrm.CRMWinForm.CRMGridView.set_DataSource(Object value) at Cinteros.Xrm.FetchXmlBuilder.DockControls.ResultGrid.SetData(QueryInfo queryinfo) at Cinteros.Xrm.FetchXmlBuilder.FetchXmlBuilder.<>c__DisplayClass102_0.<RetrieveMultiple>b__1(RunWorkerCompletedEventArgs completedargs) at XrmToolBox.Extensibility.Worker.<>c__DisplayClass4_0.<WorkAsync>b__0(Object s, RunWorkerCompletedEventArgs e) at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e) ************** Loaded Assemblies ************** mscorlib Assembly Version: 4.0.0.0 Win32 Version: 4.7.3132.0 built by: NET472REL1LAST CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll ---------------------------------------- XrmToolBox Assembly Version: 1.2018.7.28 Win32 Version: 1.2018.7.28 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/XrmToolBox.exe ---------------------------------------- System.Core Assembly Version: 4.0.0.0 Win32 Version: 4.7.3160.0 built by: NET472REL1LAST_C CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System Assembly Version: 4.0.0.0 Win32 Version: 4.7.3151.0 built by: NET472REL1LAST_B CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- XrmToolBox.Extensibility Assembly Version: 1.2018.7.28 Win32 Version: 1.2018.7.28 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/XrmToolBox.Extensibility.DLL ---------------------------------------- System.Windows.Forms Assembly Version: 4.0.0.0 Win32 Version: 4.7.3056.0 built by: NET472REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 4.0.0.0 Win32 Version: 4.7.3056.0 built by: NET472REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- Microsoft.IdentityModel Assembly Version: 3.5.0.0 Win32 Version: 10.0.17134.1 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.IdentityModel/3.5.0.0__31bf3856ad364e35/Microsoft.IdentityModel.dll ---------------------------------------- System.IO.Compression.FileSystem Assembly Version: 4.0.0.0 Win32 Version: 4.7.3056.0 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IO.Compression.FileSystem/v4.0_4.0.0.0__b77a5c561934e089/System.IO.Compression.FileSystem.dll ---------------------------------------- XrmToolBox.PluginsStore Assembly Version: 1.2018.7.28 Win32 Version: 1.2018.7.28 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/XrmToolBox.PluginsStore.DLL ---------------------------------------- NuGet.Core Assembly Version: 2.14.0.832 Win32 Version: 2.14.0.832 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/NuGet.Core.DLL ---------------------------------------- Newtonsoft.Json Assembly Version: 11.0.0.0 Win32 Version: 11.0.2.21924 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/Newtonsoft.Json.DLL ---------------------------------------- McTools.Xrm.Connection Assembly Version: 1.2018.7.19 Win32 Version: 1.2018.7.19 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/McTools.Xrm.Connection.DLL ---------------------------------------- McTools.Xrm.Connection.WinForms Assembly Version: 1.2018.7.19 Win32 Version: 1.2018.7.19 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/McTools.Xrm.Connection.WinForms.DLL ---------------------------------------- Microsoft.Xrm.Sdk Assembly Version: 9.0.0.0 Win32 Version: 9.0.0002.0165 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/Microsoft.Xrm.Sdk.DLL ---------------------------------------- Microsoft.Xrm.Sdk.Workflow Assembly Version: 9.0.0.0 Win32 Version: 9.0.0002.0165 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/Microsoft.Xrm.Sdk.Workflow.DLL ---------------------------------------- Microsoft.Crm.Sdk.Proxy Assembly Version: 9.0.0.0 Win32 Version: 9.0.0002.0165 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/Microsoft.Crm.Sdk.Proxy.DLL ---------------------------------------- Microsoft.Xrm.Tooling.Connector Assembly Version: 3.0.0.0 Win32 Version: 3.0.0.931 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/Microsoft.Xrm.Tooling.Connector.DLL ---------------------------------------- Microsoft.IdentityModel.Clients.ActiveDirectory Assembly Version: 2.29.0.1078 Win32 Version: 2.29.40822.1520 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/Microsoft.IdentityModel.Clients.ActiveDirectory.DLL ---------------------------------------- Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms Assembly Version: 2.29.0.1078 Win32 Version: 2.29.40822.1520 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms.DLL ---------------------------------------- WeifenLuo.WinFormsUI.Docking Assembly Version: 3.0.4.0 Win32 Version: 3.0.4.0 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/WeifenLuo.WinFormsUI.Docking.DLL ---------------------------------------- WeifenLuo.WinFormsUI.Docking.ThemeVS2015 Assembly Version: 3.0.4.0 Win32 Version: 3.0.4.0 CodeBase: file:///D:/Dhejo/Tools/XrmToolbox/WeifenLuo.WinFormsUI.Docking.ThemeVS2015.DLL ---------------------------------------- System.Configuration Assembly Version: 4.0.0.0 Win32 Version: 4.7.3056.0 built by: NET472REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 4.0.0.0 Win32 Version: 4.7.3056.0 built by: NET472REL1 Regards Dhejo

…

On Mon, Sep 3, 2018 at 11:27 AM Jonas Rapp ***@***.***> wrote: I just had a friend try it on a CRM 8.2.2, and it worked there too. What kind of "crash" are you experiencing? Any error message or something? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#219 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFBS6tX4FjPgFx0tKWjsq_klUtni7sxrks5uXUpygaJpZM4WWTQX> .

-- With Regards, *Dhejo Vanissery*

[rappen]

Thanks - I have now identified the error, if occurs:
IF the aggregated value (est rev) is NULL
AND checkbox Friendly Names is not checked

Now you know how to get around it, and I know what needs to be fixed :)

[dhejov]

Hi Thanks for sharing the details. Happy I could be of help you. Big thanks for all the contributions you are making to the community. Regards Dhejo

…

On Sep 4, 2018 3:16 AM, "Jonas Rapp" ***@***.***> wrote: Thanks - I have now identified the error, if occurs: IF the aggregated value (est rev) is NULL AND checkbox Friendly Names is not checked Now you know how to get around it, and I know what needs to be fixed :) — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#219 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFBS6kJIUPjPrHlpzKoz2c7onjov5L9Uks5uXijegaJpZM4WWTQX> .

[rappen]

Thank you @dhejov - keeping this issue open until related issue in CRMWinForm repo is closed.