SQL Prompt 3.8RC Layout SQL error

• 
  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

  tanya April 15, 2008 08:47

  - 0 +
• 
  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

  jerryhung April 15, 2008 13:21

  - 0 +
• 
  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

  tanya April 15, 2008 13:27

  - 0 +
• 
  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
  

  jerryhung April 15, 2008 13:45

  - 0 +
• 
  Hi,
  
  Please see my email and you can send any logs or text files to that id.
  
  Thanks,
  Tanya

  tanya April 15, 2008 13:53

  - 0 +
• 
  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

  jerryhung April 22, 2008 12:08

  - 0 +
• 
  Fantastic!

  tanya April 22, 2008 12:19

  - 0 +

Add comment

Please sign in to leave a comment.