Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL to FetchXML conversion crashes the toolbox #384

Closed
zavurovm opened this issue Nov 6, 2023 · 6 comments · Fixed by #383
Closed

SQL to FetchXML conversion crashes the toolbox #384

zavurovm opened this issue Nov 6, 2023 · 6 comments · Fixed by #383

Comments

@zavurovm
Copy link

zavurovm commented Nov 6, 2023

Screenshot 2023-11-06 093727

Screenshot 2023-11-06 093545

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

************** Exception Text **************
System.ArgumentNullException: Key cannot be null.
Parameter name: key
at System.Collections.Hashtable.get_Item(Object key)
at MarkMpn.Sql4Cds.Engine.ExecutionPlan.ColumnList.get_Item(String key)
at MarkMpn.Sql4Cds.Engine.ExecutionPlan.ConcatenateNode.GetSchema(NodeCompilationContext context)
at MarkMpn.Sql4Cds.Engine.ExecutionPlanBuilder.ConvertBinaryQuery(BinaryQueryExpression binary, IList1 hints, INodeSchema outerSchema, Dictionary2 outerReferences, NodeCompilationContext context)
at MarkMpn.Sql4Cds.Engine.ExecutionPlanBuilder.ConvertSelectStatement(SelectStatement select)
at MarkMpn.Sql4Cds.Engine.ExecutionPlanBuilder.ConvertStatement(TSqlStatement statement, ExecutionPlanOptimizer optimizer, List1 queries) at MarkMpn.Sql4Cds.Engine.ExecutionPlanBuilder.Build(String sql, IDictionary2 parameters, Boolean& useTDSEndpointDirectly)
at MarkMpn.Sql4Cds.Engine.Sql4CdsCommand.GeneratePlan(Boolean compileForExecution)
at MarkMpn.Sql4Cds.XTB.PluginControl.fetchXMLToolStripMenuItem_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
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.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4645.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll

XrmToolBox
Assembly Version: 1.2023.10.67
Win32 Version: 1.2023.10.67
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/XrmToolBox.exe

CrowdStrike.Sensor.ScriptControl
Assembly Version: 7.3.17506.0
Win32 Version: 7.03.17506.0
CodeBase: file:///C:/WINDOWS/System32/CrowdStrike.Sensor.ScriptControl17506.dll

XrmToolBox.Extensibility
Assembly Version: 1.2023.10.67
Win32 Version: 1.2023.10.67
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/XrmToolBox.Extensibility.DLL

System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4654.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4650.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4390.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4662.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

Microsoft.IdentityModel
Assembly Version: 3.5.0.0
Win32 Version: 10.0.19041.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.8.4084.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.ToolLibrary
Assembly Version: 1.2023.10.67
Win32 Version: 1.2023.10.67
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/XrmToolBox.ToolLibrary.DLL

System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Newtonsoft.Json
Assembly Version: 13.0.0.0
Win32 Version: 13.0.2.27524
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Newtonsoft.Json.DLL

McTools.Xrm.Connection
Assembly Version: 1.2023.6.56
Win32 Version: 1.2023.6.56
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/McTools.Xrm.Connection.DLL

McTools.Xrm.Connection.WinForms
Assembly Version: 1.2023.6.56
Win32 Version: 1.2023.6.56
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/McTools.Xrm.Connection.WinForms.DLL

Microsoft.Xrm.Sdk
Assembly Version: 9.0.0.0
Win32 Version: 9.2.49.3165
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.Xrm.Sdk.DLL

Microsoft.Xrm.Sdk.Workflow
Assembly Version: 9.0.0.0
Win32 Version: 9.2.49.665
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.Xrm.Sdk.Workflow.DLL

Microsoft.Crm.Sdk.Proxy
Assembly Version: 9.0.0.0
Win32 Version: 9.2.49.3165
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.Crm.Sdk.Proxy.DLL

Microsoft.Xrm.Tooling.Connector
Assembly Version: 4.0.0.0
Win32 Version: 4.0.0.155
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.Xrm.Tooling.Connector.DLL

Microsoft.Xrm.Tooling.Ui.Styles
Assembly Version: 4.0.0.0
Win32 Version: 4.0.0.155
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.Xrm.Tooling.Ui.Styles.DLL

Microsoft.Xrm.Tooling.CrmConnectControl
Assembly Version: 4.0.0.0
Win32 Version: 4.0.0.155
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.Xrm.Tooling.CrmConnectControl.DLL

Microsoft.IdentityModel.Clients.ActiveDirectory
Assembly Version: 5.3.0.0
Win32 Version: 5.3.0.0
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.IdentityModel.Clients.ActiveDirectory.DLL

WeifenLuo.WinFormsUI.Docking
Assembly Version: 3.0.6.0
Win32 Version: 3.0.6.0
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/WeifenLuo.WinFormsUI.Docking.DLL

