asked
RML Utilties File Error
I'm just trying to run the readtrace command on a new install of the RML utilities. Here is the command line: C:\Program Files\Microsoft Corporation\RMLUtils>readtrace.exe -I"D:\Perf\R MLTest.trc" -o"D:\perf\rmlout" -S"server\instance" The error is that the file can't be found. It makes no sense the file is there. I've changed the security on the directory so that all users have full control and I've checked each file in the directory to be sure they're good. I'm stuck. Here's the log: 04/29/11 13:48:14.396 [0X00002118] Readtrace a SQL Server trace processing utility. Version 9.01.0109 built for x64. Copyright (c) Microsoft Corporation 1997-2008. All rights reserved. 04/29/11 13:48:14.396 [0X00002118] Number of processors: 4 04/29/11 13:48:14.396 [0X00002118] Active proc mask: 0x0000000F 04/29/11 13:48:14.396 [0X00002118] Architecture: 9 04/29/11 13:48:14.396 [0X00002118] Page size: 4096 04/29/11 13:48:14.396 [0X00002118] Highest node: 0 04/29/11 13:48:14.396 [0X00002118] Processor(s): 0x00000001 Function units: Separated 04/29/11 13:48:14.396 [0X00002118] Processor(s): 0x00000002 Function units: Separated 04/29/11 13:48:14.396 [0X00002118] Processor(s): 0x00000004 Function units: Separated 04/29/11 13:48:14.396 [0X00002118] Package mask: 0x0000000F 04/29/11 13:48:14.396 [0X00002118] Processor(s): 0x00000008 Function units: Separated 04/29/11 13:48:14.396 [0X00002118] Processors: 0x0000000F assigned to Numa node: 0 04/29/11 13:48:14.396 [0X00002118] -ID:\Perf\RMLTest.trc 04/29/11 13:48:14.396 [0X00002118] -oD:\perf\rmlout 04/29/11 13:48:14.396 [0X00002118] -SSERVER\INSTANCE 04/29/11 13:48:14.396 [0X00002118] Using language id (LCID): 1024 [English_United States.1252] for character formatting with NLS: 0x00060101 and Defined: 0x00060101 04/29/11 13:48:14.396 [0X00002118] Attempting to cleanup existing RML files from previous execution 04/29/11 13:48:14.396 [0X00002118] Using extended RowsetFastload synchronization 04/29/11 13:48:14.396 [0X00002118] Establishing initial database connection: 04/29/11 13:48:14.396 [0X00002118] Server: Server/Instance 04/29/11 13:48:14.396 [0X00002118] Database: PerfAnalysis 04/29/11 13:48:14.396 [0X00002118] Authentication: Windows 04/29/11 13:48:14.431 [0X00002118] Using SQL Client version 10 04/29/11 13:48:14.431 [0X00002118] Creating or clearing the performance database 04/29/11 13:48:15.577 [0X00002118] *** ERROR: D:\Perf\RMLTest.trc - File Not Found 04/29/11 13:48:15.577 [0X00002118] Reads completed - Global Error Status 0xfffffffe 04/29/11 13:48:15.577 [0X00002118] Shutting down the worker thread message queues. 04/29/11 13:48:15.578 [0X00002118] Waiting for the worker threads to complete final actions. 04/29/11 13:48:15.578 [0X00002118] Performing general cleanup actions. 04/29/11 13:48:15.578 [0X00002118] Total Events Processed: 0 04/29/11 13:48:15.578 [0X00002118] Total Events Filtered: 0 04/29/11 13:48:15.578 [0X00002118] Parse errors: 0 04/29/11 13:48:15.578 [0X00002118] ******************************************************************************* * ReadTrace encountered one or more ERRORS. An error condition typically * * stops processing early and the ReadTrace output may be unusable. * * Review the log file for details. * ******************************************************************************* 04/29/11 13:48:15.579 [0X00002118] ***** ReadTrace exit code: -2
A couple of points. I've modified security on the folder and the file in question so that full control is available to all users since security might have been the issue. I've also tried running the utilities from the regular command line and as system admin.
Of course another issue might be the stupidity of the operator. For example, if they were to name the file in the trace 'mytrace.trc' and forget that the file name property in trace is mainly for the path and the name and that adding an extension means that the file name is 'mytrace.trc.trc' would prevent a lot of issues. In short, I screwed that up. Finally figured it out today when I restarted everything and rebuilt it all from scratch.
I beat my head bloody on this one and it was such a stupid error. Sometimes I do hate the way Win 7 displays files.
Are you able to load the first file using fn_trace_gettable? If yes, then can you re-ACL the .TRC files and grant FULL permissions to the file that is running the ReadTrace.exe. If that doesn't help, then I would suggest a ProcessMonitor trace with a filter on ReadTrace.exe under "Process Name".
Nailed it. WEll, partly. I can't open the file using fn_trace_gettable. That narrows it down some.
Still not 100%. I think I'm dealing with a corrupted trace file. I'm going back to square 1.
