Spectrum Report Manager is missing NCM Configuration Details in the database

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

When Spectrum Report Manager goes to insert the configuration details into the reporting database, the inserts fail and the below error is produced in the Spectrum Tomcat log:

Tomcat Log Locations:

<SPECROOT>/tomcat/logs/catalina.out (Linux)
<SPECROOT>/tomcat/logs/stdout.log (Windows)

 

(SRM/NCMConfigHandler100663296/bucketReader) (com.aprisma.spectrum.app.repmgr.dc.event.handler.NCMConfigHandler) - (ERROR) - Error occurred while processing NCM event bucket, Record: com.aprisma.spectrum.app.repmgr.dc.dto.BucketRow@2099dbda
Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO ncm_config (config_text_id, device_model_key, change_time, trap_from, trap_user, trap_on, lines_changed, rel_lines_changed, violated_policies, compliant_policies, spec_user_name, comm_mode, landscape, last_updated_time) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Data truncation: Data too long for column 'compliant_policies' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'compliant_policies' at row 1

 

Environment

Release : All Supported Releases

Component : Spectrum Reporting

Cause

The data being inserted into the table is too big for the data type.

Resolution

You will need to increase the Reporting MySQL tables for this text:

- Log into the Spectrum Report Manager 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> reporting;

- Run the following two commands at the mysql prompt:

alter table ncm_config modify violated_policies varchar(100000);
alter table ncm_config modify compliant_policies  varchar(100000);

- Enter quit at the mysql prompt to exit mysql