You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)
The text was updated successfully, but these errors were encountered:
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)
The text was updated successfully, but these errors were encountered: