The EnpowerDB is always full. The problem is not solved thoroughly after a dumping mechanism is used or the database capacity is expanded.
As the EnpowerDB is full, certain parameters of environment monitoring fail to be displayed on the N2000 BMS. The monitoring system prompts that the space usage of the EnpowerDB exceeds the threshold.
To effectively solve the problem, you can run the following scripts so that the system does not generate history data any more.
The scripts are as follows:
truncate table tbl_EnpHistoryDataTab
drop trigger EnpEnvStatusTrigger
drop trigger EnpPowerAcInputTrigger
drop trigger EnpPowerBatteryLoopTrigger
drop trigger EnpPowerBatteryGroupTrigger
drop trigger EnpPowerDcOutTrigger
To restore the capacity of producing history data of the system, run the scripts in the Appendix.
This method avoids database expansion and is not restricted by versions.
R8 and R11 BMS are available this case.
The EnpowerDB is used for saving the environment monitoring data. A large amount of redundant history data leads to full capacity of the EnpowerDB.
The history data is produced by the trigger and does not make sense for customers.