NOTE: Starting from DX NetOps Spectrum 21.2.4, the default root password for MySql is "MySqlR00t". For DX NetOps Spectrum versions prior to 21.2.4, the default root password is "root". In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.
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).
./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> reporting -A
ALTER TABLE sm_resources MODIFY COLUMN resourceName varchar(500);
Restart Spectrum Tomcat to resolve the issue.