Check if Database Maintenance works properly showing Critical in Deployment Health

kishore574

Hi All,

we checked the Critical error in Deployment Health. Could you please advise on this. i click on the arrow button.

Unable to get the answer. Please find the below error details.

Critical error : Check if Database Maintenance works properly

Regards,

Find more posts tagged with

DEPLOYMENTH hEALTH Error

npm

Accepted answers

All comments

vinay.by

When did you last run Deployment Health checks ? Try to re-run this particular check and verify if its still there.

Database Maintenance runs daily, if you haven't changed the default config then it runs at 215 AM every single day. Archive & Delete historical data from your SolarWinds Orion DB which is no longer required as per the settings for your environment.

If your deployment Health Check is accurate, then try running Database Maintenance Manually on the Primary Poller, if manual run doesnt work then you need to verify why so (we will have to capture it from logs).

https://documentation.solarwinds.com/en/Success_Center/orionplatform/content/core-running-database-maintenance-sw1925.htm

kishore574

Yes, very day database Maintenance executing at 2:15 AM. but still showing the deployment health error.

simon.stone

There are some bugs with the maintenance. Have you looked at the c:\ProgramData\SolarWinds\Logs\Orion\swdebugMaintenance.log will give you some clues as to what the error is. It might be as simple as the fragmentation.

kishore574

Actually we have fragmentation scheduler available. it is daily running. Please find the below error message for the check database maintenance.

"FileCleaner: An Error has occured during the log files clean proccess. The file is being used..."

bharris1

@kishore574 Did you ever resolve this issue? I'm having some issues with the Wireless table parts of the maintenance taking over 8-10+ hours. The few times it did complete that error appeared.

kishore574

@bharris1 No, still error showing in console. we checked with multiple times and finally opend case with vendor they suggested check with Your SQL Team. still i am seeking solution for this one.

our database maintenance happend every day

kishore574

Hi,

We have identified the below error in Check database maintain works daily. is this below path file can we copy from C drive to D drive. is this correct method. after that database maitains works properly or not. Please confirm.

C:\Program Files (x86)\SolarWinds\Orion\LogAdjuster.exe did not finish successfully....