search

FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
159 stars 65 forks source link

DDEX crashes Visual studio [DNET598] #562

Closed firebird-automations closed 9 years ago

firebird-automations commented 9 years ago

Submitted by: Sergey Isupov (kism)

I'm trying to create table adapter wiht the following query:

select http://i.ID, count(C.ID_LEGAL_PERSON) as CLIENT_COUNT, sum(ceil(a.symbols_count / e.STRING_LENGTH)) as SYMBOLS_COUNT, sum(p.issue_sum) as TOTAL_SUM, count(http://a.id) as ADS_COUNT from ISSUE I inner join ISSUE_ADS IA on http://I.ID = IA.ID_ISSUE inner join ADS A on IA.ID_ADS = http://A.ID inner join "Client" C on A.C_ID = C.ID_LEGAL_PERSON inner join PAYMENT P on http://P.id = ia.id_payment inner join Edition e on http://e.ID = i.ID_EDITION where http://I.ID = @ID_ISSUE and C.ID_SOURCE = @ID_SOURCE and http://e.id = @id_edition group by 1

On the last step after clicking "Finish" button Visual Studio crashes and restarts.

-------------------------System logs--------------------------- Application: devenv.exe Platform version: v4.0.30319 Exception: System.AccessViolationException Stack: в Microsoft.VisualStudio.Data.Interop.IVsDataObjectChangeEvents.OnObjectAdded(System.String, System.Object[]) в Microsoft.VisualStudio.DataTools.DataServices.DataConnection+DataObjectChangeEvents.OnObjectAdded(Microsoft.VisualStudio.Data.DataObjectChangedEventArgs) в Microsoft.VisualStudio.Data.Compatibility.OldObjectChangeEvents.<Microsoft.VisualStudio.Data.Compatibility.IVsDataCompatibleObject<Microsoft.VisualStudio.Data.Services.IVsDataObjectChangeEvents>.set_CompatibleObject>b__1(System.Object, Microsoft.VisualStudio.Data.Services.DataObjectAddedEventArgs) в System.EventHandler`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].Invoke(System.Object, System.__Canon) в Microsoft.VisualStudio.Data.Package.DataObjectChangeEvents.OnObjectAdded(Microsoft.VisualStudio.Data.Services.DataObjectAddedEventArgs) в Microsoft.VisualStudio.Data.Package.DataObjectChangeEvents.EndEventGroup(Int32) в Microsoft.VisualStudio.Data.Package.DataObjectStore+Tree.RaisePendingObjectChangeEvents() в Microsoft.VisualStudio.Data.Package.DataObjectStore.SelectObjects(System.String, System.Object[], System.String[], System.String, System.String, Boolean) в Microsoft.VisualStudio.Data.Package.DataMappedObjectSelector.SelectMappedObjects[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.String, System.Object[], Boolean) в Microsoft.VisualStudio.Data.Package.DataMappedObjectSelector.SelectMappedObjects[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Object[], Boolean) в Microsoft.VisualStudio.DataTools.MetaData.Generic.MetaDataEnumerator.Microsoft.VisualStudio.DataTools.MetaData.Interop.IMetaDataEnumerator.EnumerateTables(System.String, System.String, System.String, Boolean) в Microsoft.VisualStudio.DataTools.Interop.ICQryAuto.set_NewSQLText(System.String) в Microsoft.VSDesigner.Data.VS.QueryEditor.set_CommandText(System.String) в Microsoft.VSDesigner.Data.VS.QueryEditor..ctor(Microsoft.VSDesigner.Data.ConfigurationContext, System.String) в Microsoft.VSDesigner.DataSource.DbSource.GetDataSource(Microsoft.VSDesigner.DataSource.DbSourceCommand, Microsoft.VSDesigner.Data.ConfigurationContext) в Microsoft.VSDesigner.DataSource.DbSource.UpdateDbObjectInfo() в Microsoft.VSDesigner.DataSource.DbSource.get_DbObjectType() в Microsoft.VSDesigner.DataSource.DesignDataSource.Get1TableBasedDesignTables() в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.GetRelatedRelationsFromDb(Microsoft.VSDesigner.DataSource.DesignTable) в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.ExecCmdAddRadTable() в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.OnCmdAddRadTable(System.Object, System.EventArgs) в System.ComponentModel.Design.MenuCommand.Invoke() в Microsoft.VSDesigner.DesignerFramework.VSMenuCommand.Invoke() в System.ComponentModel.Design.MenuCommand.Invoke(System.Object) в Microsoft.VisualStudio.Shell.OleMenuCommandService.Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.Exec(System.Guid ByRef, UInt32, UInt32, IntPtr, IntPtr) в Microsoft.VisualStudio.Shell.Interop.IVsUIDataSource.Invoke(System.String, System.Object, System.Object ByRef) в Microsoft.Internal.VisualStudio.PlatformUI.DataSource.Invoke(System.String, System.Object, System.Object ByRef) в Microsoft.VisualStudio.PlatformUI.VsCommand.Execute(System.Object) в MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(System.Windows.Input.ICommandSource, Boolean) в System.Windows.Controls.MenuItem.InvokeClickAfterRender(System.Object) в System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) в MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) в System.Windows.Threading.DispatcherOperation.InvokeImpl() в System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(System.Object) в System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) в System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) в System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) в System.Windows.Threading.DispatcherOperation.Invoke() в System.Windows.Threading.Dispatcher.ProcessQueue() в System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) в MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) в MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object) в System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) в MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) в System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32) в MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr) в Microsoft.VisualStudio.PlatformUI.NativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef) в Microsoft.VisualStudio.Platform.WindowManagement.WindowManagerService.<PushMessageLoopOnContextMenuTrackingComponent>b__6b(System.Object, Microsoft.VisualStudio.PlatformUI.OleComponentSupport.PreTranslateMessageEventArgs) в Microsoft.VisualStudio.PlatformUI.OleComponentSupport.OleComponent.FPreTranslateMessageCore(Microsoft.VisualStudio.OLE.Interop.MSG[]) в Microsoft.VisualStudio.PlatformUI.OleComponentSupport.OleComponent+<>c__DisplayClasse.<Microsoft.VisualStudio.OLE.Interop.IOleComponent.FPreTranslateMessage>b__d() в Microsoft.VisualStudio.PlatformUI.OleComponentSupport.OleComponent.CallAndReturnOnException(System.Func`1<Int32>, Int32) в Microsoft.VisualStudio.PlatformUI.OleComponentSupport.OleComponent.Microsoft.VisualStudio.OLE.Interop.IOleComponent.FPreTranslateMessage(Microsoft.VisualStudio.OLE.Interop.MSG[]) в Microsoft.VisualStudio.OLE.Interop.IOleComponentManager.FPushMessageLoop(UInt32, UInt32, IntPtr) в Microsoft.VisualStudio.Platform.WindowManagement.WindowManagerService.PushMessageLoopOnContextMenuTrackingComponent() в Microsoft.VisualStudio.Shell.Interop.IOleComponentUIManager.ShowContextMenu(UInt32, System.Guid ByRef, Int32, Microsoft.VisualStudio.Shell.Interop.POINTS[], Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget) в Microsoft.VisualStudio.Shell.OleMenuCommandService.ShowContextMenu(System.ComponentModel.Design.CommandID, Int32, Int32) в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner.OnContextMenu(Int32, Int32) в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner.WmContextMenu(System.Windows.Forms.Message ByRef) в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner.WndProc(System.Windows.Forms.Message ByRef) в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner+VSRootDesignerWindowTarget.OnMessage(System.Windows.Forms.Message ByRef) в System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef) в System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr) в System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr) в System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef) в System.Windows.Forms.Control.DefWndProc(System.Windows.Forms.Message ByRef) в System.Windows.Forms.Control.WmMouseUp(System.Windows.Forms.Message ByRef, System.Windows.Forms.MouseButtons, Int32) в System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef) в System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef) в System.Windows.Forms.ContainerControl.WndProc(System.Windows.Forms.Message ByRef) в System.Windows.Forms.UserControl.WndProc(System.Windows.Forms.Message ByRef) в System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef) в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner+VSRootDesignerWindowTarget.DefWndProc(System.Windows.Forms.Message ByRef) в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner.WndProc(System.Windows.Forms.Message ByRef) в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner+VSRootDesignerWindowTarget.OnMessage(System.Windows.Forms.Message ByRef) в System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef) в System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)

firebird-automations commented 9 years ago

Commented by: André Ziegler (andre.ziegler)

make sure no other Firebird provider entries are in machine.config:

DNET560

firebird-automations commented 9 years ago

Commented by: @cincuranet

I don't see anything related to provider. Am I missing something?

firebird-automations commented 9 years ago
Modified by: @cincuranet status: Open \[ 1 \] =\> In Progress \[ 3 \]
firebird-automations commented 9 years ago
Modified by: @cincuranet status: In Progress \[ 3 \] =\> Closed \[ 6 \] resolution: Incomplete \[ 4 \]