DDEX crashes Visual studio
--------------------------
Key: DNET-598
URL: http://tracker.firebirdsql.org/browse/DNET-598
Project: .NET Data provider
Issue Type: Bug
Components: DDEX Provider
Affects Versions: 4.6.1.0
Environment: Windows 8 Pro, Visual Studio 2013 Pro, Firebird 2.5,
Version of firebird .net adapter is 4.6.1.0. DDEX 3.0.1.0
Reporter: Sergey Isupov
Assignee: Jiri Cincura
Priority: Critical
I'm trying to create table adapter wiht the following query:
select 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(a.id) as ADS_COUNT
from ISSUE I
inner join ISSUE_ADS IA on I.ID = IA.ID_ISSUE
inner join ADS A on IA.ID_ADS = A.ID
inner join "Client" C on A.C_ID = C.ID_LEGAL_PERSON
inner join PAYMENT P on P.id = ia.id_payment
inner join Edition e on e.ID = i.ID_EDITION
where I.ID = @ID_ISSUE and
C.ID_SOURCE = @ID_SOURCE and
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
