Skip to main content
NetApp Knowledge Base

Active IQ Unified Manager um run query fails selecting more than 1 field of a table

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

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

 

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

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device