Not able to import trace files in SQLNexus

Apr 21, 2014 at 9:01 AM
I am getting following error while importing trace files in SQL nexus generated via SQLDiag
Pls help.
__04/20/14 13:04:25.369 [0X0000079C] ERROR: Performance analysis has been disabled because none of the required events were captured. Consult the help file for the recommended set of trace events and necessary columns.
04/20/14 13:04:25.371 [0X0000079C] ERROR: Aggregation has been disabled and RML output was not elected. No further processing needed.
04/20/14 13:04:25.372 [0X0000079C] *** ERROR: Attempt to initialize trace file reader failed with operating system error 0x80004005 (Unspecified error)
04/20/14 13:04:25.373 [0X0000079C] Reads completed - Global Error Status 0xfffffffe
__

following is complete readtrace log

04/20/14 13:04:24.656 [0X0000079C] Readtrace a SQL Server trace processing utility.
Version 9.04.0004 built for x86.
Copyright © 1997-2013 Microsoft. All Rights Reserved
04/20/14 13:04:24.656 [0X0000079C] Computer: LP-2C41380166CA
04/20/14 13:04:24.671 [0X0000079C] Base Module: C:\Program Files\Microsoft Corporation\RMLUtils\readtrace.exe
04/20/14 13:04:24.671 [0X0000079C] Process Id: 7408
04/20/14 13:04:24.671 [0X0000079C] Active proc mask(0): 0x0000000F
04/20/14 13:04:24.671 [0X0000079C] Architecture: 0
04/20/14 13:04:24.671 [0X0000079C] Page size: 4096
04/20/14 13:04:24.671 [0X0000079C] CPUs: 4
04/20/14 13:04:24.671 [0X0000079C] Processor groups: 1
04/20/14 13:04:24.672 [0X0000079C] Highest node: 0
04/20/14 13:04:24.672 [0X0000079C] ---------------------------------------
04/20/14 13:04:24.672 [0X0000079C] Group: 0
04/20/14 13:04:24.672 [0X0000079C] ---------------------------------------
04/20/14 13:04:24.672 [0X0000079C] Processor(s): 0x00000003 Function units: Shared
04/20/14 13:04:24.672 [0X0000079C] Package mask: 0x0000000F
04/20/14 13:04:24.672 [0X0000079C] Processor(s): 0x0000000C Function units: Shared
04/20/14 13:04:24.673 [0X0000079C] Processor(s): 0x0000000F assigned to Numa node: 0
04/20/14 13:04:24.674 [0X0000079C] Current time bias: -330 minutes -5.50 hours DST not used
04/20/14 13:04:24.674 [0X0000079C] -SLP-2C41380166CA
04/20/14 13:04:24.675 [0X0000079C] -dsqlnexus
04/20/14 13:04:24.675 [0X0000079C] -E
04/20/14 13:04:24.675 [0X0000079C] -T18
04/20/14 13:04:24.676 [0X0000079C] -IC:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLDIAG\log_12.trc
04/20/14 13:04:24.676 [0X0000079C] -f
04/20/14 13:04:24.676 [0X0000079C] -oC:\Users\raj.krai\AppData\Local\Temp\RML
04/20/14 13:04:24.677 [0X0000079C] -H!PSSDIAG
04/20/14 13:04:24.678 [0X0000079C] Using language id (LCID): 1024 [English_United States.1252] for character formatting with NLS: 0x0006020D and Defined: 0x0006020D
04/20/14 13:04:24.679 [0X0000079C] <FILTER>
<COLUMN NAME="HOST">
    <AND>
        <ARGUMENT>
            <TYPE>NOT EQUAL<TYPE>
            <VALUE>PSSDIAG<VALUE>
        </ARGUMENT>
    </AND>
</COLUMN>
</FILTER>
04/20/14 13:04:24.680 [0X0000079C] Attempting to cleanup existing RML files from previous execution
04/20/14 13:04:24.681 [0X0000079C] Using extended RowsetFastload synchronization
04/20/14 13:04:24.681 [0X0000079C] Establishing initial database connection
04/20/14 13:04:24.681 [0X0000079C] Server: LP-2C41380166CA
04/20/14 13:04:24.682 [0X0000079C] Database: sqlnexus
04/20/14 13:04:24.684 [0X0000079C] Authentication: Windows
04/20/14 13:04:24.716 [0X0000079C] Using SQLOLEDB version 11.0.2100.60
04/20/14 13:04:24.719 [0X0000079C] Connected to SQL Server Version, Major: 11, Minor: 0, Build: 2100
04/20/14 13:04:24.719 [0X0000079C] Creating or clearing the performance database
04/20/14 13:04:25.362 [0X0000079C] Processing file: C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLDIAG\log_12.trc (SQL 2012 / SQL Azure*)
04/20/14 13:04:25.363 [0X0000079C] Validating core events exist
04/20/14 13:04:25.364 [0X0000079C] Validating necessary events exist for analysis
04/20/14 13:04:25.365 [0X0000079C] WARNING: The following trace events were not captured: [SQL:BatchStarting, SQL:BatchCompleted, RPC:Starting, RPC:Completed, SP:StmtStarting, SP:StmtCompleted, Audit:Login, Audit:Logout, Showplan Statistics]. Review the help file to ensure that you have collected the appropriate set of events and columns for your intended analysis.
04/20/14 13:04:25.367 [0X0000079C] ***************************************************************
04/20/14 13:04:25.368 [0X0000079C] WARNING: [Session: 0 Request: 0] Disabling aggregation operations.
04/20/14 13:04:25.369 [0X0000079C] ***************************************************************
04/20/14 13:04:25.369 [0X0000079C] ERROR: Performance analysis has been disabled because none of the required events were captured. Consult the help file for the recommended set of trace events and necessary columns.
04/20/14 13:04:25.371 [0X0000079C] ERROR: Aggregation has been disabled and RML output was not elected. No further processing needed.
04/20/14 13:04:25.372 [0X0000079C] *** ERROR: Attempt to initialize trace file reader failed with operating system error 0x80004005 (Unspecified error)
04/20/14 13:04:25.373 [0X0000079C] Reads completed - Global Error Status 0xfffffffe
04/20/14 13:04:25.374 [0X0000079C] Signaling worker threads to complete final actions.
04/20/14 13:04:25.375 [0X0000079C] Waiting for the worker threads to complete final actions.
04/20/14 13:04:25.376 [0X0000079C] Performing general cleanup actions.
04/20/14 13:04:25.377 [0X0000079C] Total Events Processed: 1
04/20/14 13:04:25.378 [0X0000079C] Total Events Filtered: 0
04/20/14 13:04:25.379 [0X0000079C] *******************************************************************************
  • 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/20/14 13:04:25.380 [0X0000079C] ***** ReadTrace exit code: -2