Cannot Retrieve Objects

Provides intelligent code completion for SQL Server editors.

Cannot Retrieve Objects

Postby dpalazotto » Thu Nov 15, 2012 1:41 pm

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?
Posts: 5
Joined: Wed Feb 11, 2009 3:52 pm

Postby eddie davis » Thu Nov 15, 2012 3:11 pm

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 Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests