Error on newly release SQL Prompt 3.0

bconlon · January 29, 2007 1:38PM

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.

fhtapia · January 30, 2007 2:16PM

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.

Lionel · January 31, 2007 5:41AM

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

Bart Read · February 22, 2007 11:53AM

Does anybody else experience this or have any information on how we could reproduce it please?
Thanks,
Bart

Wyatt70 · March 6, 2007 2:02PM

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 Read · March 7, 2007 6:15AM

Thanks Wyatt, I'll give this a whirl and see what happens.

Wyatt70 · March 7, 2007 8:07AM

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 Read · March 7, 2007 8:27AM

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 · March 7, 2007 9:14AM

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 · March 13, 2007 12:45PM

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

Error on newly release SQL Prompt 3.0

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk