| 
                
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 |  
                                    | philcartStarting 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:Hope someone has some ideas.ThanksPhilClearTrace 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
 
 |  |  
                                    | philcartStarting 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)
 
 |  
                                          |  |  |  
                                |  |  |  |  |  |