Solved

Failed to use fn_trace_gettable to import trace file to table

Posted on 2008-10-02
24
1,657 Views
Last Modified: 2012-05-05
When I use fn_trace_gettable  to import a trace file to table, it failed. The error message is:
File ''xxx.trc' either does not exist or is not a recognizable trace file ....

I can load the trace file into Profiler

0
Comment
Question by:treehouse2008
  • 10
  • 7
  • 6
24 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 22628357
post your sql....
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22628371
Are you specifying the full path to the file?

0
 

Author Comment

by:treehouse2008
ID: 22628373
Select * into TraceTable from fn_trace_gettable('C:\tracefile.trc',default);
0
 

Author Comment

by:treehouse2008
ID: 22628378
Yes, I specified the full path to the file
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22628476
Does the account that SQL Server is running as have access to the path?  IF SQL Server is running as "network service" or local, and the trc is on a network share or a path local with restricted permissions, you won't be able to access it.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22628479
are you on the local server?  is the file at the C: drive on the local server?  if not, move it to there...the file path you're specifying has to be on the sql server itself.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22628487
"the file path you're specifying has to be on the sql server itself."

Or in a location that the SQL Service account has access to :)
0
 

Author Comment

by:treehouse2008
ID: 22628504
The trace file is on my local machine. The SQL Server is on the server. I use Management Studio to access the database.
0
 

Author Comment

by:treehouse2008
ID: 22628512
How do I know if the account that SQL Server is running as have access to the path?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22628514
so, move the trace file to the sql server (or somewhere sql server can get to) and try it again.

0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 22628527
so if you have it local under c:\trace.trc, and you type in c:\trace.trc, it is trying to find it in the ROOT of the c: on the SQL Server itself.  Either copy it locally to the SQL server (using windows file sharing), or to a location on the network (such as \\YourComputerName\YourShareName) where the account that SQL Server is running as has access to it.  IF you are not a SQL Server admin, you may not know what account it is running as so best to try and get it on the physical server somewhere.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:treehouse2008
ID: 22628533
I cannot move the trace file into the machine with sql server. I do not have that authorization.
0
 

Author Comment

by:treehouse2008
ID: 22628543
I got it. Thank you both.
0
 

Author Closing Comment

by:treehouse2008
ID: 31502565
Thanks
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22628546
If you don't have authorization to get the .trc on there, then you probably don't have the authorization to know what account SQL is running as.

You are going to need help from a DBA or IT person at your company for this.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22628550
yeah, you're going to need to either get it to a share or the local machine

if the acct running sql is a domain admin, then try this:

Select * into TraceTable from fn_trace_gettable('\\yourpcname\C$\tracefile.trc',default);
0
 

Author Comment

by:treehouse2008
ID: 22628556
I want to accept both of you as "Accepted Solution", but it seems I cannot accept two. I will try
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22628562
You can accept to....I hate to, but I have to object.
0
 

Author Comment

by:treehouse2008
ID: 22628570
Please tell me how I can accpet two solutions if it can.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22628600
You'll have to submit a post here to have it reopened so you can split them.

http://www.experts-exchange.com/Other/Community_Support/
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22628623
That wasn't supposed to be an administrative comment.  Oops.
0
 

Author Comment

by:treehouse2008
ID: 22628678
I will do it today.

Thank you two again,.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22633397
thank you.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now