topic Re: Error accessing 1 row table with getValueAt function in Active IQ Unified Manager Discussions

Error accessing 1 row table with getValueAt function

francoisbnc — Thu, 05 Jun 2025 05:20:31 GMT

Hello,

I experience the following error when I try to access an one row table with getValueAt function.

Failed to resolve expression ' getValueAt($newlunssizetable,IndexLunSource)

$newlunssizetable is a input parameter as table.

IndexLunSource is the index in a loop represented by getSize($luns)

$lun is a imput parameter multiselect SQL query

SELECT
lun.full_path,
ROUND(lun.size_mb / 1024,
0) AS Size
FROM
cm_storage.lun AS lun,
cm_storage.vserver AS vserver,
cm_storage.volume AS volume
WHERE
lun.vserver_id = vserver.id
AND lun.volume_id = volume.id
AND volume.name = '${myVol}'
AND vserver.name = '${Mysvm}'

If the the table is more that one row, it works fine.

The certified command works with 1 dim 1 row array

def getValueAt(arrayVar, index)

{
return arrayVar.split(",")[index-1];
}

Any ideas welcome.

François

Re: Error accessing 1 row table with getValueAt function

francoisbnc — Tue, 06 Jan 2015 16:52:47 GMT

Seems that is a complicated example, to simplify:

I just create wokflow (in attachment ) with no-ops command and I added an input parameter $inputparameter as table.

This is the content of no-op

getValueAt($inputtable,1)

The problem occurs with numeric entry and when table have only one row.

multiple rows or alphanumeric entry: OK

Re: Error accessing 1 row table with getValueAt function

sinhaa — Wed, 07 Jan 2015 03:58:28 GMT

Hi Francois,

This behviour of failure when using 1 numeric entry is strange, I'm looking to see why this happens. If you want to be able to proceed, you can put the numberic is single quotes like '11' and it will work fine.