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)
    | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |   
     
     
            
              
	     |  
		
			
     
          
		 |