Issue:
The Policy Manager Console runs slow and sometimes it's unable to connect to the Policy Manager Server
Resolution:
Make sure your Policy Manager Server and Policy Manager Console are the same versions, otherwise the connection will not work.
If both Policy Manager Sever and Policy Manager Console are the same versions, the performance issues could be due to having a very high number of alerts, or a very high volume of scanning reports being kept in the Policy Manager Server. This would slow down the console.
You may remove some of the alerts or scanning reports to improve the performance.
If the above mentioned steps do not help, please proceed with the following:
Policy Manager 15.x and earlier:
- Stop the F-Secure Policy Manager Server service.
- Backup the H2DB folder (...\F-Secure\Management Server 5\data\h2db). DO NOT proceed further without having a working H2DB backup in place.
- Run the database maintenance tool (...\F-Secure\Management Server 5\bin\fspms-db-maintenance-tool.exe) and follow the on-screen instructions to optimize the database.
- Start the F-Secure Policy Manager Server service.
- Log in to the Policy Manager Console.
In case the issue remains, you can execute the H2DB recovery tool (...\F-Secure\Management Server 5\bin\fspms-db-recover.bat) in the Windows command prompt to repair the H2DB.
Note: Make sure to stop the F-Secure Policy Manager Server service before running the tool.
If necessary, you can refer to the read me file (..\F-Secure\Management Server 5\bin\README-recover-db.txt) on how to execute the H2DB recovery tool.
Policy Manager 16.x and above :
- Stop the WithSecure Policy Manager Server service (net stop wspms).
- Back up the H2DB folder (`C:\ProgramData\WithSecure\NS\Policy Manager\Policy Manager Server\data\h2db\`). DO NOT proceed without a working H2DB backup.
- Run the database maintenance tool (`C:\Program Files\WithSecure\Policy Manager\Policy Manager Server\bin\fspms-db-maintenance-tool`) and follow the on-screen instructions to optimize the database.
- Start the WithSecure Policy Manager Server service(net start wspms).
- Log in to the Policy Manager console.
If the problem persists, you can run the H2DB recovery tool (C:\Program Files\WithSecure\Policy Manager Server\bin\fspms-db-recover.bat) in the Windows command prompt to repair the H2DB database.
Note: Make sure you stop the WithSecure Policy Manager Server service before running the tool.
If necessary, you can refer to the read me file (C:\Program Files\WithSecure\Policy Manager Server\bin\README-recover-db.txt) for instructions on how to run the H2DB recovery tool.
Once you have finished repairing the H2DB using the tool, you can proceed to take the repaired H2DB into use, restarting the F-Secure Policy Manager Server service after doing so.
Try to login to the Policy Manager Console again after the service has been started.
Article no: 000010142