Data truncation: Data too long for column 'error_message' in CA Spectrum

Products

• Spectrum
• Network Observability

Issue/Introduction

There are several error in the tomcat log is as follows:

"Data truncation: Data too long for column 'error_message'"

Environment

Spectrum 10.3 or later

Cause

This mySQL column is found in the netqos_integ database:

mysql> select TABLE_NAME, COLUMN_NAME from information_schema.columns where column_name like 'error_message';

+--------------------+---------------+
| TABLE_NAME         | COLUMN_NAME   |
+--------------------+---------------+
| item_model_mapping | error_message |
+--------------------+---------------+
1 row in set (0.20 sec) 

 

and is described as follows:

mysql> show columns from item_model_mapping;

+------------------------+------------------+------+-----+---------+----------------+
| Field                  | Type             | Null | Key | Default | Extra          |
+------------------------+------------------+------+-----+---------+----------------+
| item_model_mapping_key | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| landscape_h            | int(10) unsigned | NO   | MUL | NULL    |                |
| item_id                | int(10) unsigned | NO   |     | NULL    |                |
| model_handle           | int(10) unsigned | NO   |     | NULL    |                |
| record_updatedon       | int(10) unsigned | NO   | MUL | NULL    |                |
| model_updatedon        | int(10) unsigned | YES  | MUL | NULL    |                |
| error_message          | varchar(64)      | YES  |     | NULL    |                |
+------------------------+------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

Resolution

NOTE: In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

Please increase this column size to fit the size of your error messages. For some users 500 is enough but for others 1,000 is necessary.

- Log into the system as the user that owns the Spectrum installation

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

- cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> netqos_integ

- Enter the following commands at the mysql prompt:

ALTER TABLE item_model_mapping MODIFY COLUMN error_message varchar(1000);

quit;

- Restart tomcat