SQL Prompt 3.8RC Layout SQL error

jerryhungjerryhung Posts: 138
edited April 22, 2008 12:19PM in SQL Prompt Previous Versions
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)
Jerry Hung
DBA, MCITP

Comments

  • 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
  • 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
    Jerry Hung
    DBA, MCITP
  • tanyatanya Posts: 269
    edited April 15, 2008 1:46PM
    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
  • 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
    
    Jerry Hung
    DBA, MCITP
  • Hi,

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

    Thanks,
    Tanya
  • 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
    Jerry Hung
    DBA, MCITP
  • Fantastic!
Sign In or Register to comment.