This project is read-only.
2
Vote

Error reading trace file

description

Hi All
 
I am getting the following error when SQLNexus (actually ReadTrace) is reading my trace file. My environment is:
 
Windows 2008 R2
SQL 2008 R2
SQL 2005 with SP 4 (I thought it would not work with 2008 so installed 2005)
 
Would appreciate your help
 
Thanks
 
Tariq
 
 
12/21/10 18:00:29.794 [0X00000DE8] Readtrace a SQL Server trace processing utility.
Version 9.01.0109 built for x64.
Copyright (c) Microsoft Corporation 1997-2008. All rights reserved.
12/21/10 18:00:29.811 [0X00000DE8] Number of processors: 2
12/21/10 18:00:29.812 [0X00000DE8] Active proc mask: 0x00000003
12/21/10 18:00:29.812 [0X00000DE8] Architecture: 9
12/21/10 18:00:29.812 [0X00000DE8] Page size: 4096
12/21/10 18:00:29.812 [0X00000DE8] Highest node: 0
12/21/10 18:00:29.813 [0X00000DE8] Processor(s): 0x00000001 Function units: Separated
12/21/10 18:00:29.813 [0X00000DE8] Package mask: 0x00000003
12/21/10 18:00:29.814 [0X00000DE8] Processor(s): 0x00000002 Function units: Separated
12/21/10 18:00:29.814 [0X00000DE8] Processors: 0x00000003 assigned to Numa node: 0
12/21/10 18:00:29.816 [0X00000DE8] -SServer1\DB1
12/21/10 18:00:29.816 [0X00000DE8] -dsqlnexus
12/21/10 18:00:29.817 [0X00000DE8] -E
12/21/10 18:00:29.817 [0X00000DE8] -T18
12/21/10 18:00:29.817 [0X00000DE8] -IC:\temp\perfresults\Server1_SQLDIAG_SQLEXPRESS_sp_trace.trc
12/21/10 18:00:29.818 [0X00000DE8] -f
12/21/10 18:00:29.819 [0X00000DE8] -oC:\Users\Tariq\AppData\Local\Temp\1\RML
12/21/10 18:00:29.819 [0X00000DE8] -H!PSSDIAG
12/21/10 18:00:29.821 [0X00000DE8] Using language id (LCID): 1024 [English_United States.1252] for character formatting with NLS: 0x00060101 and Defined: 0x00060101
12/21/10 18:00:29.824 [0X00000DE8] <FILTER>
<COLUMN NAME="HOST">
    <AND>
        <ARGUMENT>
            <TYPE>NOT EQUAL<TYPE>
            <VALUE>PSSDIAG<VALUE>
        </ARGUMENT>
    </AND>
</COLUMN>
</FILTER>
12/21/10 18:00:29.829 [0X00000DE8] Attempting to cleanup existing RML files from previous execution
12/21/10 18:00:29.830 [0X00000DE8] Using extended RowsetFastload synchronization
12/21/10 18:00:29.830 [0X00000DE8] Establishing initial database connection:
12/21/10 18:00:29.832 [0X00000DE8] Server: SERVER1\DB1
12/21/10 18:00:29.833 [0X00000DE8] Database: sqlnexus
12/21/10 18:00:29.834 [0X00000DE8] Authentication: Windows
12/21/10 18:00:30.105 [0X00000DE8] Using SQL Client version 10
12/21/10 18:00:30.106 [0X00000DE8] Creating or clearing the performance database
12/21/10 18:00:33.679 [0X00000DE8] *** ERROR: Attempt to initialize trace file reader failed with operating system error 0x80070005 (Access is denied)
12/21/10 18:00:33.682 [0X00000DE8] Reads completed - Global Error Status 0xffffffe6
12/21/10 18:00:33.683 [0X00000DE8] Shutting down the worker thread message queues.
12/21/10 18:00:33.683 [0X00000DE8] Waiting for the worker threads to complete final actions.
12/21/10 18:00:33.684 [0X00000DE8] Performing general cleanup actions.
12/21/10 18:00:33.684 [0X00000DE8] Total Events Processed: 0
12/21/10 18:00:33.686 [0X00000DE8] Total Events Filtered: 0
12/21/10 18:00:33.686 [0X00000DE8] Parse errors: 0
12/21/10 18:00:33.687 [0X00000DE8] *******************************************************************************
  • 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. *

12/21/10 18:00:33.691 [0X00000DE8] ***** ReadTrace exit code: -26

file attachments

comments

amitban wrote Dec 28, 2010 at 5:36 PM

Did you check if the account running the readtrace has the necessary permissions to import the file? And if yes, have you tried running the profiler trace import with -T35 enabled in SQL Nexus. If that also fails, can you send an email to sstlbugs@microsoft.com along with the ReadTrace.log file.

peregrino wrote Mar 31, 2011 at 1:36 PM

Hello! I had the same problem.

My environment is:
Windows 2008
SQL 2008 SP1


The problem persists if I try to read the trace with -T35 enabled.

Please, I need a solution urgently. Thanks!

amitban wrote Mar 31, 2011 at 2:42 PM

Please add full permissions on the folder/files for the account that is running the SQL Nexus/ReadTrace. As you can see that the above error is pointing to an Access Denied message. Post back the new log file once the you have implemented this action item.

wrote Mar 31, 2011 at 3:01 PM

peregrino wrote Mar 31, 2011 at 3:01 PM

What is the account running the SQL Nexus / ReadTrace? Mine? My user account is the server admin. In the folder where the output of SQLDiag (SQLDiagOutput) also co-owner permissions startup accounts of the agent and the SQL engine.

wrote Mar 31, 2011 at 3:24 PM

amitban wrote Mar 31, 2011 at 4:20 PM

The account that you launch SQL Nexus with. Profiler trace files modify the ACLs while saving the files due to security reasons. You need to reset the file ACLs if the account running Nexus if it is not already done.

peregrino wrote Mar 31, 2011 at 4:51 PM

I launch SQLNexus. I'm the server administrator, and the owner of the folder SQLDiagOutput. In that folder are co-owners accounts that start the engine and SQL Agent. What else folder should I check ?

Thanks!

amitban wrote Mar 31, 2011 at 5:31 PM

Can you check the onwer of the trace file that you are trying to import? Your account should have full permissions on that file.

amitban wrote Mar 31, 2011 at 5:31 PM

Also, can you post the latest Readtrace.log file?

wrote Mar 31, 2011 at 5:43 PM

peregrino wrote Mar 31, 2011 at 5:43 PM

It is always the same, no change.

peregrino wrote Mar 31, 2011 at 5:57 PM

"Can you check the onwer of the trace file that you are trying to import? Your account should have full permissions on that file."

That's it! I needed the permission of the TRC archive, in addition to the permission on the folder.

Thank you very much! Problem solved!

amitban wrote Mar 31, 2011 at 6:06 PM

Can you check if you can load the trace using fn_trace_gettable function?

peregrino wrote Mar 31, 2011 at 6:12 PM

Problem solved, amitban. Thank you so much.

amitban wrote Mar 31, 2011 at 6:34 PM

Good to know that you got it fixed.

wrote Feb 22, 2013 at 12:49 AM