WeifenLuo.WinFormsUI.Docking.ThemeVS2015
Assembly Version: 3.0.6.0
Win32 Version: 3.0.6.0
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/WeifenLuo.WinFormsUI.Docking.ThemeVS2015.DLL

ScintillaNET
Assembly Version: 3.6.3.0
Win32 Version: 3.6.3.0
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/ScintillaNET.DLL

Microsoft.Web.WebView2.Core
Assembly Version: 1.0.1518.46
Win32 Version: 1.0.1518.46
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.Web.WebView2.Core.DLL

Microsoft.Web.WebView2.WinForms
Assembly Version: 1.0.1518.46
Win32 Version: 1.0.1518.46
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/Microsoft.Web.WebView2.WinForms.DLL

System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Design
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Design.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

System.Web
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4672.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

System.Net.Http
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll

System.Runtime.Serialization
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4536.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll

SMDiagnostics
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4536.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll

System.ServiceModel.Internals
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4536.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll

System.Xml.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll

McTools.StopAdvertisement
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/McTools.StopAdvertisement.DLL

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

System.ComponentModel.Composition
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.Composition/v4.0_4.0.0.0__b77a5c561934e089/System.ComponentModel.Composition.dll

System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4644.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

DamSim.SolutionTransferTool
Assembly Version: 1.2023.2.29
Win32 Version: 1.2023.2.29
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/DAMSIM.SOLUTIONTRANSFERTOOL.DLL

DamSim.ViewTransferTool
Assembly Version: 1.2019.11.4
Win32 Version: 1.2019.11.4
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/DAMSIM.VIEWTRANSFERTOOL.DLL

DSTools.MSSqlToCRMImport
Assembly Version: 1.0.4.0
Win32 Version: 1.0.4
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/DSTOOLS.MSSQLTOCRMIMPORT.DLL

GapConsulting.PowerBIOptionSetAssistant
Assembly Version: 1.2021.2.4
Win32 Version: 1.2021.2.4
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/GAPCONSULTING.POWERBIOPTIONSETASSISTANT.DLL

Javista.AttributesFactory
Assembly Version: 1.2023.2.33
Win32 Version: 1.2023.2.33
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/JAVISTA.ATTRIBUTESFACTORY.DLL

Javista.XrmToolBox.ImportNN
Assembly Version: 1.2022.12.12
Win32 Version: 1.2022.12.12
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/JAVISTA.XRMTOOLBOX.IMPORTNN.DLL

MarkMpn.Sql4Cds
Assembly Version: 7.6.1.0
Win32 Version: 7.6.1.0
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MARKMPN.SQL4CDS.DLL

MsCrmTools.AccessChecker
Assembly Version: 1.2022.3.6
Win32 Version: 1.2022.3.6
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ACCESSCHECKER.DLL

MsCrmTools.AssemblyRecoveryTool
Assembly Version: 1.2019.11.3
Win32 Version: 1.2019.11.3
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ASSEMBLYRECOVERYTOOL.DLL

MsCrmTools.AttributeBulkUpdater
Assembly Version: 1.2022.10.4
Win32 Version: 1.2022.10.4
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ATTRIBUTEBULKUPDATER.DLL

MscrmTools.AttributeNamingChecker
Assembly Version: 1.2020.6.0
Win32 Version: 1.2020.6.0
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ATTRIBUTENAMINGCHECKER.DLL

MscrmTools.AttributeUsageInspector
Assembly Version: 1.2018.9.11
Win32 Version: 1.2018.9.11
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ATTRIBUTEUSAGEINSPECTOR.DLL

MsCrmTools.AuditCenter
Assembly Version: 1.2019.11.2
Win32 Version: 1.2019.11.2
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.AUDITCENTER.DLL

MsCrmTools.ChartManager
Assembly Version: 1.2017.3.1
Win32 Version: 1.2017.3.1
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.CHARTMANAGER.DLL

System.ServiceModel
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4536.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll

MscrmTools.ComponentComparer
Assembly Version: 1.2022.6.4
Win32 Version: 1.2022.6.4
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.COMPONENTCOMPARER.DLL

MscrmTools.CrmTraceReader
Assembly Version: 1.2018.4.1
Win32 Version: 1.2018.4.1
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.CRMTRACEREADER.DLL

System.IdentityModel
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4536.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.dll

MsCrmTools.DocumentTemplatesMover
Assembly Version: 1.2020.2.4
Win32 Version: 1.2020.2.4
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.DOCUMENTTEMPLATESMOVER.DLL

MscrmTools.EmailAnonymizer
Assembly Version: 1.2019.12.1
Win32 Version: 1.2019.12.1
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.EMAILANONYMIZER.DLL

