Unique Statement Report Fails

May 5, 2011 at 4:34 AM

The "unique statements" report is failing when I try to execute it. I have the newest available version of RML utilities. The error is listed below:

    DateTime=2011-05-05T04:29:18.9594470Z
SQLNexus Information: 0 : Loading report: ReadTrace_Main
    DateTime=2011-05-05T04:29:18.9594470Z
SQLNexus Information: 0 : Report loaded.
    DateTime=2011-05-05T04:29:20.2406806Z
SQLNexus Information: 0 : RV drillthrough sync event
    DateTime=2011-05-05T04:29:23.8968838Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Drillthrough
    DateTime=2011-05-05T04:29:23.8968838Z
SQLNexus Information: 0 : Drilling through report: ReadTrace_UniqueStmtTopN
    DateTime=2011-05-05T04:29:23.8968838Z
SQLNexus Information: 0 : Drilling through report: C:\Documents and Settings\scaldwell\Application Data\SqlNexus\Reports\ReadTrace_UniqueStmtTopN.rdlc
    DateTime=2011-05-05T04:29:23.8968838Z
SQLNexus Critical: 0 : Exception: Must declare the scalar variable "@StartTimeInterval".. Source: .Net SqlClient Data Provider. Stack:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at sqlnexus.fmNexus.FixupDataSources(String filename, String reportname, ReportDataSourceCollection datasources, ReportParameterInfoCollection paramc) in C:\temp\nexus\sqlnexus_codeplex\sqlnexus\fmNexus.cs:line 1259. InnerException: .
    DateTime=2011-05-05T04:29:24.2093798Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Done with Drillthrough
    DateTime=2011-05-05T04:30:27.2085734Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - End
    DateTime=2011-05-05T04:30:27.2085734Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Finally
    DateTime=2011-05-05T04:30:27.2085734Z
SQLNexus Critical: 0 : Exception: A data source instance has not been supplied for the data source 'STMT_TOPN'.. Source: Microsoft.ReportViewer.WinForms. Stack:    at Microsoft.Reporting.WinForms.ReportViewer.RenderReportWithNewParameters(Int32 pageNumber). InnerException: .
    DateTime=2011-05-05T04:30:27.3491966Z

Coordinator
May 5, 2011 at 5:01 PM

Refer http://troubleshootingsql.com/2011/05/05/sql-nexus-what-starttimeinterval/

I just documented the issue here

May 10, 2011 at 12:28 PM

Amitban,

Thanks for the information. I've emailed the address provided but have not heard back. Is this the only fix?

 

Thanks,

Scott

Coordinator
May 12, 2011 at 4:49 PM

Yes. That is the only fix at this point.

Jun 1, 2011 at 12:12 PM

I got the same problem, and emailed support Refer http://troubleshootingsql.com/2011/05/05/sql-nexus-what-starttimeinterval/

I got an RML fix for the issue, but it did not work. I stil get the same error.

Have anybody else got a fix that fixed the problem ?

Thanks

Hans

Coordinator
Jun 13, 2011 at 9:37 PM

Can you check your version of RML Utilities to verify it has been updated? Then check if you can view the report using Reporter which is installed with RML Utilities.

If no, then send the current ReadTrace log to sstlbugs@microsoft.com

Oct 4, 2011 at 8:36 AM

Hello Amit,

    I get the same error. The Reporter version that i'm running is 09.01.0109 (I downloaded recently)

Could you please suggest a fix for this?

Regards..Preethi

Coordinator
Oct 5, 2011 at 6:30 AM

Do you have records in the readtrace.tblStatements and readtrace.tblTimeIntervals tables? If there are records, 9.01.0109 is known to have this issue. Then send the current ReadTrace log to sstlbugs@microsoft.com along with the error message that you are encountering. Refer the complete thread for additional suggestions as well.

Nov 30, 2011 at 12:50 PM

I get the same error. I contact with sstbugs@microsoft.com with this issue because i have hte 09.01.0109 version of RML Utilities. Now i install the RML utilities 09.03.0020 and i´m getting the same error in x86 machine and x64 server. I have records in the readtrace.tblStatements and readtrace.tblTimeIntervals. Today i send an email to microsoft for more help. Any ideas or suggestions? Anybody fix this issue?

