An unhandled exception has occurred in a component in your application

  • Hi all, i need help.. About SQL SERVER 2008, when I attempt to create query a notification shows like this

    |

    |

    V

    An unhandled exception has occurred in a component in your application. Click continue and application will ignore this error and attempt to continue. Object reference not set to an instance of an object.

    See the end of this message for details on invoking

    just-in-time (JIT) debugging instead of this dialog box.

    See the end of this message for details on invoking

    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************

    System.NullReferenceException: Object reference not set to an instance of an object.

    at Microsoft.SqlServer.Management.UI.VSIntegration.Sh ellCodeWindowControl.CreateCWWindow()

    at Microsoft.SqlServer.Management.UI.VSIntegration.Sh ellCodeWindowControl.OnHandleCreated(EventArgs a)

    at System.Windows.Forms.Control.WmCreate(Message& m)

    at System.Windows.Forms.Control.WndProc(Message& m)

    at Microsoft.SqlServer.Management.UI.VSIntegration.Sh ellTextEditorControl.WndProc(Message& m)

    at System.Windows.Forms.Control.ControlNativewindow.O nMessage(Message& m)

    at System.Windows.Forms.Control.ControlNativewindow.W ndProc(Message& m)

    at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    ************** Loaded Assemblies **************

    mscorlib

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4959 (win7RTMGDR.050727-4900)

    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

    ----------------------------------------

    AppIDPackage

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL

    ----------------------------------------

    Microsoft.SqlServer.SqlTools.VSIntegration

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL

    ----------------------------------------

    System

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4957 (win7RTMGDR.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

    ----------------------------------------

    Microsoft.VisualStudio.Shell.Interop

    Assembly Version: 7.1.40304.0

    Win32 Version: 7.10.6071

    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll

    ----------------------------------------

    Microsoft.VisualStudio.OLE.Interop

    Assembly Version: 7.1.40304.0

    Win32 Version: 7.10.6070

    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll

    ----------------------------------------

    System.Windows.Forms

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

    ----------------------------------------

    System.Drawing

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

    ----------------------------------------

    SqlWorkbench.Interfaces

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL

    ----------------------------------------

    Microsoft.SqlServer.SqlTDiagM

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll

    ----------------------------------------

    Microsoft.SqlServer.Instapi

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll

    ----------------------------------------

    Microsoft.SqlServer.Management.SDK.SqlStudio

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.DLL

    ----------------------------------------

    Microsoft.VisualStudio.Shell

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.1826 (QFE.050727-1800)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll

    ----------------------------------------

    Microsoft.VisualStudio.Shell.Interop.8.0

    Assembly Version: 8.0.0.0

    Win32 Version: 8.0.50727.1826 (QFE.050727-1800)

    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll

    ----------------------------------------

    SQLEditors

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL

    ----------------------------------------

    Microsoft.VisualStudio.TextManager.Interop

    Assembly Version: 7.1.40304.0

    Win32 Version: 7.10.6070

    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll

    ----------------------------------------

    SqlMgmt

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL

    ----------------------------------------

    Microsoft.SqlServer.Management.UserSettings

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UserSettings.DLL

    ----------------------------------------

    Microsoft.SqlServer.RegSvrEnum

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll

    ----------------------------------------

    System.Data

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

    ----------------------------------------

    Microsoft.SqlServer.ConnectionInfo

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll

    ----------------------------------------

    Microsoft.SqlServer.Management.Sdk.Sfc

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Sdk.Sfc/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Sdk.Sfc.dll

    ----------------------------------------

    Microsoft.SqlServer.Management.Reports

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Reports.DLL

    ----------------------------------------

    ObjectExplorer

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL

    ----------------------------------------

    Microsoft.VisualStudio

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.1826 built by: QFE

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll

    ----------------------------------------

    System.Drawing.Design

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll

    ----------------------------------------

    Microsoft.VisualStudio.Designer.Interfaces

    Assembly Version: 1.0.5000.0

    Win32 Version: 1.1.4322.573

    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll

    ----------------------------------------

    ConnectionDlg

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL

    ----------------------------------------

    Microsoft.SqlServer.Management.Controls

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Controls.DLL

    ----------------------------------------

    Accessibility

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

    ----------------------------------------

    Microsoft.SqlServer.Management.SqlStudio.Explorer

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.Explorer. DLL

    ----------------------------------------

    System.Design

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll

    ----------------------------------------

    Microsoft.SqlServer.Management.SqlStudio.Migration

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.Migration .DLL

    ----------------------------------------

    Microsoft.SqlServer.Smo

    Assembly Version: 10.0.0.0

    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll

    ----------------------------------------

    System.Xml

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

    .............

    ----------------------------------------

    CustomMarshalers

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.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:

    <configuration>

    <system.windows.forms jitDebugging="true" />

    </configuration>

    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.

  • What do you mean when you attempt to create a query? Could you be more specific on what you are doing that generates the error?

    That is a .NET error.:-D

    I would step the code and try to reproduce the error while running profiler concurrently and identify the exact line of code and/or the source of the problem.

    You should include error handling in your code.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply