Forum Replies Created
-
Posts
-
Seems at email’s time there was a communication fault:
But 1 hour before it same event happened… and there was no email !!??
Sorry, I received one email as stated on the log:
“Alarma activada en Regulador A” on Sunday 22th at 21:37:33
Why no more alerts !!??
WRITE EVENTS… is like “Events enabled” ? I think ‘events enabled’ is more understandable.
AVERAGING: how does averaging work? continuos average? last 100 values average? last minute average?
By the way… as only minute-data is shown… what happens when communicator sends several values on the same minute? does an average? maximum? latest?
Limits… I will try to guess it but that’s not an answer.
> Are any events shown when in Report/List Chart view?
> Sorry, I didn’t catch the meaning.
When in a report view with some list chart graphs there are no Events shown. Useless? => hide it, makes you think there are no events.Doubts/Suggestions/Improvements:
> How/where could I see/configure more than the last 9-10 events?
> Use SCADA-Web Configurator -> Visible events countbut… if I have 100’s (on a single table) should I maximize the value and they will appear in one page!!?? ==> pagging?
And Mmmmhhh… checked events never dissapear to see the others?
Once events are checked where they can be seen again? ==> add an option: events: () all () by view () CHECKED
Seeing events on a daily basis is easy but what happens if you don’t receive an email/alert and you don’t enter everyday to scada?
… You will miss some events and they can be important! this could help:
() only today () all-time non checked ?Consider what is worth to implement (I will understand nothgin is worth right now) or take the ideas for the future 🙂
> Yes, you should create a rule. If it’s enough to receive the same message, you can create some kind of aggregation channel. In case of using limits, you can specify trigger on status.
Maybe adding orignal channel+value to the email (as said in another thread) would make a single rule more than enough 🙂>Where are they stored (in case you need to delete ie… 100’s) ?
>See directory settings of SCADA-Server.
OK, you can view and edit all events on a daily basis, good!
It’s enough for the admin, but users should not have access to that tool.
Think about previous tips.Mmm… HighCharts is more complex/versalite it currently looks.
I can’t spend a lot of time on this but see what I hae found:Seems it can be done with milions of data, but maybe it requires you to provide data to the graph in a different way you currently do:
Millions of data points on HighCharts
What do you think?
Ok I understand, just as a suggerence:
Receiving detected value could be a VERY good thing: It really helps a lot to receive the value and see value is just 1 unit above specified… or 1000 units!
Adding several triggers for different ‘levels’ for several channels is… unfeasible.
If adding full dynamic text support takes too long or is complex, think about an easy shortcut: just replace “[CNL]” text on the binary string or a checkbox like “add value at the end”.
🙂
2016-04-28 18:17:56 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: The column "Channel type" cannot contain null values. 2016-04-28 19:34:27 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: The column "Channel type" cannot contain null values. 2016-05-16 13:10:40 <SRVSCADA><Administrador><EXC> Channels have been created with errors. Update the open tables to display the changes. 2016-05-16 16:08:43 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: The column "Name" cannot contain null values. 2016-05-16 16:08:54 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: The column "Name" cannot contain null values. 2016-05-16 16:09:04 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: The column "Name" cannot contain null values. A duplicate value cannot be inserted into the column "Number". 2016-05-16 16:09:12 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: A duplicate value cannot be inserted into the column "Number". 2016-05-16 16:09:42 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: A duplicate value cannot be inserted into the column "Number". 2016-05-16 16:09:48 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: A duplicate value cannot be inserted into the column "Number". 2016-05-16 16:09:52 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: A duplicate value cannot be inserted into the column "Number". 2016-05-16 16:15:22 <SRVSCADA><Administrador><EXC> Error saving the table changes to the database: The column "Name" cannot contain null values.No more details.
I had that same error 2 times, same amount I used the same device template.
I shortened device field names and got no errors, it should be that.
> I’m sorry to say that I don’t agree with your decision on keeping with binary data but… OK.
> May be the source code should be refactored to allow switching the storage.If I’m not wrong RapidScada should have relatively easy/simple writes and reads to the data, it should be ‘easy’ to switch to SQL insertions/queryes. And in those days where data should be free/open/customer owned…
Using SQLite should be ok (check license).
– If you are worried about using it with huge amounts of data, check PDF files on this work:
How good can databases deal with Netflow data?
– It could use just a single data file (or one file pro day) it is straight-forward to do backups
– And a non-install .DLL file to implement should make it easy to install.I will not insist more on this topic 🙂
=======================================================================
> 30-days 10-chnnels chart contains 24*60*30*10 = 432000 points.
> It is not a few.
432.000 points takes 130 seconds to draw = 3.300 points/second
3.300 pro second… well… not bad but I hope we can improve it.>Could you generate similar Excel report and compare the duration?
I have a 50.000 points Excel graph, it takes 21 seconds to draw it
But anyway… they are (and will be) graphs/objects so different that you can not get any reliable conclusion.> May be the bottle neck is drawing these points.
It could be, graph is generated linearly, it doesn’t get slower as more data comes in.>It would be interesting to compare with other JavaScript charts such as http://www.highcharts.com in conjunction with MySQL or PostgreSQL (like here).
Databases will give you that amount of data in a few seconds that’s not a problem. I will give a try to highcharts alone…
I’m sorry to say that I don’t agree with your decision on keeping with binary data but… OK.
I’m not sure which part on the client side makes it slow. I will take a look…
My graphs from 1 month ago have 2 data points every minute, i.e. one at 00:00:00 and another one at 00:00:30
Seems right now every data point is each minute.
Which parameter controls this?
In fact… for multichanel graphs the bottleneck “could be” client’s CPU speed:
Graph/webbrowser runs on a single-core CPU (no complain!) and I have 2 plot-points per minute = 2880 points/channel/data/day… my computer is a Intel core i3-2100 at 3.10 Ghz
on complex graphs it will not query next day data until CPU finishes drawing each day, so…
– why it takes so long to draw 2880 points on a 3 Ghz CPU?
– Could we configure it to 1 plot-point each minute instead of 2?Having a standard database system would allow to fix wrong data in the past.
If I get one day of wrong data (ie: ulong instead of signed long) data can appear as 4 thousand millions instead of -1 and graphs are useless by the huge automatic scale used.
Using SQL statements would be easy to fix/delete wrong data on a database.
thanks!