Error on newly release SQL Prompt 3.0

bconlon

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

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

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

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

Wyatt70

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

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

Wyatt70

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

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

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

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