Symptoms
ViPR SRM/Watch4Net: VNX Solution Pack reports corrupts display of tree panel of reportsAfter install of vnx reports part of the solution pack after re-login to the UI below kind of display will be seenIn tomcat catalina 0-0.log will see the following errorOkt 13, 2017 1:58:42 PM com.watch4net.apg.v2.gui.master.MasterUtils logUserLoadingTimeINFO: User 'admin' loaded in 1.297s, including: Default ReportPack - Explore (0.157s), EMC VNX - EMC VNX (0.094s)...Okt 13, 2017 1:58:42 PM com.watch4net.apg.v2.gui.database.util.QueryExecutionUtils executeIndexedQuerySEVERE: Table 'apg.nasusers' doesn't exist Query: (SELECT DISTINCT nasusers.serialnb FROM nasusers WHERE (nasusers.Timestamp >= 15078...java.sql.SQLException: Table 'apg.nasusers' doesn't exist Query: (SELECT DISTINCT nasusers.serialnb FROM nasusers WHERE (nasusers.Timestamp >= 1507809522 AND nasusers.Timestamp <= 1507895922)) Parameters: []Okt 13, 2017 1:58:42 PM com.watch4net.apg.v2.gui.tree.DynamicNode getChildrenSEVERE: can't expand childrencom.watch4net.apg.v2.gui.database.DatabaseException: java.sql.SQLException: Table 'apg.nasusers' doesn't exist Query: (SELECT DISTINCT nasusers.serialnb FROM nasusers WHERE (nasusers.Timestamp >= 1507809522 AND nasusers.Timestamp <= 1507895922)) Parameters: []
Cause
Resource Link URL for FLOW-VNX-LIVE set incorrectly, ie set to apg instead of eventscd /opt/APG/bin ./manage-resources.sh update dba/FLOW-VNX-LIVEIn the output the url will be something like (pbe=hostname for primary backend host)"jdbc:mysql://PBE:53306/apg?autoReconnect=true&amp;tinyInt1isBit=false&amp;useSSL=false"
Resolution
Set Resource Link URL for FLOW-VNX-LIVE correctly ( Replace pbe.example.com in the output below to the fqdn of the primary backend Host)In URL below please see events in bold which replaced the original setting apg which was incorrect.Putty to Frontend Host:FE Host:~ # /opt/APG/bin/./manage-resources.sh update dba/FLOW-VNX-LIVE "{'datasource':{'url': 'jdbc:mysql://pbe.example.com:53306/events?autoReconnect=true&tinyInt1isBit=false&connectTimeout=20000&maxReconnects=2'}}"
Related Information
Please see kb https://support.emc.com/kb/486660 knowledge base article for resource links.Please check all resource links are set correctly as per this kb https://support.emc.com/kb/486660