MscrmTools.EnvironmentProcessesComparer
Assembly Version: 1.2021.12.2
Win32 Version: 1.2021.12.2
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ENVIRONMENTPROCESSESCOMPARER.DLL

MscrmTools.EnvironmentVariableManager
Assembly Version: 1.2023.1.10
Win32 Version: 1.2022.1.10
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ENVIRONMENTVARIABLEMANAGER.DLL

MsCrmTools.FlsBulkUpdater
Assembly Version: 1.2016.12.1
Win32 Version: 1.2016.12.1
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.FLSBULKUPDATER.DLL

MsCrmTools.FormRelated
Assembly Version: 1.2021.11.4
Win32 Version: 1.2021.11.4
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.FORMRELATED.DLL

MsCrmTools.Iconator
Assembly Version: 1.2021.7.13
Win32 Version: 1.2021.7.13
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ICONATOR.DLL

MscrmTools.ManagedSolutionDeletionTool
Assembly Version: 1.2016.11.1
Win32 Version: 1.2016.11.1
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.MANAGEDSOLUTIONDELETIONTOOL.DLL

System.Text.Json
Assembly Version: 7.0.0.1
Win32 Version: 7.0.122.56804
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/System.Text.Json.DLL

MsCrmTools.MetadataBrowser
Assembly Version: 1.2023.10.26
Win32 Version: 1.2023.10.26
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.METADATABROWSER.DLL

MsCrmTools.MetadataDocumentGenerator
Assembly Version: 1.2022.12.7
Win32 Version: 1.2022.12.7
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.METADATADOCUMENTGENERATOR.DLL

MscrmTools.PolymorphicLookupCreator
Assembly Version: 1.2022.11.6
Win32 Version: 1.2022.11.6
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.POLYMORPHICLOOKUPCREATOR.DLL

MscrmTools.PortalCodeEditor
Assembly Version: 1.2023.10.18
Win32 Version: 1.2023.10.18
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.PORTALCODEEDITOR.DLL

MscrmTools.PortalRecordsMover
Assembly Version: 1.2022.11.33
Win32 Version: 1.2022.11.33
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.PORTALRECORDSMOVER.DLL

MsCrmTools.SampleTool
Assembly Version: 1.2018.6.23
Win32 Version: 1.2018.6.23
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SAMPLETOOL.DLL

MsCrmTools.ScriptsFinder
Assembly Version: 1.2023.7.18
Win32 Version: 1.2023.7.18
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SCRIPTSFINDER.DLL

MsCrmTools.SecurityRelated
Assembly Version: 1.2022.11.9
Win32 Version: 1.2022.11.9
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SECURITYRELATED.DLL

MsCrmTools.SiteMapEditor
Assembly Version: 1.2021.9.14
Win32 Version: 1.2021.9.14
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SITEMAPEDITOR.DLL

MsCrmTools.SolutionComponentsMover
Assembly Version: 1.2023.2.16
Win32 Version: 1.2023.2.16
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SOLUTIONCOMPONENTSMOVER.DLL

MsCrmTools.SolutionImport
Assembly Version: 1.2016.8.23
Win32 Version: 1.2016.8.23
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SOLUTIONIMPORT.DLL

MscrmTools.SolutionLayersExplorer
Assembly Version: 1.2023.10.20
Win32 Version: 1.2023.10.20
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SOLUTIONLAYERSEXPLORER.DLL

MscrmTools.SyncFilterManager
Assembly Version: 1.2022.5.5
Win32 Version: 1.2022.5.5
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SYNCFILTERMANAGER.DLL

MsCrmTools.SynchronousEventOrderEditor
Assembly Version: 1.2021.7.3
Win32 Version: 1.2021.7.3
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SYNCHRONOUSEVENTORDEREDITOR.DLL

MsCrmTools.Translator
Assembly Version: 1.2023.1.23
Win32 Version: 1.2023.1.23
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.TRANSLATOR.DLL

MsCrmTools.UserSettingsUtility
Assembly Version: 1.2023.9.25
Win32 Version: 1.2023.09.25
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.USERSETTINGSUTILITY.DLL

MscrmTools.UserViewsDisplaySettings
Assembly Version: 1.2022.4.2
Win32 Version: 1.2022.4.2
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.USERVIEWSDISPLAYSETTINGS.DLL

MsCrmTools.ViewLayoutReplicator
Assembly Version: 1.2023.10.14
Win32 Version: 1.2023.10.14
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.VIEWLAYOUTREPLICATOR.DLL

MscrmTools.WebresourcesManager
Assembly Version: 2.2023.9.24
Win32 Version: 2.2023.9.24
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.WEBRESOURCESMANAGER.DLL

Rappen.XTB.FXB
Assembly Version: 1.2023.8.2
Win32 Version: 1.2023.08.002
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/RAPPEN.XTB.FXB.DLL

