000036208 - Upgrade to RSA NetWitness Platform 11.x fails when there are custom dashboard preferences

Document created by RSA Customer Support Employee on Apr 3, 2018Last modified by RSA Customer Support Employee on Apr 10, 2018
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000036208
Applies ToRSA Product Set: NetWitness Platform, NetWitness Logs & Network
RSA Product/Service Type: NetWitness Admin Server
RSA Version/Condition:
IssueAttempting 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
CauseIn 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. 
ResolutionThe deprecated customized dashboard class ReporterCharDashletHideValueOptions has been reintroduced in RSA NetWitness Logs & Network version 11.1 which resolves the issue.
WorkaroundThe workaround below will also resolve the issue.
  1. Connect to the RSA NetWitness Admin server via SSH.

    SSH root@<admin-server>

  2. Change the directory to the working location.

    cd /var/lib/netwitness/uax/db/

  3. 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.

    locate h2*.jar
    cp /home/rsasoc/rsa/soc/reporting-engine/temp/reporting-engine_20180228220618.1181/lib/h2-1.3.174.jar /var/lib/netwitness/uax/db/

  4. 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.

  5. 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';

    82 | aced0005737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f7249 | user.dashboard.preferences.chart.hide.value 
    124 | aced0005737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f7249 | user.dashboard.preferences.chart.hide.value 
    (data is partially truncated) 
    (2 rows, 5 ms)

  6. 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.