Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 ClearTrace Support Forum
 Error while dumping the trace files in SQL 2k8 x64

Author  Topic 

NinadKulkarni
Starting Member

6 Posts
Posted - 2009-06-17 : 09:51:02
Here is the error message that I'm getting when I'm importing SQL 2000 trace files into SQL 2008 cleartrace.

Unhandled Exception: Exception has been thrown by the target of an invocation.(system.Reflection.TargetInvocationException)
Detailed error file: ClearTrace_Error_20090617_094436.txt

Please post the contents of this file in the cleartrace support forum on SQLTeam.com

Here is the version that I'm trying to use:

Clear Trace Version: 2008.34
SQL Server Version: SQL 2008 sp1 x64 10.0.2531

Any clue on why this is happening?

Thanks,

NinadKulkarni
Starting Member

6 Posts
Posted - 2009-06-17 : 09:55:36
It seems like there is some problem with Build 34 because I've just downloaded Build 31 and it's working fine for the same trace files.

Thanks,
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2009-06-17 : 10:17:04
There is a detailed error report in the same directory where the ClearTrace executable is. Can you post the contents of that here or email it to me at graz at this domain?



=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

NinadKulkarni
Starting Member

6 Posts
Posted - 2009-06-17 : 10:34:40
Hi Graz,

Thanks for quick reply on this. I tried reproducing the same error and it did not generate any txt files in the directory. I tried searching all the drives for this txt files but it doesn't seem like the tool is generating any txt files.

Thanks,
Go to Top of Page

NinadKulkarni
Starting Member

6 Posts
Posted - 2009-06-17 : 10:44:08
The tool does not generate the trace files in the directory where .exe files are located. It generated these .txt files where trace files are located. I guess Microsoft needs to refine their search in w2k3 ;). Any ways, here is the output of 3 files that I got it:

This is the first time when I ran it.
******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.34.0
Last Exception: Item has already been added. Key in dictionary: '1' Key being added: '1'
Last Target Site: Void Add(System.Object, System.Object)
******************************************************************************

Exception Type: System.Reflection.TargetInvocationException
Exception Message: Exception has been thrown by the target of an invocation.
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 System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at ClearTraceGui.Program.Main()

================================
Inner Exception
================================
Exception Type: System.Reflection.TargetInvocationException
Exception Message: An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at System.ComponentModel.RunWorkerCompletedEventArgs.get_Result()
at ClearTraceGui.MainForm.backgroundWorker1_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)

================================
Inner Exception
================================
Exception Type: System.ArgumentException
Exception Message: Item has already been added. Key in dictionary: '1' Key being added: '1'
at System.Collections.SortedList.Add(Object key, Object value)
at ClearData.ClearTrace.TraceDimension.GetIndex(String lookupValue, String connectionString)
at ClearData.ClearTrace.TraceDimension.GetIndex(IDataReader traceFile, String connectionString)
at ClearData.ClearTrace.SqlTrace.ProcessFiles(BackgroundWorker worker, DoWorkEventArgs eventArgs)
at ClearTraceGui.MainForm.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
-- End of first run.

-- This is the second time when I ran it:

******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.34.0
Last Exception: Item has already been added. Key in dictionary: '1' Key being added: '1'
Last Target Site: Void Add(System.Object, System.Object)
******************************************************************************

Exception Type: System.Reflection.TargetInvocationException
Exception Message: Exception has been thrown by the target of an invocation.
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 System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at ClearTraceGui.Program.Main()

================================
Inner Exception
================================
Exception Type: System.Reflection.TargetInvocationException
Exception Message: An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at System.ComponentModel.RunWorkerCompletedEventArgs.get_Result()
at ClearTraceGui.MainForm.backgroundWorker1_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)

================================
Inner Exception
================================
Exception Type: System.ArgumentException
Exception Message: Item has already been added. Key in dictionary: '1' Key being added: '1'
at System.Collections.SortedList.Add(Object key, Object value)
at ClearData.ClearTrace.TraceDimension.GetIndex(String lookupValue, String connectionString)
at ClearData.ClearTrace.TraceDimension.GetIndex(IDataReader traceFile, String connectionString)
at ClearData.ClearTrace.SqlTrace.ProcessFiles(BackgroundWorker worker, DoWorkEventArgs eventArgs)
at ClearTraceGui.MainForm.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
-- End of second run.

