What are the challenges you face when working across database platforms? Take the survey
Options

Error when doing sys.dm_exec_sql_text()

MladenPrajdicMladenPrajdic Posts: 10 Bronze 2
edited July 30, 2007 1:36PM in SQL Prompt Previous Versions
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)

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    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
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.