KB-28190: Filter in SQL Query using time value.
Question: How can I query a certain period (initial and final date), while also adding filter it by hour within this period? (For example: the query must return data only…
KB-27977: Deleting the records stored in a database.
Question: How can I delete all the records from a database via E3? Solution: To do so, you have to create a Query and, in it, set up the SQL…
KB-27418: Storing historic alarms in E3Alarm.
Question: Can E3Alarm store the acknowledged alarms that have already returned to the normal status? That is, is it possible not to remove them from the list, so that they…
KB-28636: Setting up alarm’s Message column’s width and name.
Question: How can I set up the alarm’s Message column’s width and name?Solution: Via E3Studio, go to E3Alarm’s properties window, and on Columns tab select the name of the column…
KB-13180: SQL query returning values every 10 minutes.
Question: How can I have an SQL query return values every ten minutes, even when the Historic keeps recording these values every second? Example: 4h 30min – tag1 = 1…
INFO-0002722: E3 Server hangs when OPC driver initializes.
OVERVIEW When executing a domain as a service connecting to an OPC server that runs on the same machine (also as a service), E3 Server hangs on initialization.WORKAROUND To avoid…
KB-31671: Campo Operador do E3Alarm.
Descrição: Por que o nome do operador logado na aplicação não está sendo exibido no campo Operador do E3Alarm? Solução: O campo Operador do E3Alarm mostra o conteúdo do campo…
KB-29341: Using tag’s timestamp for viewing and recording alarms.
Question: How can I use the timestamp of a tag read via DNP driver for viewing and recording alarms? Solution: To do so, use InTime timestamp, which can be selected…
KB-29045: E3Alarm’s Operator field remains blank when the alarm is active.
Question: Why does Operator field in E3Alarm remain blank when an alarm is active, even if there is a user logged to the system? Solution: Only when the alarm is…
BUG-0008903: E3 Admin’s icon still in execution if the domain is stopped when in maintenance.
OVERVIEW E3 Admin’s icon is displayed as if the domain were running when all projects are put in maintenance and the domain is stopped by the Studio. HOW CAN I…