SQL STATE fatal error
Top chapter calculation processes in combination with ADS plugin processes may exhaust connections to the database in case of 6+ CPUs appliance and allocated CPU for report computing 50% and more.
Version: 12.2.5 and older
In System Messages appeared error [@frontend-acf7d9@] and after a while, GUI was not working.
|Steps to Reproduce:|
|Error Message:||[@frontend-acf7d9@] It is not possible to obtain configuration of the section "Active dashboards" due to the following error: "SQLSTATE  FATAL: remaining connection slots are reserved for non-replication superuser connections". This may lead to displaying outdated data in the user interface and the inability to change some settings. Please check the configuration of this section. If this error keeps showing up, please contact the support.|
|Cause:||Exhausted connections to the database.|
|Resolution:||It is going to be fixed in the upcoming releases.|
|Workaround:||In Configuration Center -> FMC Configuration -> Reports -> Basic Settings decrease Reserved CPU to 30%.|