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.
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 followingquote: ClearTrace 2008.34 (BETA)Copyright ClearData Consulting, Inc. 2010Server: SCT-DBSQL01Database : DBAFile Name: E:\TraceData\ToLoad\SCT-DBSQL01_ReadsGt5000.trcTrace Group: DBSQL01_Gt5000Work Directory: E:\TraceData\WorkArchive Directory: E:\TraceData\Archive1 files found in the trace directoryMoving 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.ThanksPhil |
|
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.0Last 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.TargetInvocationExceptionException 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.TargetInvocationExceptionException 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.ArgumentExceptionException 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)
|
|
|
|
|
|
|
|