SQL Prompt 3.8RC Layout SQL error

jerryhung

I get this error when I select SQL code, and select "Layout SQL" under SQL Prompt 3.8RC menu

Don't have SQL Refactor installed (uninstalled from Toolbelt)
Have SSMS Tools installed

System.ApplicationException: Exception within progress task ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.TextManager.Interop.IVsTextView'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{BB23A14B-7C61-469A-9890-A95648CED5E6}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
   at Microsoft.VisualStudio.TextManager.Interop.IVsTextView.GetSelection(Int32& piAnchorLine, Int32& piAnchorCol, Int32& piEndLine, Int32& piEndCol)
   at RedGate.SQLPrompt.CommonVS.Editor.VSEditorWindow.get_Selection()
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , b , c& )
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , c& , b[] )
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a.Run()
   at RedGate.SQLPrompt.CommonUI.Progress.TaskAggregator.Run()
   at RedGate.SQLPrompt.CommonUI.Forms.ProgressDialogue.a()
   --- End of inner exception stack trace ---
   at RedGate.SQLPrompt.CommonUI.Forms.ProgressDialogue.ShowProgress(ITaskRunner task)
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.LayOutSql(EditorWindowBase editor, SqlPromptOptions options)
   at b.Execute()
   at RedGate.SQLPrompt.CommonVS.Commands.VSCommandControler.Exec(String CmdName, vsCommandExecOption ExecuteOption, Object& VariantIn, Object& VariantOut, Boolean& Handled)

tanya

Hi,

Thank you for reporting this exception. We are unable to replicate the issue and it would be helpful if we could get some information from you to have this fixed.
Can you please tell us your system configuration like the OS, the editor you are using and if possible the script that caused the exception?

Thanks,
Tanya

jerryhung

Any query gives me that error when I do Layout in 3.8RC
if someone can create a support ticket for me that's better

I have a .txt file from your Diagnostic Tool to send

It's annoying, I always run into odd cases of Layout products
another support ticket F0010024 is SSMS Tools & SQL Refactor

this one, somehow SSMS, SQL Refactor, SQL Prompt 3.6, SQL Prompt 3.8 altogether, install & uninstall, creates problem again
plus, 3.8RC doesn't auto-prompt anymore unless I hit Ctrl+Space, despite it's set to auto-complete

I need a Virtual Machine image.....................

thanks, I like the product thus far

tanya

That is really bizzare.
Can you tell me the OS you are using? I will try to establish the same environment to see what could possibly be going wrong.

Alternatively, do you have any other editors like VS or QA where you could check if SQL Prompt 3.8 RC (Layout particularly) works for you?
And if you can try to install v3.8 RC and remove SSMS tools just to confirm there is no corrupted image on your system it might help.

Thanks for your patience.

Regards,
Tanya

jerryhung

SSMS Tools removed, same error
and my SQL Prompt doesn't work in VS2005, doesn't show on tool menu in VS2008

I think this is the sequence I had

had SQL Toolbelt with SSMS, SQL Refactor works occasionally installed Data Compare 7 beta, SQL Prompt 3.8RC when they came out installed SQL Response, SQL Data Generator Prompt wasn't working, uninstalled entire Toolbelt, re-installed, now it's in a very messy situation....will try to find a clean machine to try

System.ApplicationException: Exception within progress task ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.TextManager.Interop.IVsTextView'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{BB23A14B-7C61-469A-9890-A95648CED5E6}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
   at Microsoft.VisualStudio.TextManager.Interop.IVsTextView.GetSelection(Int32& piAnchorLine, Int32& piAnchorCol, Int32& piEndLine, Int32& piEndCol)
   at RedGate.SQLPrompt.CommonVS.Editor.VSEditorWindow.get_Selection()
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , b , c& )
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , c& , b[] )
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a.Run()
   at RedGate.SQLPrompt.CommonUI.Progress.TaskAggregator.Run()
   at RedGate.SQLPrompt.CommonUI.Forms.ProgressDialogue.a()
   --- End of inner exception stack trace ---
   at RedGate.SQLPrompt.CommonUI.Forms.ProgressDialogue.ShowProgress(ITaskRunner task)
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.LayOutSql(EditorWindowBase editor, SqlPromptOptions options)
   at b.Execute()
   at RedGate.SQLPrompt.CommonVS.Commands.VSCommandControler.Exec(String CmdName, vsCommandExecOption ExecuteOption, Object& VariantIn, Object& VariantOut, Boolean& Handled)

Easier if I can send the rgdias.txt to someone

Platform               : Win32NT                          
Service Pack           : Service Pack 2                   
Network                : True                             
Caption                : Microsoft Windows XP Professional
Version                : 5.1.2600                         

|  | ----------
 |  | SQL Backup
 |  | ----------
 |  |  | -
 |  |  | 5
 |  |  | -
 |  |  |  | CurrentVersion: 5.1.0.0
 |  | -----------
 |  | SQL Compare
 |  | -----------
 |  |  | -
 |  |  | 6
 |  |  | -
 |  |  |  | CurrentVersion: 6.2.0.0
 |  |  | -
 |  |  | 7
 |  |  | -
 |  |  |  | CurrentVersion: 7.0.0.392
 |  | ----------------
 |  | SQL Data Compare
 |  | ----------------
 |  |  | -
 |  |  | 6
 |  |  | -
 |  |  |  | CurrentVersion: 6.1.1.308
 |  | ------------------
 |  | SQL Data Generator
 |  | ------------------
 |  |  | -
 |  |  | 1
 |  |  | -
 |  |  |  | CurrentVersion: 1.0.0.1022
 |  | -------
 |  | SQL Doc
 |  | -------
 |  |  | -
 |  |  | 1
 |  |  | -
 |  |  |  | CurrentVersion: 1.02.0031.0
 |  | --------------
 |  | SQL Log Rescue
 |  | --------------
 |  |  | Currentversion: 1.20.0010.0
 |  | ----------------
 |  | SQL Multi Script
 |  | ----------------
 |  |  | -
 |  |  | 1
 |  |  | -
 |  |  |  | CurrentVersion: 1.1.0.34
 |  | ------------
 |  | SQL Packager
 |  | ------------
 |  |  | -
 |  |  | 5
 |  |  | -
 |  |  |  | CurrentVersion: 5.4.0.0
 |  | ----------
 |  | SQL Prompt
 |  | ----------
 |  |  | -
 |  |  | 3
 |  |  | -
 |  |  |  | CurrentVersion: 3.80.0.1
 |  | -----------
 |  | SQL Tracker
 |  | -----------
 |  |  | -
 |  |  | 2
 |  |  | -
 |  |  |  | CurrentVersion: 2.40.0075.0

tanya

Hi,

Please see my email and you can send any logs or text files to that id.

Thanks,
Tanya

jerryhung

All good now

So I uninstalled SQL Prompt, SQL Refactor, SQL 2005 (inc. VS2005)
Re-install everything again – SQL 2005 (Client tools only), SP2, SQL Prompt

And voila! It works, Layout function work as well. Used it for 2 days no issue
Installed SSMS Tools today, and it still seems to work, YEH!!!!

Thanks for all the help

tanya

Fantastic!