Subscribe
Accepted Solution

Failed to register member variable 'LUNMember2' for row #1

[ Edited ]

Dear All

i am trying to map existing luns into the igroup by using row repetition function.

used below SQL Finder command:

 

SELECT
lun.id,
lun.serial_number,
lun.array_id,
lun.vfiler_id,
lun.volume_id,
qtree.name AS 'qtree',
lun.qtree_id,
lun.size_mb,
lun.mapped,
lun.space_reserved,
lun.name,
lun.full_path,
volume.name AS 'volume.name',
array.ip AS 'volume.array.ip'
FROM
storage.lun AS lun,
storage.array AS array,
storage.volume AS volume,
Storage.qtree
WHERE
lun.array_id = array.id
AND qtree.id = lun.qtree_id
AND qtree.volume_id = volume.id
AND lun.name LIKE 'EEC_%'
AND lun.volume_id = volume.id
AND volume.name LIKE 'EEC_%'
AND array.ip = '192.168.100.100'

 

it was successfully to query so the result screen listed below:

 

Screen Shot 2558-01-16 at 1.21.41 AM.pngScreen Shot 2558-01-16 at 1.28.32 AM.png

 

Screen Shot 2558-01-16 at 1.28.39 AM.png

 

so i have applied each one of the component to command parameter  as show below:

 

Screen Shot 2558-01-16 at 1.28.20 AM.png

 

 

Screen Shot 2558-01-16 at 1.28.26 AM.png

 

 

 

 

 

after preview workflow the below error will show.

 

Screen Shot 2558-01-16 at 1.31.05 AM.png

 

 

 

anyone have any idea why this error was occured.

thank you in advanced

 

Richy

Re: Failed to register member variable 'LUNMember2' for row #1

Check out the finder variable input, could you attach a screenshot of the row repetition details ? ( the parameters are what you used to fill out the command form and the variable should be the finder output or a $variable )

Re: Failed to register member variable 'LUNMember2' for row #1

row repetition detail screen shot.

 

Screen Shot 2558-01-16 at 1.56.33 AM.png

Re: Failed to register member variable 'LUNMember2' for row #1

at the lower left picture, enter the parameter and the value ( is empty ) , then use the parameter in the command.

Re: Failed to register member variable 'LUNMember2' for row #1

do i need to  do that since i have completed parameter input in the finder already.

 

AND lun.name LIKE 'EEC_%'
AND lun.volume_id = volume.id
AND volume.name LIKE 'EEC_%'
AND array.ip = '192.168.100.100'

 

Richy

Re: Failed to register member variable 'LUNMember2' for row #1

Check the returned attributes on your EEC finder ( you move them from available to selected )

 

In the row repetion details window ( edit ) , below where the finder parameters ( where the parameters and value table appears and is empty, so the commands are not receiving the variables ), there is a variables table where you could also add ( try to make the window bigger so you can see it ), the finder populates that from the returned attributes but is seems to be empty.

 

In your case, the finder should have populated the variables ( check the returned attributes on your EEC finder ).

 

Hope that helps.

Re: Failed to register member variable 'LUNMember2' for row #1

Hi,

 

Can you try out the following two suggestions.

 

1. Check the wfa.log file to see the exceptions and you could attach here

 

2. Could you also try making this change and preview the workflow and let us know whether it helps.

 

In the parameters provided to "Map and Online" command, can you change the value given to

Volume tab -> 'name' attribute to "LunMember2.volume.name from "LunMember2.volume"

Array tab -> 'ip' attribute to "LunMember2.array.ip" from "LunMember2.array"

Qtree tab -> 'name' attribute to 'LunMember2.qtree.name" from "LunMember2.qtree"

 

Thanks,

Shailaja

Re: Failed to register member variable 'LUNMember2' for row #1

Hi 

i have check the return attribute it was selected.

 

Screen Shot 2558-01-17 at 3.39.16 AM.png

 

Screen Shot 2558-01-17 at 3.50.52 AM.png

 

no variable i have filled in

 

are there any point for me to check ?

 

Thank you 

 

Richy

Re: Failed to register member variable 'LUNMember2' for row #1

Hi Shailaja

i have changed as you recommence but the out put still the same 

 

 

 

 

 Screen Shot 2558-01-17 at 3.41.13 AM.png

 

Screen Shot 2558-01-17 at 3.41.19 AM.png

Screen Shot 2558-01-17 at 3.41.25 AM.png

 

Screen Shot 2558-01-17 at 3.41.29 AM.png

thank you for your reply

 

Richy

 

 

 

 

Re: Failed to register member variable 'LUNMember2' for row #1

You should be basing your filter query on a standard LUN filter rather than changing the values to include qtree name, lun name, etc.

 

I would expect your query should be more like (parameterizing rather than putting in static query info):

SELECT
lun.id,
lun.serial_number,
lun.array_id,
lun.vfiler_id,
lun.volume_id,
lun.qtree_id,
lun.size_mb,
lun.mapped,
lun.space_reserved,
lun.name,
lun.full_path,
volume.name AS 'volume.name',
array.ip AS 'volume.array.ip'
FROM
storage.lun AS lun,
storage.array AS array,
storage.volume AS volume
WHERE
lun.array_id = array.id
AND lun.full_path LIKE '${lun_prefix}%'
AND lun.volume_id = volume.id
AND volume.name LIKE '${vol_prefix}%'
AND array.ip = '${array_ip}'

 

Regards,

Tim