|Applies To||RSA Product Set: NetWitness Platform, NetWitness Logs & Network|
RSA Product/Service Type: NetWitness Admin Server
RSA Version/Condition: 188.8.131.52
|Issue||Attempting to upgrade to RSA NetWitness Platform 11.x fails when there are custom dashboard preferences.|
The /var/log/netwitness/uax/logs/migration.log file reports the error message below.
FAILED: User Migration
Migration job failed due to error:ClassNotFoundException: com.rsa.smc.sa.reporter.web.ui.chart.ReporterChartDashletHideValueOptions
Finished migration, status: FAILED
|Cause||In version 11.0 of the RSA NetWitness Platform, there is a dashboard customization option that is no longer utilized. |
The class for this feature had been removed and thus creates a failure to read the class ReporterCharDashletHideValueOptions during the upgrade.
|Resolution||The deprecated customized dashboard class ReporterCharDashletHideValueOptions has been reintroduced in RSA NetWitness Logs & Network version 11.1 which resolves the issue.|
|Workaround||The workaround below will also resolve the issue.|
- Connect to the RSA NetWitness Admin server via SSH.
- Change the directory to the working location.
- Use the cp command to copy the h2 jar file to a central location if it is not already located in /var/lib/netwitness/uax/db, using the locate command as necessary to find the proper file.
cp /home/rsasoc/rsa/soc/reporting-engine/temp/reporting-engine_20180228220618.1181/lib/h2-1.3.174.jar /var/lib/netwitness/uax/db/
- Open H2 SQL prompt on the RSA NetWitness Admin server.
java -cp h2-1.3.172.jar org.h2.tools.Shell -url jdbc:h2:file:platform
Note: The command above assumes that the h2-1.3.172.jar files exists in the /var/lib/netiwtness/uax/db directory.
- Below is an example of what is in USER_PREFEREENCES from the custom dashboards.
sql> select * from USER_PREFERENCES where name ='user.dashboard.preferences.chart.hide.value';
USER_ID | VALUE | NAME
82 | aced0005737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f7249 | user.dashboard.preferences.chart.hide.value
124 | aced0005737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f7249 | user.dashboard.preferences.chart.hide.value
(data is partially truncated)
(2 rows, 5 ms)
- Delete what custom dashboard preferences you have.
sql> delete from USER_PREFERENCES where name = 'user.dashboard.preferences.chart.hide.value';
(Update count: 2, 10 ms)
When the upgrade is complete you can add back the custom dashboard preferences.