Usage of New column configured and using it in transformation script

Started by Nagav, June 19, 2015, 11:11:27 AM

Previous topic - Next topic

Nagav

Hi, I have one table type dci with 5 columns, which is already collecting data, now if I edit the DCI and add new 6th column Col6 ,  I could not call newly added column in transformation script like
idxcol6 = $1->getColumnIndex("Col6");
$1->set(i,idxcol6, 2);
I get error as "Error 19 in line 2: Function or operation argument is not a whole number"
I get this error even after I restart the server and agent
But in column definition I could see new column being added
Is it not possible to configure add new column to DCI and use it in transformation script?

Victor Kirhenshtein

Hi,

the problem is that in transformation script you got table as it received from agent. If you want to fill additional column in transformation script you should add it in script like this:

$1->addColumn("Col6");

Best regards,
Victor

Nagav

Hi
Is it not possible to add more than 10 columns using $1->addColumn("Column Name"); ?
If I try to add 11th column and set value to it using transfermation script,  it is not getting displayed in Table latest value
How to add 11th column ?

Thanks
Naga

Victor Kirhenshtein

Hi,

there are no limit on number of table columns. Can you show full script, maybe problem is elsewhere?

Best regards,
Victor