ViPR SRM: Unable to see the Physical Overview graphs for Collectors[1]

           

   Article Number:     516790                                   Article Version: 3     Article Type:    Break Fix 
   

 


Product:

 

ViPR SRM

 

Issue:

 

 

For three of the servers, the graphs are not showing up data under Physical Overview.   
   
    User-added image   
    User-added image   
   
   
     
                                                           

 

 

Cause:

 

 

Database Corruption     
     
      Messages seen under import-properties task
:   
   
   
    180122 07:52:50 : INFO: Refreshing group 'DB'...   
    180122 07:52:52 : Jan 22, 2018 7:52:52 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask$PropStoreService fromFetchSource   
    180122 07:52:52 : INFO: Property Store service at https://esrmprdcgy104.network.lan:48443/Databases/APG-Property-Store/apg3 is not reacheable, ignoring...   
    180122 07:52:52 : Jan 22, 2018 7:52:52 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask compute   
    180122 07:52:52 : INFO: 'data_property' has changed for partition '/opt/APG/Databases/APG-Property-Store/Default/tmp/DB/APG-esrmprdcgy104-DB3'. Refreshing...   
    180122 07:52:52 : Jan 22, 2018 7:52:52 AM com.watch4net.propstore.apg.tasks.ImportPropertiesTask compute   
    180122 07:52:52 : INFO: Importing data from 'data_property' into '/opt/APG/Databases/APG-Property-Store/Default/tmp/DB/APG-esrmprdcgy104-DB3'...   
    180122 07:52:52 : Jan 22, 2018 7:52:52 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask$PropStoreService fromFetchSource   
    180122 07:52:52 : INFO: Property Store service at https://esrmprdcgy102.network.lan:48443/Databases/APG-Property-Store/Default is not reacheable, ignoring...   
    180122 07:52:52 : Jan 22, 2018 7:52:52 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask compute   
    180122 07:52:52 : INFO: 'data_property' has changed for partition '/opt/APG/Databases/APG-Property-Store/Default/tmp/DB/APG-DB'. Refreshing...   
    180122 07:52:52 : Jan 22, 2018 7:52:52 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask$PropStoreService fromFetchSource   
    180122 07:52:52 : INFO: Property Store service at https://esrmprdcgy104.network.lan:48443/Databases/APG-Property-Store/apg4 is not reacheable, ignoring...   
    180122 07:52:52 : Jan 22, 2018 7:52:52 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask compute   
    180122 07:52:52 : INFO: 'data_property' has changed for partition '/opt/APG/Databases/APG-Property-Store/Default/tmp/DB/APG-esrmprdcgy104-DB4'. Refreshing...   
    180122 07:52:53 : Jan 22, 2018 7:52:53 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask$PropStoreService fromFetchSource   
    180122 07:52:53 : INFO: Property Store service at https://esrmprdcgy104.network.lan:48443/Databases/APG-Property-Store/apg1 is not reacheable, ignoring...   
    180122 07:52:53 : Jan 22, 2018 7:52:53 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask compute   
    180122 07:52:53 : INFO: 'data_property' has changed for partition '/opt/APG/Databases/APG-Property-Store/Default/tmp/DB/APG-esrmprdcgy104-DB1'. Refreshing...   
    180122 07:52:53 : Jan 22, 2018 7:52:53 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask$PropStoreService fromFetchSource   
    180122 07:52:53 : INFO: Property Store service at https://esrmprdcgy104.network.lan:48443/Databases/APG-Property-Store/apg2 is not reacheable, ignoring...   
    180122 07:52:53 : Jan 22, 2018 7:52:53 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask compute   
    180122 07:52:53 : INFO: 'data_property' has changed for partition '/opt/APG/Databases/APG-Property-Store/Default/tmp/DB/APG-esrmprdcgy104-DB2'. Refreshing...   
    180122 07:52:53 : Jan 22, 2018 7:52:53 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask$PropStoreService fromFetchSource   
    180122 07:52:53 : INFO: Property Store service at https://esrmprdcgy103.network.lan:48443/Databases/APG-Property-Store/apg3 is not reacheable, ignoring...   
    180122 07:52:53 : Jan 22, 2018 7:52:53 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask compute   
    180122 07:52:53 : INFO: 'data_property' has changed for partition '/opt/APG/Databases/APG-Property-Store/Default/tmp/DB/APG-DB-esrmprdcgy103-3'. Refreshing...   
    180122 07:52:54 : Jan 22, 2018 7:52:54 AM com.watch4net.propstore.apg.tasks.ImportPropertiesIfNeededTask$PropStoreService fromFetchSource   
    180122 07:52:54 : INFO: Property Store service at https://esrmprdcgy103.network.lan:48443/Databases/APG-Property-Store/apg4 is not reacheable, ignoring...   
   
   
   
     
                                                           

 

 

Resolution:

 

 

Running the database-check command for the Primary Backend and additional backends fixed the reachability of the apg databases under APG-Property-Stores.   
   
    Steps of work around:   
   
    1. For Primary backend:   
    Login to Primary Backend at /opt/APG/bin   
    Run Command: ./mysql-database-check.sh   
    Enter username: [apg]    
    root   
    Enter database: [apg]   
    apg   
    Enter password:    
    watch4net   
   
    2. For Additional Backend:   
    Login to Additional Backend at /opt/APG/bin   
    Run Command: ./mysql-database-check.sh   
    Enter username: [apg]    
    root   
    Enter database: [apg]   
    apg1 or apg2 or apg3 or apg4   
    Enter password:    
    watch4net   
   
    3. Logout and Login the SRM GUI.   
    The graphs are seen for all the servers.