Nexus tool not running SQL 2008

Feb 24, 2012 at 6:27 AM

Hi,

I download SQL Nexus Tool V.3.0, but It is not working in SQL server 2008.. please help me out how to resolve this issues

SQLNexus Information: 0 : sqlnexus.exe running at: D:\Nexus\sqlnexus.exe version 3.0.0.0
    DateTime=2012-02-24T07:21:17.6750991Z
SQLNexus Information: 0 : This is a beta version
    DateTime=2012-02-24T07:21:17.6750991Z
SQLNexus Information: 0 : AutoUpdate: Application is not running as part of a ClickOnce deployment
    DateTime=2012-02-24T07:21:17.6750991Z
SQLNexus Information: 0 : Successfully opened a connection to server servername\instance from workstation WJMN0120753
    DateTime=2012-02-24T07:21:19.3938601Z
SQLNexus Information: 0 : sqlnexus.exe report directory: D:\Nexus\Reports
    DateTime=2012-02-24T07:21:19.4876107Z
SQLNexus Information: 0 : Instructions report found: D:\Nexus\Reports\Instructions.rdl
    DateTime=2012-02-24T07:21:19.5032358Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\Blocking and Wait Statistics.rdl
    DateTime=2012-02-24T07:21:19.5032358Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\Bottleneck Analysis.rdl
    DateTime=2012-02-24T07:21:19.5032358Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\Instructions.rdl
    DateTime=2012-02-24T07:21:19.5032358Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\Realtime - Server Status.rdl
    DateTime=2012-02-24T07:21:19.5032358Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\SQL Server 2000 Perf Stats.rdl
    DateTime=2012-02-24T07:21:19.5188609Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\SQL Server 2005 Perf Stats.rdl
    DateTime=2012-02-24T07:21:19.5188609Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\SQL Server 2008 Perf Stats.rdl
    DateTime=2012-02-24T07:21:19.5188609Z
SQLNexus Information: 0 : Loading report: Instructions
    DateTime=2012-02-24T07:21:19.5344860Z
SQLNexus Information: 0 : Report loaded.
    DateTime=2012-02-24T07:21:19.8157378Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
    DateTime=2012-02-24T07:21:19.9563637Z
SQLNexus Information: 0 : Readtrace path
    DateTime=2012-02-24T07:21:19.9563637Z
SQLNexus Information: 0 : Warning: readtrace.exe doesn't exist in directory :
    DateTime=2012-02-24T07:21:19.9563637Z
SQLNexus Information: 0 : Warning: readtrace.exe doesn't exist in directory :
    DateTime=2012-02-24T07:21:19.9563637Z
SQLNexus Information: 0 : Unable to locate readtrace.  Nexus won't be able to load or analyze profiler trace data.
    DateTime=2012-02-24T07:21:19.9563637Z
SQLNexus Information: 0 : RTD: searching registry path CLSID\{8F930F9E-42A5-11D3-95F9-0080C71FC66E}\LocalServer32
    DateTime=2012-02-24T07:21:35.0189601Z
SQLNexus Information: 0 : Readtrace path
    DateTime=2012-02-24T07:21:35.0345852Z
SQLNexus Information: 0 : Warning: readtrace.exe doesn't exist in directory :
    DateTime=2012-02-24T07:21:35.0345852Z
SQLNexus Information: 0 : Warning: readtrace.exe doesn't exist in directory :
    DateTime=2012-02-24T07:21:35.0345852Z
SQLNexus Information: 0 : sqlnexus.exe report directory: D:\Nexus\Reports
    DateTime=2012-02-24T07:21:35.0345852Z
SQLNexus Information: 0 : Instructions report found: D:\Nexus\Reports\Instructions.rdl
    DateTime=2012-02-24T07:21:35.0345852Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\Blocking and Wait Statistics.rdl
    DateTime=2012-02-24T07:21:35.0502103Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\Bottleneck Analysis.rdl
    DateTime=2012-02-24T07:21:35.0502103Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\Instructions.rdl
    DateTime=2012-02-24T07:21:35.0502103Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\Realtime - Server Status.rdl
    DateTime=2012-02-24T07:21:35.0502103Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\SQL Server 2000 Perf Stats.rdl
    DateTime=2012-02-24T07:21:35.0502103Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\SQL Server 2005 Perf Stats.rdl
    DateTime=2012-02-24T07:21:35.0502103Z
SQLNexus Information: 0 : Found report:D:\Nexus\Reports\SQL Server 2008 Perf Stats.rdl
    DateTime=2012-02-24T07:21:35.0502103Z
SQLNexus Information: 0 : Loading report: Instructions
    DateTime=2012-02-24T07:21:35.0658354Z
SQLNexus Information: 0 : Report loaded.
    DateTime=2012-02-24T07:21:35.0658354Z
SQLNexus Information: 0 : RV link sync event
    DateTime=2012-02-24T07:21:37.3471000Z
SQLNexus Error: 0 : System.Data.SqlClient.SqlException: Invalid object name 'tbl_Requests'.
   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 1

    DateTime=2012-02-24T07:22:20.2848748Z
SQLNexus Information: 0 : The database doesn't have necessary data to run this report
    DateTime=2012-02-24T07:22:20.2848748Z
SQLNexus Error: 0 : System.Data.SqlClient.SqlException: Invalid object name 'tbl_Requests'.
   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 1

    DateTime=2012-02-24T07:22:21.8473848Z

thanks

ananda