Comments
10 comments
-
I'm getting the same problem
Adding: with SQL Prompt disabled, if I navigate to any SQL Prompt item in QA menu (ex. Options) I receipt the Microsoft .NET Framework error box (Unhandled exception has ocurred... The following elements are not closed: Description, Snippet, Snipets, SnippetManager. Line 105, position 52".
In details buttons, bring to me
"See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Xml.XmlException: Unexpected end of file has occurred. The following elements are not closed: Description, Snippet, Snippets, SnippetManager. Line 105, position 52.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.ThrowUnclosedElements()
at System.Xml.XmlTextReaderImpl.ParseElementContent()"
And much more .
Win XP portuguese-brasilian + sp2 . 1gb ram.
QA version: 8.00.2039 -
Hi,
Thanks for the feedback. We are currently looking into the issue.
Regards,
Tilman -
Hi again,Win XP portuguese-brasilian
Interesting. Could you tell me what version/language of SQL Server 2000 you have installed, including what service pack?
Thanks,
Tilman -
Hello, it's:
All my servers is running on Windows Server in English.
Portuguese is only to client machines.
Sql Server Version
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Standard Edition 8.00.2039 SP4 -
Hi EsioN,
Thanks for the information. I just looked at your exception in detail. Looks like your snippets file got corrupted somehow (did you have the previous beta installed?) Could you try renaming/removing the file
%USERPROFILE%\Local Settings\Application Data\Red Gate\SQL Prompt 3\SQL Prompt 3 Snippets.xml
Seems like you're not the only one who is having this problem.
muhlbeid it looks like you are having a different problem. Could you give me some more info as above?
Cheers,
Tilman -
Yes I had the previous beta verions (SQL 3), and too SQL 2. But I had desintaled both before trying this beta.
I tried renaming that file, according your suggestion, but it doesn't worked.
So, I removed alll SQL Prompt 3 directory in Application Data, and Bingo, it' working now.
Thanks
Esio Nunes -
Glad you got it working and sorry for the inconvenience,
Tilman -
muhlbeid,
Can you try following the steps here please:
http://www.red-gate.com/messageboard/vi ... hp?p=14316
Thanks,
Neil -
Neil,
I tried the steps you suggested to fix the problem. Reseting the QA toolbar had no affect. Deleting the QA toolbar key from the registry fixed the error when QA starts up, but now I get a new error. As soon as I log in to QA, I then get a MS.Net error for SQL Prompt with the following detail. SQL Prompt is then not functional:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Xml.XmlException: Root element is missing.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res)
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlReader.MoveToContent()
at System.Xml.XmlReader.ReadStartElement(String name)
at RedGate.SqlPrompt.Engine.Snippets.SnippetManager.FromXml(XmlReader reader)
at RedGate.SqlPrompt.Engine.Snippets.SnippetManager.LoadSnippets(String filename)
at RedGate.SqlPrompt.Engine.Snippets.SnippetManager._1()
at RedGate.SqlPrompt.Engine.Snippets.SnippetManager..ctor(String storageDirectory)
at RedGate.SqlPrompt.Engine.Snippets.SnippetManager.GetSnippetManager()
at _30._1(Boolean )
at _30._1(_4 , _13 )
at RedGate.SqlPrompt.Engine.SqlPromptEngine..ctor(EngineOptions options)
at RedGate.SqlPrompt.Engine.SqlPromptEngineFactory.GetEngine(Object owner, EngineOptions options)
at RedGate.SqlPrompt.Engine.SqlPromptEngineFactory.GetEngine(Object owner)
at _17.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.768
Win32 Version: 3.0.0.768
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.768
Win32 Version: 3.0.0.768
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
RedGate.SqlPrompt.Engine
Assembly Version: 3.0.0.768
Win32 Version: 3.0.0.768
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.768
Win32 Version: 3.0.0.768
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.Gatekeeper.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
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.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
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
RedGate.Update.Client
Assembly Version: 1.2.0.3
Win32 Version: 1.2.0.3
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Update.Client.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. -
Neil,
I just noticed that there is a new version of SQL Prompt available. I installed it, and my problems starting QA are gone. Now my trial period for SQL Prompt is expired.
Add comment
Please sign in to leave a comment.
The instruction at "0x7c911e58" referenced memory at "0x00000000". The memory could not be "read". Click on OK to terminate the program.
With SQL Prompt disabled, Query Analyser runs as normal.
I had the previous Beta of SQL Prompt installed before I installed the latest. I have since completely uninstalled all versions of SQL Prompt, then reinstalled the latest Beta. I still have the same issue as above.
I am running on XP Pro SP2 with all critical MS updates. 1 GB RAM. Task Manager reports my memory Commit Charge as 872M / 2460M. Query Analyzer is Version SQL 8.00.2039.