Active IQ Unified Manager returns "No data" on Capacity Volumes/Aggregates view

Applies to

• Active IQ Unified Manager 9.6

Issue

• Trying to access the capacity volumes/aggregates view returns "No data"
• On /var/log/ocum/ocumserver.log similar errors can be seen

2020-05-08 11:26:36,722 ERROR [umadmin][default task-1537] [c.n.i.s.a.dao.VolumeCapacityDao] Fetch from table volumecapacityutilizationview with query: SELECT * from ocum.volumecapacityutilizationview failed.
org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * from ocum.volumecapacityutilizationview ORDER BY clusterName, volumeName ASC LIMIT 0, 20]; (conn=892) Out of range value for column 'quotaCommittedCapacity' at row 1; nested exception is java.sql.SQLDataException: (conn=892) Out of range value for column 'quotaCommittedCapacity' at row 1

2020-05-29 03:38:28,977 ERROR [umadmin] [default task-516] [c.n.i.s.a.dao.AggregateCapacityDao] Fetch from table AggregateCapacityUtilizationView with query: SELECT * from ocum.AggregateCapacityUtilizationView failed.
org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * from ocum.AggregateCapacityUtilizationView ORDER BY ClusterName, haPair, aggrName LIMIT 0, 20]; (conn=33406) Out of range value for column 'totalCommitted' at row 1; nested exception is java.sql.SQLDataException: (conn=33406) Out of range value for column 'totalCommitted' at row 1