WesHutton.EntityToTableScripter
Assembly Version: 1.0.0.5
Win32 Version: 1.0.0.5
CodeBase: file:///C:/USERS/ZAVUROVM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/WESHUTTON.ENTITYTOTABLESCRIPTER.DLL

System.Xaml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4662.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll

Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

PresentationFramework
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4662.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.dll

WindowsBase
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4662.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll

PresentationCore
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4662.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll

PresentationFramework.Aero2
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework.Aero2/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.Aero2.dll

PresentationFramework-SystemXml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemXml/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemXml.dll

UIAutomationTypes
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4662.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationTypes/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationTypes.dll

UIAutomationProvider
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4662.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationProvider/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationProvider.dll

PresentationFramework-SystemXmlLinq
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemXmlLinq/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemXmlLinq.dll

PresentationFramework-SystemCore
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemCore/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemCore.dll

System.Web.Services
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.Services/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll

Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 14.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll

System.Deployment
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4654.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll

System.Runtime.Caching
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4084.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Caching/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.Caching.dll

System.Security
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4261.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll

Microsoft.VisualStudio.Diagnostics.ServiceModelSink
Assembly Version: 4.0.0.0
Win32 Version: 17.0.118.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Diagnostics.ServiceModelSink/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Diagnostics.ServiceModelSink.dll

MarkMpn.Sql4Cds.XTB
Assembly Version: 7.6.1.0
Win32 Version: 7.6.1.0
CodeBase: file:///c:/users/zavurovm/appdata/roaming/mscrmtools/xrmtoolbox/plugins/MARKMPN.SQL4CDS/MarkMpn.Sql4Cds.XTB.dll

MarkMpn.Sql4Cds.Engine
Assembly Version: 7.6.1.0
Win32 Version: 7.6.1.0
CodeBase: file:///c:/users/zavurovm/appdata/roaming/mscrmtools/xrmtoolbox/plugins/MARKMPN.SQL4CDS/MarkMpn.Sql4Cds.Engine.DLL

Microsoft.ApplicationInsights
Assembly Version: 2.21.0.429
Win32 Version: 2.21.0.00429
CodeBase: file:///c:/users/zavurovm/appdata/roaming/mscrmtools/xrmtoolbox/plugins/MARKMPN.SQL4CDS/Microsoft.ApplicationInsights.DLL

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.SqlServer.TransactSql.ScriptDom
Assembly Version: 16.1.0.0
Win32 Version: 16.1.8834.0
CodeBase: file:///c:/users/zavurovm/appdata/roaming/mscrmtools/xrmtoolbox/plugins/MARKMPN.SQL4CDS/Microsoft.SqlServer.TransactSql.ScriptDom.DLL

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.8.4645.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

XrmToolBox.PluginsStore
Assembly Version: 1.2023.1.63
Win32 Version: 1.2023.1.63
CodeBase: file:///C:/Users/zavurovm/Desktop/XRM/XrmToolBox.PluginsStore.DLL

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.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:

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.

  • Deployment: Online
  • DB Version: 9.2.23094.232
  • Connection Controls Version: 1.2023.6.56
  • XrmToolBox Version: 1.2023.10.67
  • Tool Version: 7.6.1.0
@MarkMpn
Copy link
Owner

MarkMpn commented Nov 7, 2023

Can you include the full SQL query please?

@zavurovm
Copy link
Author

zavurovm commented Nov 8, 2023

@MarkMpn I think union is the issue. This sql executes in MSSQLSMS.

select top(10) *
from dcwp_fees
where dcwp_totalpaid = 0  
union
(
	select top(10) *
	from dcwp_fees
	where dcwp_balancedue > 0
)

@MarkMpn
Copy link
Owner

MarkMpn commented Nov 8, 2023

Thanks - yes, I’ve already found a bug with UNION and using SELECT *. This is already fixed in the next update I should be releasing soon, but in the meantime you should be able to get it to work by listing the individual columns instead of using *

@zavurovm
Copy link
Author

zavurovm commented Nov 8, 2023 •
edited
Loading

Yes, listing the fields works. Looking forward to the next release. Thanks!

@zavurovm
Copy link
Author

zavurovm commented Nov 8, 2023

Btw, is there a way to convert sql containing UNION to fetchXML ? The tool gives me two separate fetchXMLs.

@MarkMpn
Copy link
Owner

MarkMpn commented Nov 9, 2023

There's no direct equivalent of UNION in FetchXML. For some queries it's possible to get the same result by rewriting it as a join, but I don't think this is possible in your example.

@MarkMpn MarkMpn linked a pull request Nov 17, 2023 that will close this issue
CTEs #383
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

CTEs MarkMpn/Sql4Cds
2 participants
@MarkMpn @zavurovm