ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

"Data truncation: Data too long for column 'resourceName' at row 1" error generated in the tomcat log while SRM is starting


Article ID: 112003


Updated On:


CA Spectrum DX NetOps


While SRM is starting, you may see the following error in the tomcat log related a Service Manager Table in the SRM database:

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'resourceName' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket( at com.mysql.jdbc.MysqlIO.checkErrorPacket( at com.mysql.jdbc.MysqlIO.sendCommand( at com.mysql.jdbc.MysqlIO.sqlQueryDirect( at com.mysql.jdbc.ConnectionImpl.execSQL( at com.mysql.jdbc.PreparedStatement.executeInternal( at com.mysql.jdbc.PreparedStatement.executeUpdate( at com.mysql.jdbc.PreparedStatement.executeUpdate( at com.mysql.jdbc.PreparedStatement.executeUpdate( at com.aprisma.util.mysql.Database.write( at at at at at$1200( at$ at com.aprisma.util.thread.JobQueue.runJobThread( at com.aprisma.util.thread.JobQueue.access$000( at com.aprisma.util.thread.JobQueue$ at




Login to the OneClick server with Spectrum Report Manager installed and run the following commands to resolve the issue.

On Windows, please open a bash shell (bash -login).

cd <SPECROOT>/mysql/bin

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting -A

ALTER TABLE sm_resources MODIFY COLUMN resourceName varchar(500);


Restart Spectrum Tomcat to resolve the issue.

Additional Information

If you have any additional questions please do not hesitate to reach out to CA Spectrum Support for further assistance.