What are the challenges you face when working across database platforms? Take the survey
Options

SQL Prompt 3.8 throws ArgumentNullException

apehkoneapehkone Posts: 2
edited July 15, 2008 1:50PM in SQL Prompt Previous Versions
I have very annoying problem that SQLPrompt throws ArgumentNullException exception when trying to create new function call in SQL Query Analyzer (8.00). This happens every time when moving cursor on the screen. It's even more annoying that pressing 'quit' closes SQL Query analyzer instead of SQLPrompt. I already did it once and lost unsaved parts from the script.

Here's the exception:

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

************** Exception Text **************
System.ArgumentNullException: Database must not be null.
Parameter name: database
at RedGate.SQLCompare.Engine.DatabaseObjectResolver..ctor(Database database)
at RedGate.SqlPrompt.Engine.SqlPromptEngine.ParameterPrompt()
at RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase.OnCaretPoitionChanged()
at j.a(String , CaretPosition , CaretPosition )
at h.a(String , CaretPosition , CaretPosition )
at e.a(String , CaretPosition , CaretPosition )
at a.a(String , String , Int32 , CaretPosition )
at a.e()
at e.b(Object , CharEventArgs )
at h.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.1433 (REDBITS.050727-1400)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
RedGate.SQLPrompt.QueryAnalyzerUI
Assembly Version: 3.8.0.244
Win32 Version: 3.8.0.244
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.1433 (REDBITS.050727-1400)
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.8.0.244
Win32 Version: 3.8.0.244
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonUI.DLL
RedGate.Licensing.Client
Assembly Version: 2.5.5.1
Win32 Version: 2.5.5.1
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Licensing.Client.DLL
RedGate.SqlPrompt.Engine
Assembly Version: 3.8.0.244
Win32 Version: 3.8.0.244
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.DLL
log4net
Assembly Version: 1.2.10.0
Win32 Version: 1.2.10.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/log4net.DLL
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
RedGate.SQL.Shared
Assembly Version: 6.2.1.43
Win32 Version: 6.2.1.43
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQL.Shared.DLL
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
RedGate.SqlPrompt.Engine.Gatekeeper
Assembly Version: 3.8.0.244
Win32 Version: 3.8.0.244
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.Gatekeeper.DLL
RedGate.Shared.Utils
Assembly Version: 6.2.1.43
Win32 Version: 6.2.1.43
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Shared.Utils.DLL
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
OptionsLayoutOptions19f7835ff1cf479e9ae2e9348c7ce60c
Assembly Version: 0.0.0.0
Win32 Version: 3.8.0.244
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonUI.dll
ISymWrapper
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/ISymWrapper/2.0.0.0__b03f5f7f11d50a3a/ISymWrapper.dll
RedGate.SQLCompare.Engine
Assembly Version: 6.2.3.47
Win32 Version: 6.2.3.47
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.Engine.DLL
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
RedGate.SQLCompare.ASTParser
Assembly Version: 6.2.3.47
Win32 Version: 6.2.3.47
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.ASTParser.DLL
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.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

  • Options
    I'm sorry that you're experiencing this issue. I've logged this in our bug tracking software and the developers will look into this. In the mean time I think you maybe able to workaround this issue by turning off the Parameter Prompt functionality. From the looks of things the exception is being thrown by the Parameter prompt function and you can disable this by going to SQL Prompt > Options > Behaviour > Information Panels > untick 'Enable parameter hints'
  • Options
    The developers have created a patch that they hope will resolve this issue. You can email support@red-gate.com to request the patch and see if it fixes the problem.
  • Options
    rgiesbrechtrgiesbrecht Posts: 17 Bronze 2
    Is this patch going to be generally available as a point release (minor upgrade)? I am experiencing the same issue and would prefer to not turn off functionality.
  • Options
    Hi there,

    we have now released SQL Prompt 3.9. This public release contains a fix for this problem. You can download the latest version of SQL Prompt from our product pages, or use 'Check for Updates' from the SQL Prompt menu in your editor.

    Thanks, Tom

    Tom Harris
    Red Gate Software
Sign In or Register to comment.