Error on newly release SQL Prompt 3.0

bconlonbconlon Posts: 20
edited March 13, 2007 12:45PM in SQL Prompt Previous Versions
Got this error with the RTM of SQL Prompt 3.0. Any ideas on this one?

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

************** Exception Text **************
System.ArgumentException: Error finding parent window
at _7.OnHandleChange()
at System.Windows.Forms.NativeWindow.AssignHandle(IntPtr handle, Boolean assignUniqueID)
at System.Windows.Forms.NativeWindow.AssignHandle(IntPtr handle)
at _18.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(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.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
RedGate.SQLPrompt.QueryAnalyzerUI
Assembly Version: 3.0.0.868
Win32 Version: 3.0.0.868
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.QueryAnalyzerUI.exe
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
RedGate.SQLPrompt.CommonUI
Assembly Version: 3.0.0.868
Win32 Version: 3.0.0.868
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonUI.DLL
RedGate.Licensing.Client
Assembly Version: 1.3.0.25
Win32 Version: 1.3.0.25
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Licensing.Client.DLL
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
RedGate.Licensing.Helper
Assembly Version: 1.3.0.25
Win32 Version: 1.3.0.25
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Licensing.Helper.DLL
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
RedGate.SqlPrompt.Engine
Assembly Version: 3.0.0.868
Win32 Version: 3.0.0.868
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.DLL
RedGate.SQL.Shared
Assembly Version: 5.3.0.1
Win32 Version: 5.3.0.1
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQL.Shared.DLL
RedGate.SqlPrompt.Engine.Gatekeeper
Assembly Version: 3.0.0.868
Win32 Version: 3.0.0.868
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.Gatekeeper.DLL
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
RedGate.Shared.Utils
Assembly Version: 5.3.0.1
Win32 Version: 5.3.0.1
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Shared.Utils.DLL
RedGate.SQLCompare.Engine
Assembly Version: 5.8.0.59
Win32 Version: 5.8.0.59
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.Engine.DLL
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.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.

Comments

  • I keep getting intermitten errors where my Query Analyzer window will have multiple Sql-prompt menus. This doesn't happen all the time but occassionally I will have multiple windows within one QA session open, then I'll open another QA session, and that window will be normal, but my primary QA window will suddenly have as many as 6 Sql Prompt Menus.
  • Hi

    I would really like to get to the bottom of these errors.

    bconlon: Could you please tell me what you were doing when you got that error? Were you creating a new window closing a window or doing something else?


    fhtapia: That sounds like a different issue If you find anyway of relyably reproducing that error please tell me. There is a similar issue where by closing and opening the tray app you can get multipule menus to appear. I will put in a fix for that problem which should fix this bug as a consiquence. I would really like to be able to reproduce that problem here so know I have definatly fixed it!

    Lionel
    Software Engineer
    Red Gate Software
  • Bart ReadBart Read Posts: 997 Silver 1
    Does anybody else experience this or have any information on how we could reproduce it please?
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Bart Read wrote:
    Does anybody else experience this or have any information on how we could reproduce it please?
    Thanks,
    Bart
    Yes, I am also experiencing this error.

    In my case, it is always happening when I work with the "sys.dm_db_index_physical_stats" Dynamic Management View. The syntax of the command is as follows:

    SELECT *
    FROM sys.dm_db_index_physical_stats(DB_ID(N'<UserDatabaseName>
    ', NULL, NULL, NULL, 'LIMITED');

    As soon as I enter the left parenthesis, the exception is thrown. It also happens if I click or type anything inside the parentheses of an existing script of this command.

    My machine runs Windows XP Professional SP2 (Build 2600) and SQL Server 2005 SP1 with Cumulative Hotfix KB918222. The SQL Server build number with this hotfix is 9.0.2153. I have downloaded all current Windows updates other than SP1 for Visual Studio 2005.
  • Bart ReadBart Read Posts: 997 Silver 1
    Thanks Wyatt, I'll give this a whirl and see what happens.
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • It seems to have something to do with the DMVs, because I get the same behavior with this script that I use to monitor my SQL Backup jobs:

    SELECT er.session_id, program_name, er.command, er.sql_handle, er.start_time, er.status, er.percent_complete, er.blocking_session_id
    FROM sys.dm_exec_sessions es INNER JOIN sys.dm_exec_requests er
    ON es.session_id = er.session_id
    CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)
    WHERE program_name like '%SQB%';
  • Bart ReadBart Read Posts: 997 Silver 1
    Hi Wyatt,


    That's right. Actually it affects all table-valued system functions on SQL Server 2005. Rather embarrassing for us, but fortunately a very easy fix. Thanks for getting back to me with that extra information: very helpful.


    Cheers,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Bart ReadBart Read Posts: 997 Silver 1
    Just to add, this fix will be available in the 3.1 point release which should be out before the end of the month.
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Bart ReadBart Read Posts: 997 Silver 1
    Hi there,


    Just to let you know that an early access release of SQL Prompt 3.1 that should fix this problem is now available. See the following post for details:

    http://www.red-gate.com/MessageBoard/vi ... php?t=4487

    Hope that helps.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.