Cannot Retrieve Objects
dpalazotto
Posts: 8
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?
"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?
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com