3
Vote

Various errors in SQL Nexus 5.5.0.1 Release

description

When starting the SQL Nexus 5.5.0.1 Release after installing all the required components I got error messages for various Reports.

I have included a list of all reports and the resulting error message.

Would be great if somebody could tackle the issues. :-) Thanks.

Analysis Results

Best Practice & Analysis Summary

No error message.

Common

Database Configuration

No error message.

Server Configuration

No error message.

Performance

Read Trace Reports

No error message.

Best Practice & Analysis Summary

No error message.

Bottleneck Analysis

No error message.

Blocking and Wait Statistics

---------------------------

---------------------------
System.Data.SqlClient.SqlException (0x80131904): Ungültiger Objektname 'dbo.vw_BLOCKING_CHAINS'.
   bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   bei System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   bei System.Data.SqlClient.SqlDataReader.get_MetaData()
   bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   bei sqlnexus.fmNexus.FixupDataSources(String filename, String reportname, ReportDataSourceCollection datasources, ReportParameterInfoCollection paramc) in c:\jacklidocs3\cprsql\main\src\sqlnexus_pass\CodePlexHelper\SQLNexus.Codeplex\sqlnexus\fmNexus.cs:Zeile 1360.
ClientConnectionId:42e67b5b-3f9e-4308-b42e-7e942398c95e
Fehlernummer (Error Number):208,Status (State):1,Klasse (Class):16
---------------------------
OK   
---------------------------
I checked and the view doesn't exist.
SELECT NAME FROM sys.sysobjects WHERE NAME = 'vw_BLOCKING_CHAINS'

NAME
--------------------------------------------------------------------------------------------------------------------------------

(0 row(s) affected)

Active Trace and XEvent Report

No error message.

Acitive CPU Consuminq Queries

No error message.

Lock Count Summary

No error message.

Memory Brokers

---------------------------

---------------------------
System.Data.SqlClient.SqlException (0x80131904): Ungültiger Objektname 'tbl_DM_OS_MEMORY_CLERKS'.
   bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   bei System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   bei System.Data.SqlClient.SqlDataReader.get_MetaData()
   bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   bei sqlnexus.fmNexus.FixupDataSources(String filename, String reportname, ReportDataSourceCollection datasources, ReportParameterInfoCollection paramc) in c:\jacklidocs3\cprsql\main\src\sqlnexus_pass\CodePlexHelper\SQLNexus.Codeplex\sqlnexus\fmNexus.cs:Zeile 1360.
ClientConnectionId:2dcca4ae-e910-491b-85bf-a0788e242d16
Fehlernummer (Error Number):208,Status (State):1,Klasse (Class):16
---------------------------
OK   
---------------------------
I checked and the table doesn't exist.
SELECT NAME FROM sys.sysobjects WHERE NAME = 'tbl_DM_OS_MEMORY_CLERKS'

NAME
--------------------------------------------------------------------------------------------------------------------------------

(0 row(s) affected)

Missing Indexes

No error message.

Perfmon Summary

---------------------------

---------------------------
System.Data.SqlClient.SqlException (0x80131904): Ungültiger Objektname 'dbo.tbl_XPMSVER'.
   bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   bei System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   bei System.Data.SqlClient.SqlDataReader.get_MetaData()
   bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   bei sqlnexus.fmNexus.FixupDataSources(String filename, String reportname, ReportDataSourceCollection datasources, ReportParameterInfoCollection paramc) in c:\jacklidocs3\cprsql\main\src\sqlnexus_pass\CodePlexHelper\SQLNexus.Codeplex\sqlnexus\fmNexus.cs:Zeile 1360.
ClientConnectionId:5ff5a533-758a-4479-829e-3b226f8ab1da
Fehlernummer (Error Number):208,Status (State):1,Klasse (Class):16
---------------------------
OK   
---------------------------
I checked again...
SELECT NAME FROM sys.sysobjects WHERE NAME = 'tbl_XPMSVER'

NAME
--------------------------------------------------------------------------------------------------------------------------------

(0 row(s) affected)

Query Execution Memory (Memory Grants)

No error message.

Spin Lock Stats

No error message.

System Thread CPU Consumption

No error message.

Tables used by top Queries

No error message.

Virtual File Stats

No error message.

comments