Global Synchronization in NetOps Portal fails
Article ID: 407942
Updated On:
Products
Issue/Introduction
We are using NetOps Portal with an NFA Data Source.
We don't have other Data Sources configured at this time.
We are seeing failures from the System Status page Global Synchronization table.
Checking the (default path) /opt/CA/PerformanceCenter/DM/logs/DMService.log we see MySql related errors about a missing column.
The error states "Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'dst.SerialNumber' in 'field list'".
Running this to see the dst_device table description shows it has no SerialNumber column.
./mysql -uroot -p netqosportal -e "desc dst_device;"
Environment
All supported Network Observability DX NetOps Portal web server systems running 24.3.6 and newer releases
Cause
Upgrade to 24.3.7, while showing no errors, didn't properly add the new SerialNumber column added in the 24.3.6 release.
Resolution
To resolve this we need to add the SerialNumber column to the netqosportal MySql DB.
Open a terminal to the Portal web server and run the following as the root or install owner OS user. Enter the password when prompted.
./mysql -uroot -p netqosportal -e "ALTER TABLE dst_device ADD SerialNumber VARCHAR(40) NULL DEFAULT NULL;"
If successful, no restarts are needed. The next Global Synchronization cycle to run should complete successfully.
Feedback