-- This is the third time when I ran it:

******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.34.0
Last Exception: Item has already been added. Key in dictionary: '1' Key being added: '1'
Last Target Site: Void Add(System.Object, System.Object)
******************************************************************************

Exception Type: System.Reflection.TargetInvocationException
Exception Message: Exception has been thrown by the target of an invocation.
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 System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at ClearTraceGui.Program.Main()

================================
Inner Exception
================================
Exception Type: System.Reflection.TargetInvocationException
Exception Message: An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at System.ComponentModel.RunWorkerCompletedEventArgs.get_Result()
at ClearTraceGui.MainForm.backgroundWorker1_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)

================================
Inner Exception
================================
Exception Type: System.ArgumentException
Exception Message: Item has already been added. Key in dictionary: '1' Key being added: '1'
at System.Collections.SortedList.Add(Object key, Object value)
at ClearData.ClearTrace.TraceDimension.GetIndex(String lookupValue, String connectionString)
at ClearData.ClearTrace.TraceDimension.GetIndex(IDataReader traceFile, String connectionString)
at ClearData.ClearTrace.SqlTrace.ProcessFiles(BackgroundWorker worker, DoWorkEventArgs eventArgs)
at ClearTraceGui.MainForm.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

-- End of third run.

Thanks,
Go to Top of Page

NinadKulkarni
Starting Member

6 Posts
Posted - 2009-06-17 : 10:45:58
In the above post, I meant to say:

The tool does not generate the txt files in the directory where .exe files are located. It generated these .txt files where trace files are located. I guess Microsoft needs to refine their search in w2k3 ;)
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2009-06-17 : 10:53:05
Hmmm. Are the trace files small enough that you could email them to me? graz at this domain.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

NinadKulkarni
Starting Member

6 Posts
Posted - 2009-06-17 : 11:02:02
We ran 24hr trace on the server so it picked up 50 trace files each of those 512MB ;).
Go to Top of Page

scotdotnet
Starting Member

2 Posts
Posted - 2009-06-26 : 18:46:34
Just to confirm - I also get this problem when using 34 on sql2008 64x - cleartrace just shuts down - cannot find any error txt anywhere. It looks like it shuts down on the first attempt to access the database after reading he first buffer set of data
Go to Top of Page

gvphubli
Yak Posting Veteran

54 Posts
Posted - 2009-08-27 : 11:26:22

As per the message posted here "http://social.msdn.microsoft.com/Forums/en-US/vstsprofiler/thread/8bd8da75-76d2-4257-aeee-d040e6167bf9" it looks like this issue exists in other products too.

TechnologyYogi
http://gvphubli.blogspot.com/
Go to Top of Page

mrphantuan
Starting Member

5 Posts
Posted - 2010-11-17 : 05:48:25
It seems like there is some problem with Build 34 because I've just downloaded Build 31 and it's working fine for the same trace files.



_______________
Du hoc-Tu van du hoc-Hoc bong du hoc-Du hoc singapore- Du hoc my

mrphantuan phan
Go to Top of Page

scotdotnet
Starting Member

2 Posts
Posted - 2010-11-18 : 15:33:37
Build 35 seems to work fine
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2010-11-19 : 11:39:05
Build 35 should fix this. There was an annoying little bug that I finally tracked down.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

anildas
Starting Member

2 Posts
Posted - 2010-12-07 : 13:58:07
I was having same problem. Build 35 fixed it for me. Yes!

******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.34.0
Last Exception: Item has already been added. Key in dictionary: '25' Key being added: '25'
Last Target Site: Void Add(System.Object, System.Object)
******************************************************************************
Go to Top of Page

mrphantuan
Starting Member

5 Posts
Posted - 2010-12-16 : 11:34:14
quote:
Originally posted by graz

There is a detailed error report in the same directory where the ClearTrace executable is. Can you post the contents of that here or email it to me at graz at this domain?



=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

Thanks for quick reply on this. I tried reproducing the same error and it did not generate any txt files in the directory. I tried searching all the drives for this txt files but it doesn't seem like the tool is generating any txt files.

Thanks,


___________________
Let's go
Du hoc|tu van du hoc| cu?a chô´ng cha´y
Hoc bong du hoc
Du hoc singapore



mrphantuan phan
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site