Coordinator
Dec 5, 2011 at 1:35 PM

Are you still getting the same messages in the ReadTrace.log showing "Must declare the scalar variable "@StartTimeInterval".." Have you tried re-importing the data using the new version of the RML Utilities? The error shouldn't occur after you import the data again. If it does, please post your Readtrace.log here.

Dec 5, 2011 at 2:21 PM

Hello Amitban,

Yes i tried re-importing the data using the new version of the RML Utilities, and the error persist. I´m on vacation until thursday. Then, i´ll post the error log.

Best Regards,

Roberto.

Dec 9, 2011 at 6:44 AM
Edited Dec 9, 2011 at 8:20 AM

Good Morning

I import a new trace and i get the same error. The error log:

SQLNexus Information: 0 : sqlnexus.exe report directory: C:\SQLNexus3.0.0.0\Reports
    DateTime=2011-12-09T07:14:23.3355954Z
SQLNexus Information: 0 : Instructions report found: C:\SQLNexus3.0.0.0\Reports\Instructions.rdl
    DateTime=2011-12-09T07:14:23.3625981Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Blocking and Wait Statistics.rdl
    DateTime=2011-12-09T07:14:23.3675986Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Bottleneck Analysis.rdl
    DateTime=2011-12-09T07:14:23.3675986Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Instructions.rdl
    DateTime=2011-12-09T07:14:23.3685987Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Realtime - Server Status.rdl
    DateTime=2011-12-09T07:14:23.3685987Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\SQL Server 2000 Perf Stats.rdl
    DateTime=2011-12-09T07:14:23.3685987Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\SQL Server 2005 Perf Stats.rdl
    DateTime=2011-12-09T07:14:23.3685987Z
...

...

    DateTime=2011-12-09T08:08:12.3552227Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
    DateTime=2011-12-09T08:08:12.3582215Z
SQLNexus Information: 0 : Running under WOW
    DateTime=2011-12-09T08:08:12.3722159Z
SQLNexus Information: 0 : Readtrace path C:\Program Files\Microsoft Corporation\RMLUtils
    DateTime=2011-12-09T08:08:12.3752147Z
SQLNexus Information: 0 : readtrace.exe file version 09.03.0020
    DateTime=2011-12-09T08:08:12.3802127Z
SQLNexus Information: 0 : readtrace.exe file version 09.03.0020
    DateTime=2011-12-09T08:08:12.3842111Z
SQLNexus Information: 0 : Extract readtrace report failed with error System.BadImageFormatException: This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded. (Exception from HRESULT: 0x8013101B)
   at System.Reflection.Assembly.nLoadFile(String path, Evidence evidence)
   at System.Reflection.Assembly.LoadFile(String path)
   at ReadTrace.ReadTraceNexusImporter.ExtractReadTraceReports() in C:\temp\nexus\sqlnexus_codeplex\ReadTraceNexusImporter\ReadTraceNexusImporter.cs:line 113
    DateTime=2011-12-09T08:08:12.3862103Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Output trace files (.trc) by SPID to %TEMP%\RML
    DateTime=2011-12-09T08:08:12.3912083Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Output RML files (.rml) to %TEMP%\RML
    DateTime=2011-12-09T08:08:12.3922079Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Assume QUOTED_IDENTIFIER ON
    DateTime=2011-12-09T08:08:12.3922079Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Ignore events associated with PSSDIAG activity
    DateTime=2011-12-09T08:08:12.3932075Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Disable event requirement checks
    DateTime=2011-12-09T08:08:12.3932075Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Enabled -T35 to support MARs
    DateTime=2011-12-09T08:08:12.3942071Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Enabled
    DateTime=2011-12-09T08:08:12.3942071Z
SQLNexus Information: 0 : detecting importer file C:\SQLNexus3.0.0.0\RowsetImportEngine.dll version and creation date 3.0.0.0 lunes, 24 de agosto de 2009
    DateTime=2011-12-09T08:08:12.3962063Z
