Active IQ Unified Manager 9.6 fails to displays "The Network" menu in the web interface
Applies to
- Active IQ Unified Manager 9.6 ( AIQUM )
Issue
- "The Network" menu in Active IQ Unified Manager is blank.
- While navigating through LIF details able to see the port data.
- The only issue is Network Port user interface is blank.
- We are seeing the below error in AIQUM
ocumserver.log
2021-01-16 22:06:45,992 ERROR [oncommand] [opmTaskExecutor-3] [c.n.i.s.a.d.r.PortInventoryDataRowMapper] fetchPortInventoryStats query SELECT merge.* FROM(( select 72 as numberOfHours, AVG(utilization) as utilization, AVG(throughput) as throughput, 0 AS eventSeverity, port.objid objid, port.portName name, port.resourceKey resourceKey, CASE WHEN port.maxSpeed IS NULL THEN NULL ELSE (port.maxSpeed)* 1000 END as speed, 'DATA' as role, 'FCP_PORT' as type, cluster.objid clusterId, cluster.name clusterName, cluster.resourceKey clusterResourceKey, node.objid nodeId, node.name nodeName, node.resourceKey nodeResourceKey, GROUP_CONCAT(DISTINCT tp.id ORDER BY tp.id) thresholdPolicyId, GROUP_CONCAT(DISTINCT tp.name ORDER BY tp.id) thresholdPolicyName, c.fqdn AS clusterFqdn FROM netapp_model_view.fcp_port port JOIN
(…)
clusterResourceKey, node.objid nodeId, node.name nodeName, node.resourceKey nodeResourceKey, GROUP_CONCAT(DISTINCT tp.id ORDER BY tp.id) thresholdPolicyId, GROUP_CONCAT(DISTINCT tp.name ORDER BY tp.id) thresholdPolicyName, c.fqdn AS clusterFqdn FROM netapp_model_view.network_port port JOIN netapp_model_view.cluster cluster ON port.clusterId = cluster.objid JOIN netapp_model_view.node node ON port.nodeId = node.objid LEFT JOIN opm.threshold_policy_mapping tpm ON (port.objid = tpm.objectId AND tpm.endTime IS NULL) LEFT JOIN opm.threshold_policy tp ON (tpm.policyId = tp.id AND tp.elementType=60) LEFT JOIN ocum.cluster c ON (cluster.objid = c.id) LEFT JOIN netapp_performance.summary_nic perf_port ON (port.objid = perf_port.objid AND perf_port.fromtime >= 1610604000000 AND perf_port.fromtime < 1610863604258) WHERE role in ('CLUSTER','DATA','INTERCLUSTER') GROUP BY port.objid)) AS merge ORDER BY eventSeverity DESC]; Out of range value for column 'speed' : value auto; nested exception is java.sql.SQLException: Out of range value for column 'speed' : value auto
at deployment.dfm-app.war//org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102)