6

Closed

Error when importing *.trc: The system cannot find the file specified

description

When I attempt to import files, and error is generated "The system cannot find the file specified" at the *.trc step. I have SQL Server Express along with a default SQL Server 2005 Developer addition running on the system I'm testing this on. I do see a file named: LSHUCK01__sp_trace.trc in the SQLDiagOutput directory.
 
A screen shot is attached.
 
Thanks,
 
Lee

file attachments

Closed Sep 3, 2008 at 6:55 PM by jackli

comments

jackli wrote Feb 26, 2008 at 2:50 PM

It appears that SQL Nexus wasn't able to find out readtrace.exe. there are a few fixes in the latest bits. try to download it and see if it works for you.

philcruz wrote Apr 18, 2008 at 8:41 PM

I'm getting the same error with version 2.5.0.3. Any ideas?

qlam wrote May 15, 2008 at 1:55 PM

I have the same error and would like to know when this issue is fixed. Thx

LeeShuck wrote May 29, 2008 at 9:28 PM

Yep - still having the issue with 2.5.0.3. I've attached a screen shot from this version.

Lee

binsel wrote Jul 8, 2008 at 10:10 PM

Any update on this error?

sqldba65 wrote Aug 1, 2008 at 3:45 PM

I am having the same problem but with 2.5.0.4. I am using Profiler generated .trc files, not SQLDiag.

Interesting Point: I did successfully load a .trc file which was 5MB. But anything larger SQLNexus will not load.

Any thoughts?

abean wrote Aug 15, 2008 at 7:15 PM

Any update on this issue? I am having the same problem with 2.5.0.5. Whether I use trace files output from PSSDiag or I take it manually, they both result in the same error as described from the topic creator.

jackli wrote Aug 15, 2008 at 9:23 PM

You may have old RML installed for sql server 2000.
try these steps:
1) go to add/remove programs and uninstall old RML program
2) then download latest http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en and install it. this should over-write the registry key to use the latest.
3) If you had installed http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en, go to C:\Program Files\Microsoft Corporation\RMLUtils and do orca.exe /R from there.
note that this assumes you are using 32 bit. if you are on x64, you need to download 64 bit readtrace

abean wrote Aug 19, 2008 at 1:27 PM

jackli - Thank you, that's exactly what it was.