Issue with the host System for our Spectroserver had the locale time change incorrectly to 2018

book

Article ID: 16509

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction



A problem exists where the host System for our SpectroSERVER had the locale time change incorrectly to 2018 – How can we remove these unwanted events?

Environment

Release:
Component:

Resolution

In a scenario where a hosts system locale changed to an incorrect future date and time (for example in 2017 the date and time was changed to 2018) you can remove these unwanted events by doing the following:

1. Log into the SpectroSERVER system as the user that owns the Spectrum installation

2. If on Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/mysql/bin directory

4. Enter the following command to log into mysql:

 ./mysql --defaults-file=../my-spectrum.cnf -uroot –proot ddmdb;

5. Enter the following command to delete events from 2018:

Delete from event where time > ‘2018-01-01 00:00:00’;

Note: Modify the year and date as required. Take care the year and date are set correctly or you may lose current events.