Active IQ Unified Manager Discussions

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

Richy_TH
8,428 Views

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

1 ACCEPTED SOLUTION

ktim
8,302 Views

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

 

View solution in original post

12 REPLIES 12
Public