Red Gate forums :: View topic - Cannot Retrieve Objects
Return to www.red-gate.com RSS Feed Available

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

Cannot Retrieve Objects

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dpalazotto



Joined: 11 Feb 2009
Posts: 5

PostPosted: Thu Nov 15, 2012 2:41 pm    Post subject: Cannot Retrieve Objects Reply with quote

I'm getting the following error when 'Refreshing Suggestions':
"Cannot Retrieve Objects"....

The SQL Prompt Log File shows the following:

15 Nov 2012 13:36:54,209 [1] WARN RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase - Cache had warnings
System.Exception: Trying to override a key: '@tx_id'
at ...(String ,  )
at ..Add(String ,  )
at ..(String ,  )
at ..(IParameterCandidate )
at RedGate.SqlPrompt.Metadata.Candidates.ParameterCandidate..ctor(String name, IDataType datatype, IParameterHolder owner, Boolean isOutput, Int16 length, Int16 colOrder)
at ..(IDataReader , IDictionary`2 , IDictionary`2 , IDictionary`2 , Int64 )
at ..()


Any Thoughts?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 922
Location: Red Gate Software

PostPosted: Thu Nov 15, 2012 4:11 pm    Post subject: Reply with quote

Hi, I believe that you contacted us via the Live Support portal on our web site earlier today and support call F0066832 was created for you.

The database that you are refreshing, does it contain encrypted objects?

I ask the question from the log file you provided, SQL Prompt is attempting to decrypt some encrypted objects and your user account cannot decrypt these objects as per this information in the log file:

15 Nov 2012 13:27:29,380 [1] WARN RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase - Cache had warnings
RedGate.SqlPrompt.Metadata.Metadata_Interfaces.DecryptionException: No permissions to decrypt objects. ---> .: GetObjectID: No object found

The important part - No permissions to decrypt objects.

I suspect that it may be necessary to have grant VIEW SERVER STATE rights to access information about encryption keys and encrypted objects.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic 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