Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Failed to use fn_trace_gettable to import trace file to table

Posted on 2008-10-02
24
Medium Priority
?
1,928 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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.

618 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