WFA AIQUM数据源错误"无法从数据源获取连接"

适用场景

• Active IQ Unified Manager 9.7 及更高版本（ AIQUM ）
• OnCommand Workflow Automation 5.1+ （ WFA ）

问题描述

WFA AIQUM数据源 状态失败、并显示错误：

2023-09-12 08:33:12,827 INFO [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (Thread-2319 (ActiveMQ-client-global-threads)) Job CacheJob{, dataSourceId=DataSourceInfo{id=3, name='xxxxxxxx.xxx.xxx.com', connectionDetails=ConnectionDetails{id=5, ip='xxxxxxxx.xxx.xxx.com', port=3306, userName='wfauser', password='******', databaseName='', timeoutInMinutes=10, lastUpdateTime=0}, dataProviderType=DataProviderType{id=18, productType='Active IQ Unified Manager', productVersion='9.7', scheme='cm_storage'}}, schemeId=Scheme{id=3, name='cm_storage'}, dataSourceName='xxxxxxxx.xxx.xxx.com', schemeName='cm_storage'} started 2023-09-12 08:33:34,268 ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (Thread-2319 (ActiveMQ-client-global-threads)) Job CacheJob{, dataSourceId=DataSourceInfo{id=3, name='xxxxxxxx.xxx.xxx.com', connectionDetails=ConnectionDetails{id=5, ip='xxxxxxxx.xxx.xxx.com', port=3306, userName='wfauser', password='******', databaseName='', timeoutInMinutes=10, lastUpdateTime=0}, dataProviderType=DataProviderType{id=18, productType='Active IQ Unified Manager', productVersion='9.7', scheme='cm_storage'}}, schemeId=Scheme{id=3, name='cm_storage'}, dataSourceName='xxxxxxxx.xxx.xxx.com', schemeName='cm_storage'} failed: javax.ejb.EJBException: com.netapp.wfa.util.SqlShellException: Failed to get connection from data-source Caused by: com.netapp.wfa.util.SqlShellException: Failed to get connection from data-source Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=xxxxxxxx.xxx.xxx.com)(port=3306)(type=master) : Connection timed out: connect Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=xxxxxxxx.xxx.xxx.com)(port=3306)(type=master) : Connection timed out: connect Caused by: java.net.ConnectException: Connection timed out: connect