Trend logs are not being saved to SQL after upgrading the SQL database

NOTICE

POTENTIAL FOR DATA LOSS.
The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure, please contact Product Support Services prior to attempting the procedure below.

Issue

Trend logs are not being saved to SQL after upgrading the SQL database. There are no error messages and Vista can read old (pre upgrade) values from the taclogdata database. The insertlogvalues keeps growing.

Product Line

TAC Vista

Environment

Vista 5.1.X

SQL 2005 or 2008 server with a database that has been upgraded to layout 2 (the new schema used from version 5.1.7).

Cause

The database schema is out of date. The database schema is a blueprint of how a database will be constructed.

Resolution

  1. Shut down Vista.
  2. Go to services and stop the TAC DSS writer service.
    1. Right-click on My Computer (Computer in Win 7 and Win Server 2008) and select manage.
    2. Locate services in the console that opens up.
    3. Locate the TAC DSS Writer service, select and then click on stop. This service is responsible for writing events and trend log data to the SQL database.
  3. Update the database schema.
    1. Open Vista sever setup and locate the SQL server tab.
    2. Click on the Custom radio button (if not already selected) and then change the name (e.g. add "_1" to the end of the current name) of the database in the SQL Server Name field.
    3. Click on Apply, OK and  then Yes to create the new database.
    4. Once complete, change the name of the database back to the original name (or click on the Typical radio button if using default settings) and click on Apply.
    5. A message will appear "Log database found but needs to be reconfigured. Reconfigure Log database?".
    6. Click on Yes.
  4. The database schema should now be updated.
    1. Right-click on My Computer (Computer in Win 7 and Win Server 2008) and select manage.
    2. Locate services in the console that opens up.
    3. Locate the TAC DSS Writer service, select and then click on Start. This service is responsible for writing events and trend log data to the SQL database.

Check to see that the logs are now being written to the log database. It may take some time to process the backlog.