Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

WFA hangs after 'query multiselect'

sven_letzel

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

anuk

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

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

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

warrenb

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

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public