SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 ClearTrace Support Forum
 SQL Trace is not writing any data to the DB
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hgkapadia
Starting Member

India
1 Posts

Posted - 11/11/2011 :  03:08:38  Show Profile  Reply with Quote
Hi,

I'm using sql server R2 and i've tried to import 1.9 mb trace file to the cleartrace tool. But it did not complete successfully. Below is the summary i got. It says, 0 summary rows saved.

************************************************************
1 files found in the trace directory
Moving files to the Work Directory...
Files to process: 1 ( 1.9 MB )
Clearing Target Tables...
************************************************************
Processing: Sql_BU2_trace.trc
************************************************************
Trace Rows Read: 5,101
Saving Lookup Data...
Summary Rows Saved: 0
File Process Time (seconds): 0.5
************************************************************
Saving Lookup Data...
Import Time (seconds): 0.5
KB per Second: 3,940
Moving files to the Archive Directory...
Done.


--
Harry

tmutch
Starting Member

New Zealand
1 Posts

Posted - 12/22/2011 :  16:23:33  Show Profile  Reply with Quote
Hi

I have the same issue using SQL Server 2008 (SP1) and ClearTrace Build 38:

************************************************************
1 files found in the trace directory
Moving files to the Work Directory...
Files to process: 1 ( 850 KB )
Clearing Target Tables...
************************************************************
Processing: log_107.trc
************************************************************
Trace Rows Read: 2,588
Saving Lookup Data...
Summary Rows Saved: 0
File Process Time (seconds): 0.5
************************************************************
Saving Lookup Data...
Import Time (seconds): 0.5
KB per Second: 1,631
Moving files to the Archive Directory...
Done.

What am I doing wrong?

Tim
Go to Top of Page

Tomás
Starting Member

Mexico
1 Posts

Posted - 06/19/2012 :  11:38:14  Show Profile  Reply with Quote
Hi Everyone..... I have the same issue........

1 files found in the trace directory
Moving files to the Work Directory...
Files to process: 1 ( 20.0 MB )
Clearing Target Tables...
************************************************************
Processing: log_21043.trc
************************************************************
Trace Rows Read: 80,784
Saving Lookup Data...
Summary Rows Saved: 0
File Process Time (seconds): 7.8
************************************************************
Saving Lookup Data...
Import Time (seconds): 7.8
KB per Second: 2,611
Moving files to the Archive Directory...
Done.

Please help..!!!!
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4138 Posts

Posted - 06/19/2012 :  17:35:24  Show Profile  Visit graz's Homepage  Reply with Quote
What events do you have in the trace file? Usually this means that the RPC:Completed event or the SQL:BatchCompleted events weren't captured. Can you zip up the trace file and email it to me?

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000