SRM Displays incomplete Dashboard

Summary: Newly deployed SRM 4.7.1 displays incomplete Dashboard.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

Symptoms

Newly deployed SRM 4.7.1 displays incomplete Dashboard.


partial-dashboard.PNG


Other symptoms 

Database connection failed. Please contact your Frontend administrator.

database-connection-failed.PNG


import-properties-Default failed with status 1.
taskRun-0-0

220824 10:10:04 : Caused by: java.sql.SQLException: null,  message from server: "Host 'xx.xx.xxx.xxx' is not allowed to connect to this MySQL server"
220824 10:10:04 :   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
220824 10:10:04 :   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
220824 10:10:04 :   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
220824 10:10:04 :   at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1038)
220824 10:10:04 :   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
220824 10:10:04 :   at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2046)
220824 10:10:04 :   ... 26 more
220824 10:10:04 : 
220824 10:10:04 : Aug 24, 2022 10:10:04 AM com.watch4net.apg.v2.gui.resource.database.DatasourceCloseListener onShutdown
220824 10:10:04 : INFO: Closing resources com.watch4net.apg.gui.datasource.jdbc.FinalizableDataSource@3349e9bb...
220824 10:10:04 : Aug 24, 2022 10:10:04 AM com.watch4net.apg.v2.gui.resource.database.DatasourceCloseListener onShutdown
220824 10:10:04 : INFO: Closing resources com.watch4net.apg.gui.datasource.jdbc.FinalizableDataSource@4c371370...
220824 10:10:04 : Aug 24, 2022 10:10:04 AM com.watch4net.apg.v2.gui.resource.database.DatasourceCloseListener onShutdown
220824 10:10:04 : INFO: Closing resources com.watch4net.apg.gui.datasource.jdbc.FinalizableDataSource@18078bef...
220824 10:10:04 : Aug 24, 2022 10:10:04 AM com.watch4net.apg.v2.gui.resource.database.DatasourceCloseListener onShutdown
220824 10:10:04 : INFO: Closing resources com.watch4net.apg.gui.datasource.jdbc.FinalizableDataSource@799f10e1...
220824 10:10:04 : Aug 24, 2022 10:10:04 AM com.watch4net.apg.v2.gui.resource.database.DatasourceCloseListener onShutdown
220824 10:10:04 : INFO: Closing resources com.watch4net.apg.gui.datasource.jdbc.FinalizableDataSource@689604d9...
220824 10:10:06 : Execute method (main) exited with a failure error code of 1
220824 10:10:06 : Task import-properties-Default failed with status 1.

Cause

Reverse Domain Name System DNS) is not working

Resolution

1. Fix the reverse DNS issue 
2  Redeploy SRM 
Note: 
If snapshots were taken prior to power up SRM VMs, you can simply reverse to snapshots 

VMware vSphere illustration:

reverse-to-latest-snapshot.PNG

Article Properties
Article Number: 000202713
Article Type: Solution
Last Modified: 09 Nov 2022
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.