SQL Nexus - error in log though import shows success

Dec 30, 2010 at 5:07 PM

I am trying to load a Perfmon file (.blg) and it says successful on the gui (loads in 0 seconds which is odd since the file is 18 meg).  When I check the Nexus log file I find:

 

SQLNexus Information: 0 : Found report:C:\Documents and Settings\lgrob01\Application Data\SqlNexus\Reports\ReadTrace_Main.RDL
    DateTime=2010-12-30T18:00:46.7762236Z
SQLNexus Information: 0 : Import complete. Total import time: 0 seconds
    DateTime=2010-12-30T18:00:46.7762236Z
SQLNexus Error: 0 : System.Data.SqlClient.SqlException: Invalid object name 'ReadTrace.tblTimeIntervals'.
   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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at NexusInterfaces.CSql.ExecuteBatches(String[] batches) in C:\temp\nexus\sqlnexus_codeplex\NexusInterfaces\CSql.cs:line 102
Batches Executed 2

    DateTime=2010-12-30T18:01:50.6269198Z
SQLNexus Information: 0 : The database doesn't have necessary data to run this report
    DateTime=2010-12-30T18:01:50.6269198Z
SQLNexus Information: 0 : Loading report: Instructions
    DateTime=2010-12-30T18:01:52.5646306Z
SQLNexus Information: 0 : Report loaded.
    DateTime=2010-12-30T18:01:52.8615379Z
SQLNexus Error: 0 : System.Data.SqlClient.SqlException: Invalid object name 'ReadTrace.tblTimeIntervals'.
   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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at NexusInterfaces.CSql.ExecuteBatches(String[] batches) in C:\temp\nexus\sqlnexus_codeplex\NexusInterfaces\CSql.cs:line 102
Batches Executed 2

    DateTime=2010-12-30T18:01:53.3303389Z

 

When I check the Nexus db it only has one table created with one row which it creates when I connect (my configuration is I am running SQL Nexus from my laptop and connecting to a SQL 2005 named instance on a non prod server).

 

Any suggestions?

Coordinator
Dec 30, 2010 at 5:13 PM

The BLG import in SQL Nexus currently has issues. That being said the above log messages are only telling you that the SQL profiler data required to view the reports was not present. SQL Nexus currently has reports to view only data collected using SQL Profiler traces (via RML Utilities) and certain DMV outputs collected by SQLDIAG/PSSDIAG. There are no reports available for Perfmon files.

If you could attach the complete SQLNexus log, I can look at where the import possibly failed. Did the folder contain other files as well other than the .BLG file that SQL Nexus failed to import?

Have you tried using PAL for generating reports for Perfmon data: http://pal.codeplex.com/?

