none
Error when trying to process XEL files using READTRACE RRS feed

  • Question

  • Guys,

    Has anyone faced following issue when trying to use readtrace for XEL files processing:

    C:\Program Files\Microsoft Corporation\RMLUtils>readtrace -I"C:\Temp\Workload\XECapture_0_131375779441360000.xel" -M -o"C:\Temp\Output" -T18

    04/26/17 15:29:16.843 [0X000050A8] I/O Completion manager started
    04/26/17 15:29:16.843 [0X000000B8] Attempting DOD5015 removal of [C:\Temp\Output\ReadTrace.log]
    04/26/17 15:29:16.865 [0X000000B8] Readtrace a SQL Server trace processing utility.
    Version 9.04.0051 built for x64.
    Copyright ® 1997-2014 Microsoft. All Rights Reserved
    04/26/17 15:29:16.865 [0X000000B8]             Computer: TEST1
    04/26/17 15:29:16.865 [0X000000B8]          Base Module: C:\Program Files\Microsoft Corporation\RMLUtils\ReadTrace.exe
    04/26/17 15:29:16.865 [0X000000B8]           Process Id: 14732
    04/26/17 15:29:16.865 [0X000000B8]  Active proc mask(0): 0x000000FF
    04/26/17 15:29:16.866 [0X000000B8]         Architecture: 9
    04/26/17 15:29:16.866 [0X000000B8]            Page size: 4096
    04/26/17 15:29:16.866 [0X000000B8]                 CPUs: 8
    04/26/17 15:29:16.866 [0X000000B8]     Processor groups: 1
    04/26/17 15:29:16.866 [0X000000B8]         Highest node: 0
    04/26/17 15:29:16.866 [0X000000B8]   Proximity: 00  Node: 00
    04/26/17 15:29:16.866 [0X000000B8] ---------------------------------------
    04/26/17 15:29:16.866 [0X000000B8]                Group: 0
    04/26/17 15:29:16.866 [0X000000B8] ---------------------------------------
    04/26/17 15:29:16.867 [0X000000B8]         Processor(s): 0x00000003 Function units: Shared
    04/26/17 15:29:16.867 [0X000000B8]         Processor(s): 0x0000000C Function units: Shared
    04/26/17 15:29:16.867 [0X000000B8]         Processor(s): 0x00000030 Function units: Shared
    04/26/17 15:29:16.867 [0X000000B8]         Package mask: 0x000000FF
    04/26/17 15:29:16.867 [0X000000B8]         Processor(s): 0x000000C0 Function units: Shared
    04/26/17 15:29:16.867 [0X000000B8]         Processor(s): 0x000000FF assigned to Numa node: 0
    04/26/17 15:29:16.867 [0X000000B8] Current time bias: -120 minutes -2.00 hours DST Adjusted Srodkowoeuropejski czas letni
    04/26/17 15:29:16.867 [0X000000B8] -IC:\Temp\Workload\XECapture_0_131375779441360000.xel
    04/26/17 15:29:16.867 [0X000000B8] -M
    04/26/17 15:29:16.868 [0X000000B8] -oC:\Temp\Output
    04/26/17 15:29:16.868 [0X000000B8] -T18
    04/26/17 15:29:16.868 [0X000000B8] Using language id (LCID): 1024 [English_United Kingdom.1252] for character formatting with NLS: 0x0006020E and Defined: 0x0006020E
    04/26/17 15:29:16.868 [0X000000B8] Attempting to cleanup existing RML files from previous execution
    04/26/17 15:29:16.868 [0X000000B8] Using extended RowsetFastload synchronization
    04/26/17 15:29:16.869 [0X000000B8] Establishing initial database connection
    04/26/17 15:29:16.869 [0X000000B8] Server: (local)
    04/26/17 15:29:16.869 [0X000000B8] Database: PerfAnalysis
    04/26/17 15:29:16.869 [0X000000B8] Authentication: Windows
    04/26/17 15:29:16.891 [0X000000B8] Using SQLOLEDB version 11.0.6518.0
    04/26/17 15:29:16.892 [0X000000B8] Connected to SQL Server Version, Major: 13, Minor: 0, Build: 1728
    04/26/17 15:29:16.892 [0X000000B8] Creating or clearing the performance database
    04/26/17 15:29:17.374 [0X000000B8] Detecting list of matching XEL files in the same directory
    04/26/17 15:29:17.394 [0X000000B8]  INFO: Using additional file system cache read ahead for XEL input
    04/26/17 15:29:17.403 [0X000000B8] XEL READER ERROR: The tookLock argument must be set to false before calling this method.
    04/26/17 15:29:17.404 [0X000000B8] XEL READER ERROR: Attempt to open file C:\Temp\Workload\XECapture_0_131375779441360000.XEL failed, see previous error(s) for more details.
    04/26/17 15:29:17.404 [0X000000B8] ERROR: Attempt to open C:\Temp\Workload\XECapture_0_131375779441360000.XEL failed.
    04/26/17 15:29:17.405 [0X000000B8] ERROR: Unable to construct proper base metadata generation for C:\Temp\Workload\XECapture_0_131375779441360000.XEL
    04/26/17 15:29:17.405 [0X000000B8] ERROR: Attempt to determine list of .XEL files failed.
    04/26/17 15:29:17.405 [0X000000B8] *** ERROR: Attempt to initialize trace file reader failed with operating system error 0x80070006 (The handle is invalid)
    04/26/17 15:29:17.411 [0X000000B8] Reads completed - Global Error Status 0xfffffffe
    04/26/17 15:29:17.411 [0X000000B8] Signaling worker threads to complete final actions.
    04/26/17 15:29:17.412 [0X000000B8] Waiting for the worker threads to complete final actions.
    04/26/17 15:29:17.415 [0X000000B8] Performing general cleanup actions.
    04/26/17 15:29:17.416 [0X000000B8] Performing final mirroring actions.
    04/26/17 15:29:17.417 [0X000000B8] Total Events Processed: 0
    04/26/17 15:29:17.417 [0X000000B8]  Total Events Filtered: 0
    04/26/17 15:29:17.418 [0X000000B8] ==============================================
    04/26/17 15:29:17.418 [0X000000B8] WARNING: A significant portion of the events where filtered.
    04/26/17 15:29:17.419 [0X000000B8]          You may want to check the filtering criteria.
    04/26/17 15:29:17.419 [0X000000B8] ==============================================
    04/26/17 15:29:17.420 [0X000000B8] *******************************************************************************
    * 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/26/17 15:29:17.421 [0X000000B8] ***** ReadTrace exit code: -2
    04/26/17 15:29:17.422 [0X000000B8]  INFO: Max set-aside XEL event hash table entry count: 0
    04/26/17 15:29:17.434 [0X000000B8]
    04/26/17 15:29:17.437 [0X000000B8] INFO: Cleaning up unique batch hash table
    04/26/17 15:29:17.438 [0X000000B8] INFO: Cleaning up unique statement hash table
    04/26/17 15:29:17.438 [0X000000B8] INFO: Cleaning up unique plan hash table
    04/26/17 15:29:17.439 [0X000000B8] INFO: Cleaning up unique procedure hash table
    04/26/17 15:29:17.442 [0X000000B8] INFO: Cleaning up connection info hash table


    Wednesday, April 26, 2017 1:35 PM

All replies