Issue
After upgrading to TAC Vista version 5.1.7 no new values will be shown when a trendlog is opened.
Error message in Vista:
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'. 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() 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.ExecuteScalar() at TAC.DSS.DataAccess.SqlServer.SqlMaintenance.GetDatabaseFragmentationLevel(String tablename) at TAC.DSS.DataAccess.SqlServer.SqlMaintenance.GetDatabaseFragmentationLevel_TrendlogValue() at DssCliLib.Utility.GetDatabaseFragmentationLevel_TrendlogValue(SByte* pszConnectionString, Int32* plSize)
Product Line
TAC Vista
Environment
- Vista Server version 5.1.7
Cause
This issue occurs due to the use of an incompatible SQL server version. A number of new features were introduced in Vista 5.1.7, one of which was a check of the SQL database's fragmentation level. It is this check that fails as it uses a query that is not recognised in SQL 2000.
Resolution
Upgrade/run the database to/on SQL 2005 server or higher.
