Red Gate forums :: View topic - Refresh Suggestions not possible with 5.0.0.365
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5 EAP
SQL Prompt 5 EAP forum

Refresh Suggestions not possible with 5.0.0.365

Search in SQL Prompt 5 EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
kondrich



Joined: 10 Jun 2010
Posts: 60
Location: Vienna, Austria

PostPosted: Tue Sep 21, 2010 3:08 pm    Post subject: Refresh Suggestions not possible with 5.0.0.365 Reply with quote

I just updated SQL Prompt from Early Access Release 1 to Early Access Relase 2 (i.e. 5.0.0.365) but now my SQL Prompt cannot refresh suggestions in my SSMS 2008 R2 installation. This occurs on any of our servers and on any database during automatic refresh and during manual refresh.

The error reads:
"SQL Prompt could not retrieve all schema information for <database name>".
Object reference not set to an instance of an object." (<database name> is just a placeholder for any database name).

I restarted SSMS several times, but no way. Since our servers, my login and my permissions have not changed within the minute of updating SQL Prompt, I guess that this build causes the error.

Any ideas would be greatly appreciated. Thanks!
_________________
Regards, Klaus
Back to top
View user's profile Send private message
kondrich



Joined: 10 Jun 2010
Posts: 60
Location: Vienna, Austria

PostPosted: Tue Sep 21, 2010 4:24 pm    Post subject: Reply with quote

Additional information from log file:

21 Sep 2010 15:22:18,870 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
21 Sep 2010 15:23:04,652 [1] WARN RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase - Cache had warnings
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SqlPrompt.Cache.Candidates.SynonymCandidate.get_ObjectType()
at RedGate.SqlPrompt.Cache.CandidateCollections.CandidateCollectionMultiType`1.Add(String key, T value)
at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase.??(IDataReader reader, IDictionary`2 users, IDictionary`2 objects, IDictionary`2 tablecolumns)
at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase.??()
_________________
Regards, Klaus
Back to top
View user's profile Send private message
paschott



Joined: 10 May 2006
Posts: 64

PostPosted: Tue Sep 21, 2010 9:48 pm    Post subject: Reply with quote

I'm getting similar errors. Some out of memory warning when trying to hit more than one DB. Any way to roll back or get a different build?

-Peter
Back to top
View user's profile Send private message
Paul Stephenson



Joined: 23 Jul 2010
Posts: 109
Location: Cambridge, UK

PostPosted: Wed Sep 22, 2010 10:06 am    Post subject: Reply with quote

Thanks for your report. We're looking into it.

If you want to roll back to the first Early Access for now, uninstall SQL Prompt 5 using the Control Panel and then reinstall 5.0.0.224.

Paul Stephenson
SQL Prompt Project Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
paschott



Joined: 10 May 2006
Posts: 64

PostPosted: Wed Sep 22, 2010 4:37 pm    Post subject: Reply with quote

I had to roll back. I couldn't even start using SSMS today. Not sure it's 100% related, but I didn't have that problem with .224. Re-installed that version and I can work again.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group