Dec 30, 2010 at 5:24 PM
That explains it.. didn't know it had issues with the blg files (tried relogging to a csv as well). I have been using PAL (in fact just upgraded to the newest version yesterday) but, was curious to see what additional SQL Nexus might provide and the reports were definitely of interest.
Here is the full log:
SQLNexus Information: 0 : sqlnexus.exe running at: C:\Program Files\SQLNexus3.0.0.0\sqlnexus.exe version 3.0.0.0
DateTime=2010-12-30T18:19:07.2534795Z
SQLNexus Information: 0 : This is a beta version
DateTime=2010-12-30T18:19:07.2534795Z
SQLNexus Information: 0 : AutoUpdate: Application is not running as part of a ClickOnce deployment
DateTime=2010-12-30T18:19:07.2534795Z
SQLNexus Information: 0 : Successfully opened a connection to server wdh107nwsql02\instance1 from workstation BSCWL613583
DateTime=2010-12-30T18:19:10.3939839Z
SQLNexus Information: 0 : sqlnexus.exe report directory: C:\Program Files\SQLNexus3.0.0.0\Reports
DateTime=2010-12-30T18:19:11.1283307Z
SQLNexus Information: 0 : Instructions report found: C:\Program Files\SQLNexus3.0.0.0\Reports\Instructions.rdl
DateTime=2010-12-30T18:19:11.1439551Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Blocking and Wait Statistics.rdl
DateTime=2010-12-30T18:19:11.1595795Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Bottleneck Analysis.rdl
DateTime=2010-12-30T18:19:11.1595795Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Instructions.rdl
DateTime=2010-12-30T18:19:11.1595795Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Realtime - Server Status.rdl
DateTime=2010-12-30T18:19:11.1595795Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2000 Perf Stats.rdl
DateTime=2010-12-30T18:19:11.1595795Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2005 Perf Stats.rdl
DateTime=2010-12-30T18:19:11.1595795Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2008 Perf Stats.rdl
DateTime=2010-12-30T18:19:11.1595795Z
SQLNexus Information: 0 : Found report:C:\Documents and Settings\lgrob01\Application Data\SqlNexus\Reports\ReadTrace_Main.RDL
DateTime=2010-12-30T18:19:11.1595795Z
SQLNexus Information: 0 : Loading report: Instructions
DateTime=2010-12-30T18:19:11.1908283Z
SQLNexus Information: 0 : Report loaded.
DateTime=2010-12-30T18:19:11.5658139Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : Readtrace path C:\Program Files\Microsoft Corporation\RMLUtils
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : Extracing ReadTrace reports
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : Readtrace path C:\Program Files\Microsoft Corporation\RMLUtils
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:11.8626775Z
SQLNexus Information: 0 : ReadTraceNexusImporter: Discovered readtrace at C:\Program Files\Microsoft Corporation\RMLUtils\readtrace.exe
DateTime=2010-12-30T18:19:11.8783019Z
SQLNexus Information: 0 : ReadtraceNexusImporter: extracting reports
DateTime=2010-12-30T18:19:11.8783019Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
DateTime=2010-12-30T18:19:11.8783019Z
SQLNexus Information: 0 : Readtrace path C:\Program Files\Microsoft Corporation\RMLUtils
DateTime=2010-12-30T18:19:11.8783019Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:11.8783019Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:11.8783019Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTracePostProcessing.sql
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTraceReportValidate.sql
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Grouping.RDLC
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Grouping.RDLC.xml
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_InterestingEvents.RDLC
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_InterestingEvents.RDLC.xml
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Lineage.RDLC
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Lineage.RDLC.xml
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Main.RDL
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Main.RDL.xml
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueBatchDetails.RDLC
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueBatchDetails.RDLC.xml
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueBatchTopN.RDLC
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueBatchTopN.RDLC.xml
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueStmtDetails.RDLC
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueStmtDetails.RDLC.xml
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueStmtTopN.RDLC
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueStmtTopN.RDLC.xml
DateTime=2010-12-30T18:19:11.9720483Z
SQLNexus Information: 0 : REport path C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\
DateTime=2010-12-30T18:19:11.9876727Z
SQLNexus Information: 0 : ReadTrace.exe Path: C:\Program Files\Microsoft Corporation\RMLUtils\readtrace.exe
DateTime=2010-12-30T18:19:12.0345459Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Readtrace path C:\Program Files\Microsoft Corporation\RMLUtils
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Readtrace path C:\Program Files\Microsoft Corporation\RMLUtils
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : sqlnexus.exe report directory: C:\Program Files\SQLNexus3.0.0.0\Reports
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Instructions report found: C:\Program Files\SQLNexus3.0.0.0\Reports\Instructions.rdl
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Blocking and Wait Statistics.rdl
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Bottleneck Analysis.rdl
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Instructions.rdl
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Realtime - Server Status.rdl
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2000 Perf Stats.rdl
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2005 Perf Stats.rdl
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2008 Perf Stats.rdl
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Found report:C:\Documents and Settings\lgrob01\Application Data\SqlNexus\Reports\ReadTrace_Main.RDL
DateTime=2010-12-30T18:19:12.0501703Z
SQLNexus Information: 0 : Loading report: Instructions
DateTime=2010-12-30T18:19:12.1126679Z
SQLNexus Information: 0 : Report loaded.
DateTime=2010-12-30T18:19:12.1126679Z
SQLNexus Information: 0 : Successfully opened a connection to server wdh107nwsql02\instance1 from workstation BSCWL613583
DateTime=2010-12-30T18:19:40.5959491Z
SQLNexus Information: 0 : sqlnexus.exe report directory: C:\Program Files\SQLNexus3.0.0.0\Reports
DateTime=2010-12-30T18:19:41.5490375Z
SQLNexus Information: 0 : Instructions report found: C:\Program Files\SQLNexus3.0.0.0\Reports\Instructions.rdl
DateTime=2010-12-30T18:19:41.5646619Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Blocking and Wait Statistics.rdl
DateTime=2010-12-30T18:19:41.5646619Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Bottleneck Analysis.rdl
DateTime=2010-12-30T18:19:41.5646619Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Instructions.rdl
DateTime=2010-12-30T18:19:41.5646619Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Realtime - Server Status.rdl
DateTime=2010-12-30T18:19:41.5646619Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2000 Perf Stats.rdl
DateTime=2010-12-30T18:19:41.5802863Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2005 Perf Stats.rdl
DateTime=2010-12-30T18:19:41.5802863Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2008 Perf Stats.rdl
DateTime=2010-12-30T18:19:41.5802863Z
SQLNexus Information: 0 : Found report:C:\Documents and Settings\lgrob01\Application Data\SqlNexus\Reports\ReadTrace_Main.RDL
DateTime=2010-12-30T18:19:41.5802863Z
SQLNexus Information: 0 : Loading report: Instructions
DateTime=2010-12-30T18:19:41.5959107Z
SQLNexus Information: 0 : Report loaded.
DateTime=2010-12-30T18:19:41.7052815Z
SQLNexus Information: 0 : Refreshing report: Instructions
DateTime=2010-12-30T18:19:41.7834035Z
SQLNexus Information: 0 : Refreshing report...
DateTime=2010-12-30T18:19:41.7834035Z
SQLNexus Information: 0 : Report refresh done.
DateTime=2010-12-30T18:19:41.7834035Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\BulkLoadEx.dll version and creation date 3.0.0.0 Monday, August 24, 2009
DateTime=2010-12-30T18:19:42.9708579Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\Microsoft.Office.Interop.SmartTag.dll version and creation date 11.0.5530 Thursday, April 26, 2007
DateTime=2010-12-30T18:19:42.9708579Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\Microsoft.Office.Interop.Word.dll version and creation date 11.0.5530 Thursday, April 26, 2007
DateTime=2010-12-30T18:19:43.9864439Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\Microsoft.Vbe.Interop.dll version and creation date 11.0.5530 Thursday, April 26, 2007
DateTime=2010-12-30T18:19:44.1270635Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\NexusInterfaces.dll version and creation date 3.0.0.0 Monday, August 24, 2009
DateTime=2010-12-30T18:19:44.1426879Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\office.dll version and creation date 11.0.5530 Thursday, April 26, 2007
DateTime=2010-12-30T18:19:44.1426879Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\PerfmonImporter.dll version and creation date 3.0.0.0 Monday, August 24, 2009
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : load: BLG Blaster (Perfmon/Sysmon BLG files).Drop existing tables
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : load: BLG Blaster (Perfmon/Sysmon BLG files).Enabled
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\ReadTraceNexusImporter.dll version and creation date 3.0.0.0 Monday, August 24, 2009
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : Readtrace path C:\Program Files\Microsoft Corporation\RMLUtils
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : ReadTraceNexusImporter: Discovered readtrace at C:\Program Files\Microsoft Corporation\RMLUtils\readtrace.exe
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : ReadtraceNexusImporter: extracting reports
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : Readtrace path C:\Program Files\Microsoft Corporation\RMLUtils
DateTime=2010-12-30T18:19:44.1739367Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:44.1895611Z
SQLNexus Information: 0 : readtrace.exe file version 09.01.0109
DateTime=2010-12-30T18:19:44.1895611Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTracePostProcessing.sql
DateTime=2010-12-30T18:19:44.2051855Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTraceReportValidate.sql
DateTime=2010-12-30T18:19:44.2051855Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Grouping.RDLC
DateTime=2010-12-30T18:19:44.2051855Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Grouping.RDLC.xml
DateTime=2010-12-30T18:19:44.2051855Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_InterestingEvents.RDLC
DateTime=2010-12-30T18:19:44.2051855Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_InterestingEvents.RDLC.xml
DateTime=2010-12-30T18:19:44.2051855Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Lineage.RDLC
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Lineage.RDLC.xml
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Main.RDL
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_Main.RDL.xml
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueBatchDetails.RDLC
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueBatchDetails.RDLC.xml
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueBatchTopN.RDLC
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueBatchTopN.RDLC.xml
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueStmtDetails.RDLC
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueStmtDetails.RDLC.xml
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueStmtTopN.RDLC
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : Enumerating and deletting file from old directory C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\ReadTrace_UniqueStmtTopN.RDLC.xml
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : REport path C:\Documents and Settings\lgrob01\Application Data\sqlnexus\reports\
DateTime=2010-12-30T18:19:44.2208099Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Output trace files (.trc) by SPID to %TEMP%\RML
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Output RML files (.rml) to %TEMP%\RML
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Assume QUOTED_IDENTIFIER ON
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Ignore events associated with PSSDIAG activity
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Disable event requirement checks
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Enabled -T35 to support MARs
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : load: ReadTrace (SQL Profiler TRC Files).Enabled
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : detecting importer file C:\Program Files\SQLNexus3.0.0.0\RowsetImportEngine.dll version and creation date 3.0.0.0 Monday, August 24, 2009
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : load: Rowset Importer (blocker/perf script output).Drop existing tables
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : load: Rowset Importer (blocker/perf script output).Enabled
DateTime=2010-12-30T18:19:44.2833075Z
SQLNexus Information: 0 : Starting import...
DateTime=2010-12-30T18:19:50.5330675Z
SQLNexus Information: 0 : Number of files blocked for import (due to multiple instance or unrelated files such as sqldump*: 0
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Number of files blocked for import (due to multiple instance or unrelated files such as sqldump*: 0
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Executing post-mortem analysis scripts...
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Execution of post-mortem analysis scripts complete.
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : sqlnexus.exe report directory: C:\Program Files\SQLNexus3.0.0.0\Reports
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Instructions report found: C:\Program Files\SQLNexus3.0.0.0\Reports\Instructions.rdl
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Blocking and Wait Statistics.rdl
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Bottleneck Analysis.rdl
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Instructions.rdl
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\Realtime - Server Status.rdl
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2000 Perf Stats.rdl
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2005 Perf Stats.rdl
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Found report:C:\Program Files\SQLNexus3.0.0.0\Reports\SQL Server 2008 Perf Stats.rdl
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Found report:C:\Documents and Settings\lgrob01\Application Data\SqlNexus\Reports\ReadTrace_Main.RDL
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : Import complete. Total import time: 0 seconds
DateTime=2010-12-30T18:19:50.6424383Z
SQLNexus Information: 0 : This database already have Nexus data. please choose or create a different database for fresh data load
DateTime=2010-12-30T18:19:55.6266219Z
SQLNexus Information: 0 : Loading report: Instructions
DateTime=2010-12-30T18:20:01.6420159Z
SQLNexus Information: 0 : Report loaded.
DateTime=2010-12-30T18:20:01.8451331Z
I do see a message regarding number of files blocked but, I created a test directory with only the one file in it.
Coordinator
Dec 30, 2010 at 5:39 PM

Not seeing any failures with the BLG import. I will post an update on the site if we provide reports for BLG imports.

Dec 30, 2010 at 8:51 PM
Thank you. I only saw the one error message about files as I mentioned but, it also did not load any of the data.
I'll keep an eye out for when this tool supports Perfmon files. I also tried relogging the blg to a csv but, again same results.
Happy New Year!
Coordinator
Jan 5, 2011 at 10:50 AM

Happy New Year to you too.