SQLNexus Information: 0 : load: Rowset Importer (blocker/perf script output).Drop existing tables
    DateTime=2011-12-09T08:08:12.4002047Z
SQLNexus Information: 0 : load: Rowset Importer (blocker/perf script output).Enabled
    DateTime=2011-12-09T08:08:12.4002047Z
SQLNexus Information: 0 : Starting import...
    DateTime=2011-12-09T08:08:13.8316319Z
SQLNexus Warning: 0 : Danger Because you have enabled drop database before importing.  Nexus is about to drop your current database "Nexus_DBIY50GureGida20111130".   This operation can't be recovered.  Are you sure you want to do this?
    DateTime=2011-12-09T08:08:13.8746147Z
SQLNexus Information: 0 : dialog result = Yes
    DateTime=2011-12-09T08:08:14.8452263Z
SQLNexus Warning: 0 : Danger Are you sure you really want to drop database Nexus_DBIY50GureGida20111130?
    DateTime=2011-12-09T08:08:14.9271935Z
SQLNexus Information: 0 : Number of files blocked for import (due to multiple instance or unrelated files such as sqldump*: 0
    DateTime=2011-12-09T08:08:16.3746143Z
SQLNexus Information: 0 : Number of files blocked for import (due to multiple instance or unrelated files such as sqldump*: 0
    DateTime=2011-12-09T08:08:16.3746143Z
SQLNexus Information: 0 : ReadTrace (SQL Profiler TRC Files) is a INexusImporter
    DateTime=2011-12-09T08:08:16.3806119Z
SQLNexus Information: 0 : ReadTrace.exe Path: C:\Program Files\Microsoft Corporation\RMLUtils\readtrace.exe
    DateTime=2011-12-09T08:08:16.3836107Z
SQLNexus Information: 0 : ReadTraceNexusImporter - Starting import...
    DateTime=2011-12-09T08:08:16.3866095Z
SQLNexus Information: 0 : ReadTraceNexusImporter: Loading D:\Trazas\Nexus\DBIY50GureGida20111130.trc
    DateTime=2011-12-09T08:08:16.3946063Z
SQLNexus Information: 0 : ReadTraceNexusImporter: Temp Path: C:\Users\ML24\AppData\Local\Temp\2\
    DateTime=2011-12-09T08:08:16.3976051Z
SQLNexus Information: 0 : ReadTraceNexusImporter: Cmd Line: C:\Program Files\Microsoft Corporation\RMLUtils\readtrace.exe -S"xx\SQL2K5I1" "-dNexus_xx20111130" -E -T18  "-ID:\Trazas\Nexus\xx20111130.trc" -f   "-oC:\Users\ML24\AppData\Local\Temp\2\RML" -H"!PSSDIAG" 
    DateTime=2011-12-09T08:08:16.4006039Z
SQLNexus Information: 0 : ReadTrace exitcode: 0
    DateTime=2011-12-09T08:51:00.1543368Z
SQLNexus Information: 0 : Done. (2563 sec), 227340350 lines processed; 227340350 rows inserted.
    DateTime=2011-12-09T08:51:00.2133427Z
SQLNexus Information: 0 : Executing post-mortem analysis scripts...
    DateTime=2011-12-09T08:51:00.2183432Z
SQLNexus Information: 0 : Execution of post-mortem analysis scripts complete.
    DateTime=2011-12-09T08:51:00.2243438Z
SQLNexus Information: 0 : sqlnexus.exe report directory: C:\SQLNexus3.0.0.0\Reports
    DateTime=2011-12-09T08:51:00.2283442Z
SQLNexus Information: 0 : Instructions report found: C:\SQLNexus3.0.0.0\Reports\Instructions.rdl
    DateTime=2011-12-09T08:51:00.2333447Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Blocking and Wait Statistics.rdl
    DateTime=2011-12-09T08:51:00.2433457Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Bottleneck Analysis.rdl
    DateTime=2011-12-09T08:51:00.2443458Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Instructions.rdl
    DateTime=2011-12-09T08:51:00.2443458Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Realtime - Server Status.rdl
    DateTime=2011-12-09T08:51:00.2443458Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\SQL Server 2000 Perf Stats.rdl
    DateTime=2011-12-09T08:51:00.2453459Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\SQL Server 2005 Perf Stats.rdl
    DateTime=2011-12-09T08:51:00.2453459Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\SQL Server 2008 Perf Stats.rdl
    DateTime=2011-12-09T08:51:00.2453459Z
SQLNexus Information: 0 : Found report:C:\Users\ML24\AppData\Roaming\SqlNexus\Reports\ReadTrace_Main.RDL
    DateTime=2011-12-09T08:51:00.2473461Z
SQLNexus Information: 0 : Import complete. Total import time: 2564 seconds
    DateTime=2011-12-09T08:51:00.2473461Z
SQLNexus Information: 0 : Batches Executed 2

    DateTime=2011-12-09T08:51:37.4670677Z
SQLNexus Information: 0 : Batches Executed 2

    DateTime=2011-12-09T08:51:37.5020712Z
SQLNexus Information: 0 : Loading report: ReadTrace_Main
    DateTime=2011-12-09T08:51:37.5700780Z
SQLNexus Information: 0 : Report loaded.
    DateTime=2011-12-09T08:51:39.6612871Z
SQLNexus Information: 0 : RV link sync event
    DateTime=2011-12-09T08:51:46.5369746Z
SQLNexus Information: 0 : RV drillthrough sync event
    DateTime=2011-12-09T08:52:06.2239431Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Drillthrough
    DateTime=2011-12-09T08:52:06.2239431Z
SQLNexus Information: 0 : Drilling through report: ReadTrace_UniqueBatchTopN
    DateTime=2011-12-09T08:52:06.2239431Z
SQLNexus Information: 0 : Drilling through report: C:\Users\ML24\AppData\Roaming\SqlNexus\Reports\ReadTrace_UniqueBatchTopN.rdlc
    DateTime=2011-12-09T08:52:06.2249432Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Done with Drillthrough
    DateTime=2011-12-09T08:52:07.9941201Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - End
    DateTime=2011-12-09T08:52:07.9941201Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Finally
    DateTime=2011-12-09T08:52:07.9941201Z
SQLNexus Information: 0 : sqlnexus.exe report directory: C:\SQLNexus3.0.0.0\Reports
    DateTime=2011-12-09T08:53:44.1817379Z
SQLNexus Information: 0 : Instructions report found: C:\SQLNexus3.0.0.0\Reports\Instructions.rdl
    DateTime=2011-12-09T08:53:44.2307428Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Blocking and Wait Statistics.rdl
    DateTime=2011-12-09T08:53:44.2377435Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Bottleneck Analysis.rdl
    DateTime=2011-12-09T08:53:44.2377435Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Instructions.rdl
    DateTime=2011-12-09T08:53:44.2387436Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\Realtime - Server Status.rdl
    DateTime=2011-12-09T08:53:44.2387436Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\SQL Server 2000 Perf Stats.rdl
    DateTime=2011-12-09T08:53:44.2387436Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\SQL Server 2005 Perf Stats.rdl
    DateTime=2011-12-09T08:53:44.2397437Z
SQLNexus Information: 0 : Found report:C:\SQLNexus3.0.0.0\Reports\SQL Server 2008 Perf Stats.rdl
    DateTime=2011-12-09T08:53:44.2397437Z
SQLNexus Information: 0 : Found report:C:\Users\ML24\AppData\Roaming\SqlNexus\Reports\ReadTrace_Main.RDL
    DateTime=2011-12-09T08:53:44.2407438Z
SQLNexus Information: 0 : Loading report: Instructions
    DateTime=2011-12-09T08:53:44.2517449Z
SQLNexus Information: 0 : Report loaded.
    DateTime=2011-12-09T08:53:44.5447742Z
SQLNexus Information: 0 : Batches Executed 2

    DateTime=2011-12-09T08:57:36.1419316Z
SQLNexus Information: 0 : Batches Executed 2

    DateTime=2011-12-09T08:57:36.1629337Z
SQLNexus Information: 0 : Loading report: ReadTrace_Main
    DateTime=2011-12-09T08:57:36.2209395Z
SQLNexus Information: 0 : Report loaded.
    DateTime=2011-12-09T08:57:38.2951469Z
SQLNexus Information: 0 : RV drillthrough sync event
    DateTime=2011-12-09T08:57:53.8947067Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Drillthrough
    DateTime=2011-12-09T08:57:53.8947067Z
SQLNexus Information: 0 : Drilling through report: ReadTrace_UniqueStmtTopN
    DateTime=2011-12-09T08:57:53.8947067Z
SQLNexus Information: 0 : Drilling through report: C:\Users\ML24\AppData\Roaming\SqlNexus\Reports\ReadTrace_UniqueStmtTopN.rdlc
    DateTime=2011-12-09T08:57:53.8947067Z
SQLNexus Critical: 0 : Exception: Must declare the scalar variable "@StartTimeInterval".. Source: .Net SqlClient Data Provider. Stack:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at sqlnexus.fmNexus.FixupDataSources(String filename, String reportname, ReportDataSourceCollection datasources, ReportParameterInfoCollection paramc) in C:\temp\nexus\sqlnexus_codeplex\sqlnexus\fmNexus.cs:line 1259. InnerException: .
    DateTime=2011-12-09T08:57:54.6447817Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Done with Drillthrough
    DateTime=2011-12-09T08:57:56.5699742Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - End
    DateTime=2011-12-09T08:57:56.5699742Z
SQLNexus Information: 0 : rvTemplate_Drillthrough - Finally
    DateTime=2011-12-09T08:57:56.5699742Z
SQLNexus Critical: 0 : Exception: A data source instance has not been supplied for the data source 'STMT_TOPN'.. Source: Microsoft.ReportViewer.WinForms. Stack:    at Microsoft.Reporting.WinForms.ReportViewer.RenderReportWithNewParameters(Int32 pageNumber). InnerException: .
    DateTime=2011-12-09T08:57:56.8970069Z

Best Regards,

Roberto.

Dec 9, 2011 at 8:12 AM

READTRACELOG:

12/09/11 09:08:16.474 [0X00002C38] Readtrace a SQL Server trace processing utility.
Version 9.03.0020 built for x64.
Copyright (c) Microsoft Corporation 1997-2011. All rights reserved.
12/09/11 09:08:16.475 [0X00002C38]             Computer: xx
12/09/11 09:08:16.475 [0X00002C38]          Base Module: C:\Program Files\Microsoft Corporation\RMLUtils\readtrace.exe
12/09/11 09:08:16.475 [0X00002C38] Number of processors: 4
12/09/11 09:08:16.475 [0X00002C38]     Active proc mask: 0x0000000F
12/09/11 09:08:16.476 [0X00002C38]         Architecture: 9
12/09/11 09:08:16.476 [0X00002C38]            Page size: 4096
12/09/11 09:08:16.476 [0X00002C38]         Highest node: 1
12/09/11 09:08:16.476 [0X00002C38]         Processor(s): 0x00000001 Function units: Separated
12/09/11 09:08:16.476 [0X00002C38]         Package mask: 0x00000003
12/09/11 09:08:16.476 [0X00002C38]         Processor(s): 0x00000002 Function units: Separated
12/09/11 09:08:16.476 [0X00002C38]         Processor(s): 0x00000004 Function units: Separated
12/09/11 09:08:16.477 [0X00002C38]         Package mask: 0x0000000C
12/09/11 09:08:16.477 [0X00002C38]         Processor(s): 0x00000008 Function units: Separated
12/09/11 09:08:16.478 [0X00002C38]           Processors: 0x00000003 assigned to Numa node: 0
12/09/11 09:08:16.478 [0X00002C38]           Processors: 0x0000000C assigned to Numa node: 1
12/09/11 09:08:16.479 [0X00002C38] -xx\SQL2K5I1
12/09/11 09:08:16.480 [0X00002C38] -dNexus_20111130
12/09/11 09:08:16.481 [0X00002C38] -E
12/09/11 09:08:16.481 [0X00002C38] -T18
12/09/11 09:08:16.482 [0X00002C38] -ID:\Trazas\Nexus\xx20111130.trc
12/09/11 09:08:16.482 [0X00002C38] -f
12/09/11 09:08:16.483 [0X00002C38] -oC:\Users\ML24\AppData\Local\Temp\2\RML
12/09/11 09:08:16.483 [0X00002C38] -H!PSSDIAG
12/09/11 09:08:16.484 [0X00002C38] Using language id (LCID): 1024 [Spanish_Spain.1252] for character formatting with NLS: 0x00060101 and Defined: 0x00060101
12/09/11 09:08:16.485 [0X00002C38] <FILTER>
 <COLUMN NAME="HOST">
  <AND>
   <ARGUMENT>
    <TYPE>NOT EQUAL<TYPE>
    <VALUE>PSSDIAG<VALUE>
   </ARGUMENT>
  </AND>
 </COLUMN>
</FILTER>
12/09/11 09:08:16.487 [0X00002C38] Attempting to cleanup existing RML files from previous execution
12/09/11 09:08:16.488 [0X00002C38] Using extended RowsetFastload synchronization
12/09/11 09:08:16.489 [0X00002C38] Establishing initial database connection:
12/09/11 09:08:16.489 [0X00002C38] Server: xx\SQL2K5I1
12/09/11 09:08:16.490 [0X00002C38] Database: Nexus_20111130
12/09/11 09:08:16.490 [0X00002C38] Authentication: Windows
12/09/11 09:08:16.608 [0X00002C38] Using SQL Client version 10
12/09/11 09:08:16.609 [0X00002C38] Creating or clearing the performance database
12/09/11 09:08:18.353 [0X00002C38] Processing file: D:\Trazas\Nexus\xx20111130.trc (SQL 2005)
12/09/11 09:08:18.355 [0X00002C38] Validating core events exist
12/09/11 09:08:18.356 [0X00002C38] Validating necessary events exist for analysis
12/09/11 09:08:18.356 [0X00002C38] WARNING: The following trace events were not captured: [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.
12/09/11 09:08:18.385 [0X00002C38] Events Read: 1000 Queued: 317 Processed/sec: 354
12/09/11 09:08:18.410 [0X00002C38] Events Read: 2000 Queued: 541 Processed/sec: 748
12/09/11 09:08:18.426 [0X00002C38] Events Read: 3000 Queued: 697 Processed/sec: 1172
12/09/11 09:08:18.440 [0X00002C38] Events Read: 4000 Queued: 989 Processed/sec: 1521
12/09/11 09:08:18.462 [0X00002C38] Events Read: 5000 Queued: 813 Processed/sec: 2092

...

...

12/09/11 09:29:26.482 [0X00002C38] Events Read: 44025000 Queued: 34615 Processed/sec: 34633
12/09/11 09:29:26.821 [0X00002C38] Events Read: 44050000 Queued: 34599 Processed/sec: 34643
12/09/11 09:29:27.174 [0X00002C38] Events Read: 44075000 Queued: 34643 Processed/sec: 34653
12/09/11 09:29:27.512 [0X00002C38] Events Read: 44100000 Queued: 34641 Processed/sec: 34664
12/09/11 09:29:27.674 [0X00002C38] ERROR: CTraceIO::ReadColumnData failure retrieving data for column 1 operating system error 0x80070026 (Reached the end of the file. ). Asked for 4878 bytes got 2989
12/09/11 09:29:27.674 [0X00002C38] ERROR: Reading data for column 1 with operating system error 0x80070026 (Reached the end of the file. )
12/09/11 09:29:27.682 [0X00002C38] Reads completed
12/09/11 09:29:27.683 [0X00002C38] Signaling worker threads to complete final actions.
12/09/11 09:29:27.683 [0X00002C38] Waiting for the worker threads to complete final actions.
12/09/11 09:29:28.330 [0X00002C38] Performing general cleanup actions.
12/09/11 09:29:28.330 [0X00002C38] Reducing cached memory.
12/09/11 09:29:28.674 [0X00002C38] Total Events Processed: 44111540
12/09/11 09:29:28.674 [0X00002C38]  Total Events Filtered: 0
12/09/11 09:29:28.714 [0X00002C38] Table ReadTrace.tblUniqueBatches: loaded ~88 rows
12/09/11 09:29:28.719 [0X00002C38] Table ReadTrace.tblUniqueStatements: loaded ~540 rows
12/09/11 09:29:28.719 [0X00002C38] Table ReadTrace.tblUniquePlans: loaded ~0 rows
12/09/11 09:29:28.720 [0X00002C38] Table ReadTrace.tblUniquePlanRows: loaded ~0 rows
12/09/11 09:29:28.845 [0X00002C38] Table ReadTrace.tblBatches: loaded ~375969 rows
12/09/11 09:29:28.995 [0X00002C38] Table ReadTrace.tblStatements: loaded ~20427373 rows
12/09/11 09:29:28.996 [0X00002C38] Table ReadTrace.tblPlans: loaded ~0 rows
12/09/11 09:29:28.997 [0X00002C38] Table ReadTrace.tblPlanRows: loaded ~0 rows
12/09/11 09:29:29.006 [0X00002C38] Table ReadTrace.tblInterestingEvents: loaded ~22 rows
12/09/11 09:29:29.007 [0X00002C38] Table ReadTrace.tblConnections: loaded ~0 rows
12/09/11 09:29:29.013 [0X00002C38] WARNING: One or more warning conditions exist that may affect the quality of the analysis data.  See Nexus_DBIY50GureGida20111130.ReadTrace.tblWarnings table and the ReadTrace log for complete details.
12/09/11 09:29:29.023 [0X00002C38] Indexing tables...
12/09/11 09:33:26.468 [0X00002C38] Doing post-load data cleanup...
12/09/11 09:33:52.638 [0X00002C38] Computing partial aggregates...
12/09/11 09:50:57.780 [0X00002C38] Data load completed.
12/09/11 09:50:57.782 [0X00002C38] Using execution path: C:\Program Files\Microsoft Corporation\RMLUtils\
12/09/11 09:50:57.785 [0X00002C38] Launching [C:\Program Files\Microsoft Corporation\RMLUtils\Reporter.exe]
12/09/11 09:50:59.988 [0X00002C38] *******************************************************************************
* 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.                                            *
*******************************************************************************

Coordinator
Dec 14, 2011 at 4:03 PM

This is not the same issue that you reported earlier. The trace file load failed. Can you check if the Trace File can be loaded using fn_trace_gettable function successfully?

Also the installation wasn't successful as the Assembly load for reading the imported data through the report failed in the first log file contents that you posted with the 'System.BadImageFormatException'. Can you install the .NET 3.5 or .NET 4.0 on the system to see if this error is avoided?

Dec 14, 2011 at 5:07 PM

Hi amitban,

First Question: Yes, the same trace file can be loaded using fn_trace_gettable without errors.

Second Question: I remember that .NET 4.0 is installed. Tomorrow i´ll review the .NET framework installations. 

Thank you very much for your advices.

Best Regards,

Roberto.

Dec 15, 2011 at 8:04 AM

Good Morning,

Hi amitban, second Question: Validated. We have .NET 4.0 installed on the system. Before installed SQL Nexus version for this version of .NET.

I don´t understand this error: System.BadImageFormatException. Microsoft said the same but nothing more. He gives us the last version of RML utilities and nothing more. I tried with all previous versions of SQL NEXUS and returns with the error of version of RML Utilities.

What do you think about this Test:

- Remove .NET 4.0.

- Restart Server.

- Install .NET 3.5 SP1.

- Install .NET 4.0.

- Reimport trace file.

- Test Unique statement report.

 

Best Regards,

Roberto.

 

Coordinator
Dec 15, 2011 at 1:13 PM

You can install .NET Framework 3.5 SP1 without uninstalling 4.0. I haven't seen the name of the assembly but based on the previous log it seems that the assemblies associated with the report loading is failing. You seem to have gotten past your initial error.