The below errors are continuously coming up in Tomcat logs:(SRM/AlarmHandler/bucketReader) (SRM_Alarms) - (ERROR) - Failed to add new alarmtitle record Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO alarmtitle (cause_id, title) VALUES (?, ?)]; Data truncation: Data too long for column 'title' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
1. Log into the Spectrum Report Manager 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 reporting
5. Enter the following command at the mysql prompt:
ALTER TABLE alarmtitle MODIFY COLUMN title varchar(1000);
6. Exit mysql and restart tomcat