How can we help you today? How can we help you today?

Error when doing sys.dm_exec_sql_text()

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)
MladenPrajdic
0

Comments

1 comment

  • 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
    Bart Read
    0

Add comment

Please sign in to leave a comment.