Active IQ Unified Manager Discussions

WFA hangs after 'query multiselect'

sven_letzel
3,578 Views

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

4 REPLIES 4

warrenb
3,579 Views

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

anuk
3,579 Views

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

adaikkap
3,579 Views

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

Bal
3,447 Views

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

Public