topic Re: WFA hangs after 'query multiselect' in Active IQ Unified Manager Discussions

WFA hangs after 'query multiselect'

sven_letzel — Thu, 05 Jun 2025 05:33:36 GMT

I have definied two queries...

...one to select a controller

and a second

...to select igroups based on the selected controller

in Workflow/Setup/User Inputs

Query 1 (Single select) is:

SELECT array.name FROM storage.array

Query 2 (Multi select) is:

select

igroup.name

FROM

storage.igroup,

storage.array

WHERE

igroup.array_id=array.id

AND array.name like '${ArrayName}%'

AND igroup.os_type = 'vmware'

Clicking the test button the queries work as expected. When I am in the workflow preview mode then first query 2 shows the result of the first controller of query 1 as expected. When I select another controller in the query 1 box AND this controller has no matching igroups then wfa will hang. This happens only when the content of the multiselect changes from "non empty" to "empty".

What is wrong?

When I append "UNION SELECT '[no more igroups]' to query 2, then it will never hang.

This will work:

select

igroup.name

FROM

storage.igroup,

storage.array

WHERE

igroup.array_id=array.id

AND array.name like '${ArrayName}%'

AND igroup.os_type = 'vmware'

union

SELECT

'[no more igroups]'

WFA version is 2.2.0.2.6

Re: WFA hangs after 'query multiselect'

warrenb — Wed, 25 Jun 2014 18:34:41 GMT

Hi Sven,

I cannot comment as to why WFA hangs, but have you considered additional where clauses in the first query so that you can only select controllers with VMware igroups?

Regards,

Warren

Re: WFA hangs after 'query multiselect'

anuk — Fri, 01 Aug 2014 05:21:58 GMT

Hi Sven,

There is a issue with single column query multiselect in WFA2.2. This will sometimes cause UI to hang during workflow preview. I think you are hitting the same issue.

We have fixed this issue in coming release. For WFA2.2, try Pressing "Esc" key when UI hangs.

Thanks

Anu

Re: WFA hangs after 'query multiselect'

adaikkap — Fri, 01 Aug 2014 06:11:23 GMT

Hi Sven,

Can you pls open a case with NetApp Support and add it to the bug #829439 ?

That would give you the timeline for the fixed version, workarounds if any etc.

Regards

adai

Message was edited by: Adaikkappan Arumugam

Re: WFA hangs after 'query multiselect'

Bal — Thu, 13 Nov 2014 11:11:09 GMT

Hi,

I've checked the bug page - http://mysupport.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=829439 and it doesn't show any details about where and when this bugy is fixed..

Could you please post the version in which this bug is fixed?

Regards,

Bal