Hi!
As per subject, I have a problem with the GetSumDCIValue when the result is greater than a 32bit integer.
This is my transformation:
return int64(GetSumDCIValue($node, FindDCIByDescription($node, "WAN: delta in (bytes)"), time()-86400, time()));
It returns 0 when the result cannot be handled by a 32 bits integer.
I have another version of that DCI that uses a different approach to do the same computations and it works properly:
last = int64(GetCustomAttribute($node, "WANCumulativeIn"));
if (last == null)
last = 0;
SetCustomAttribute($node, "WANCumulativeIn", 0);
return last;
The data type assigned to both DCIs is "Unsigned Integer 64 bit" (NB in the last example the custom attribute is updated by another DCI).
Any hints?
Best regards,
Marco
Hi!
Could you check what is returned by underlying SQL query? Implementation of this function tries to parse value read from database as double, so there should be no limitation on 32bit integer size.
Actual query is
SELECT avg(coalesce(idata_value,0)) FROM idata_<node_id_here> WHERE item_id=<dci_id_here> AND (idata_timestamp BETWEEN <time1> AND <time2>);
Best regards,
Victor
Quote from: Victor Kirhenshtein on May 08, 2014, 05:38:33 PM
Hi!
Could you check what is returned by underlying SQL query? Implementation of this function tries to parse value read from database as double, so there should be no limitation on 32bit integer size.
Actual query is
SELECT avg(coalesce(idata_value,0)) FROM idata_<node_id_here> WHERE item_id=<dci_id_here> AND (idata_timestamp BETWEEN <time1> AND <time2>);
Best regards,
Victor
I get "Arithmetic overflow error converting expression to data type int". I propose to apply the same suggestion as per this thread:
https://www.netxms.org/forum/configuration/getxxxdcivalue-(avgmaxmin)-fails-on-floating-numbers/msg13724/#msg13724
adding
cast(idata_value as float),0) inside the coalesce function.
Best regards,
Marco
Yes, that change already applied - so after upgrade to 1.2.14 you'll get this problem fixed as well.
Best regards,
Victor
Quote from: Victor Kirhenshtein on May 08, 2014, 06:26:55 PM
Yes, that change already applied - so after upgrade to 1.2.14 you'll get this problem fixed as well.
Best regards,
Victor
Is there a reason to get always null in return from this function:
GetMaxDCIValue($node, $dci->id, time()-86400, time());
I tried to run manually the query (as per the SQL syntax in this thread) and it works fine, but I'm not able to have the function working in my transformation script.
Best regards,
Marco
Hi!
Actually there is an error in query used in function. Query looks like
SELECT max(coalesce(cast(idata_value as float),0)) FROM idata_%u
WHERE item_id=? AND (idata_timestamp BETWEEN ? AND ?) AND isnumeric(idata_value)
but isnumeric returns int, not boolean, so it should be
isnumeric(idata_value)=1
I've fixed it. PLease let me know if you need intermediate server build with this fix.
Best regards,
Victor
Quote from: Victor Kirhenshtein on June 03, 2014, 12:27:58 AM
I've fixed it. PLease let me know if you need intermediate server build with this fix.
Best regards,
Victor
It could be nice to have it, I'm using the x64 Windows version.
Best regards,
Marco
Hi!
I'm finally built an intermediate release. It is available here: https://www.netxms.org/download/1.2.15-M1/ (https://www.netxms.org/download/1.2.15-M1/).
Best regards,
Victor
Quote from: Victor Kirhenshtein on June 12, 2014, 10:27:42 PM
Hi!
I'm finally built an intermediate release. It is available here: https://www.netxms.org/download/1.2.15-M1/ (https://www.netxms.org/download/1.2.15-M1/).
Best regards,
Victor
Thank you very much for your effort, I'm downloading it, I plan to install it tonight.
Best regards,
Marco
Quote from: Victor Kirhenshtein on June 12, 2014, 10:27:42 PM
Hi!
I'm finally built an intermediate release. It is available here: https://www.netxms.org/download/1.2.15-M1/ (https://www.netxms.org/download/1.2.15-M1/).
Best regards,
Victor
Is it possible to have the WebUI? You changed the protocol and the previous version is no more able to connect.
Best regards,
Marco