Skip to main content
NetApp Knowledge Base

Active IQ Unified Manager 9.6 fails to displays "The Network" menu in the web interface

Views:
171
Visibility:
Public
Votes:
0
Category:
active-iq-unified-manager
Specialty:
om
Last Updated:

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)

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.