KB-31544: Accessing E3Storage data via a regular query.
Question: How can I access E3Storage data from a regular query while filtering it by date? Solution: To filter data via E3TimeStamp field, the query will search for a numeric…
Category: E3Storage
KB-37300: Date recorded by E3Storage is not correctly displayed at E3.
Question: In my application, the data recorded today in the database by E3Storage are displayed at the E3Browser as having been recorded the following day. Why does this happen? Solution:…
KB-31955: E3Storage works only with a Studio hardkey.
Question: The E3Storage is only recording values in the database when I use the Studio hardkey. When I run the application with the runtime hardkey, no value is recorded. All…
KB-60787: Querying raw data in an E3Storage.
Question: Can I query the raw data recorded via E3Storage? I just want to visualize the actual data, with no interpolation function estimating values. Solution: Currently, E3Storage’s query has no…
Setting up E3Storage.
Introduction E3Storage is a historian module in E3, responsible for compacting data and thus optimizing the use of databases and causing the information to be stored in smaller spaces. By…
KB-56808: Creating a new Storage table at run time.
Question: Can a new Storage table be created at run time? Solution: Yes; to do so, there are two possibilities. The first one is to use Activate and Deactivate methods,…
KB-56064: Storage exceeds the number of licenses even with a smaller number of fields in Fields table.
Question: When creating an access parallelism to an Oracle database, several DBServer objects were added with the same connection and the same table. However, E3’s log says that the maximum…
KB-28016: Recording data with significant variation.
Question: How can I record data in table only when there is a significant variation on its value? Solution: To do so, use E3Storage. This module has an algorithm that…
KB-45268: Screen server’s settings for accessing data from an E3Storage in a data server.
Question: How can I set a Storage/Query from an application running as a screen server to access the data recorded in an E3Storage from a computer running as a data…
KB-37302: Setting a filter by date on an E3Storage’s Query.
Question: How can I set a filter by date on an E3Storage’s Query? Solution: To do so, you must use the CompressedDataStartEndTime query and set the dates in the respective…