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 amount of licenses available for Storage points has been exceeded. At Fields table, the total amount of fields is not higher than the number of Storage licenses. Why is this happening?
Solution:
The use of access parallelism for an enhanced performance is indicated when using different tables. In this case, each DB connection will add to the number of fields in the same table n times, exceeding the number of available Storage points.
Therefore, you must gather together the DBServers with the same connection and the same table, always respecting the rule of one DB per table from the same connection; if this rule is not obeyed, this type of problems could happen.
The points used by the application are counted when the domain starts, by checking the total amount of fields found at Fields table; even if the application stops trying to add any new values to a certain field in the table, it will be accounted for. Therefore, in the case of I/O, Storage, and OPC points, all the licenses previously “seen” by E3 will remain accounted for until the application finishes.
