Error when doing sys.dm_exec_sql_text()

MladenPrajdic

Hi!

My version is 3.0.0.868

when doing

SELECT *
FROM sys.dm_exec_sql_text()

and pressing any button after i type the )
i get this error after every key press:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SqlPrompt.Engine.Candidates.FunctionCandidate._1()
at RedGate.SqlPrompt.Engine.Candidates.FunctionAsTableCandidate._1()
at RedGate.SqlPrompt.Engine.Candidates.FunctionAsTableCandidate..ctor(ICandidate function, String alias)
at _63._1(_71 , ICandidate , String )
at _63._4(SqlPromptEngine , _82 , Element )
at _63._1(SqlPromptEngine , _82 , Element )
at _63._1(SqlPromptEngine , _82 , Element )
at _63..ctor(SqlPromptEngine engine, _82 astMap, Element element)
at _68._3(SqlPromptEngine , _82 , Element )
at _68._1(SqlPromptEngine , _82 , Element , Boolean , Boolean )
at _68._1(SqlPromptEngine , _82 , Element , Boolean , Boolean )
at _68._1(SqlPromptEngine , _82 , Element , Boolean , Boolean )
at _68._1(SqlPromptEngine , _82 , Element , Boolean , Boolean )
at _68._1(SqlPromptEngine , _82 , Element , Boolean , Boolean )
at _68._1(SqlPromptEngine , _82 , Element , Boolean , Boolean )
at _68..ctor(SqlPromptEngine engine, _82 astMap, Element maybeSelect)
at _70.PopulateCandidateLists(_82 astMap, Element statementAst, Element ast)
at RedGate.SqlPrompt.Engine.SqlPromptEngine.UpdateCandidateLists()
at RedGate.SqlPrompt.Engine.SqlPromptEngine._2(Object , FitPropertyChangeEventArgs )
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at RedGate.Util.EventHandlerSet._1.Fire(Object eventKey, Object sender, EventArgs args)
at _96._1(CaretPosition , CaretPosition )
at _96.set_CaretPosition(CaretPosition value)
at _96._1(CaretPosition )
at _96.SetSqlScriptProvider(IScriptProvider provider, CaretPosition caretPosition)
at RedGate.SqlPrompt.Engine.SqlPromptEngine.SetSqlScriptProvider(IScriptProvider provider, CaretPosition caretPosition)
at RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase.OnCaretPoitionChanged()
at _15._2(Object , EventArgs )
at _13.Exec(Guid& pguidCmdGroup, UInt32 nCmdID, UInt32 nCmdexecopt, IntPtr pvaIn, IntPtr pvaOut)

Bart Read

Hi there,


Please upgrade to the latest version (3.5.0.333) by downloading from our main website. That should fix your problem.


Thanks,
Bart