Active IQ Unified Manager um run query fails selecting more than 1 field of a table
Applies to
- Netapp Active IQ Unified Manager (AIQUM) 9.7.x
- Netapp Active IQ Unified Manager (AIQUM) 9.8
Issue
Active IQ Unified Manager um run query fails when selecting more than 1 field of a table.
- Example query with error below
um run query "select clusterName,aggregateName from ocum.volumelivelistdtoview"ERROR : Request cannot be processed due to error in input data.- In
cli.log:
2021-02-01 05:23:53,260 INFO [main] [c.n.d.c.h.r.u.RequestManager] RequestManager.java : Sending GET request to URL https://UnifiedManager:443/api/management-server/admin/query?sqlQuery=select+clusterName%2CaggregateName+from+ocum.volumelivelistdtoview
2021-02-01 05:23:55,464 ERROR [main] [c.n.d.c.h.r.CliRestMain] null
2021-02-01 05:23:55,465 WARN [main] [c.n.d.c.h.r.CliRestMain] Error while invoking caller method from class : com.netapp.dfm.cli.handlers.rest.executors.UMRunCommand