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
 Trace File Read Error

Author  Topic 

philcart
Starting Member

5 Posts

Posted - 2010-03-18 : 02:30:55
Trying to process some SQL 2000 trace files and I'm getting the following

quote:
ClearTrace 2008.34 (BETA)
Copyright ClearData Consulting, Inc. 2010
Server: SCT-DBSQL01
Database : DBA
File Name: E:\TraceData\ToLoad\SCT-DBSQL01_ReadsGt5000.trc
Trace Group: DBSQL01_Gt5000
Work Directory: E:\TraceData\Work
Archive Directory: E:\TraceData\Archive1 files found in the trace directory
Moving files to the Work Directory...
Files to process: 1 ( 5.0 MB )
************************************************************
Processing: SCT-DBSQL01_ReadsGt5000.trc
************************************************************
Trace File Read Error in E:\TraceData\Work\SCT-DBSQL01_ReadsGt5000.trc (Exception has been thrown by the target of an invocation.)
You can visit the support forum at http://www.sqlteam.com/forums/forum.asp?FORUM_ID=27


Hope someone has some ideas.

Thanks
Phil

philcart
Starting Member

5 Posts

Posted - 2010-03-18 : 23:34:31
Tried processing the same files on an different server that has SQL 2008 installed and got the following error,

quote:
******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.34.0
Last Exception: Item has already been added. Key in dictionary: '16' Key being added: '16'
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: '16' Key being added: '16'
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)


Go to Top of Page
   

- Advertisement -