This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Database Maintenance Failure

Clark1812 over 1 year ago

Having issues with the database maintenance not working and throwing errors when it runs. The issue is that it fails when updating the "VolumeUsage" and deleting old files.

Errors Below:

SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 0.01s Remove temporary system files - Files

SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 2.35s Compute baseline statistics - VolumeUsage

Been working with Support over a month and no one can resolve this issue. Our database is in a cluster so, can't make changes without effecting the entire cluster/ Anyone has any ideas on these issues? My brain hurts now.

Top Replies

KMSigma.SWI over 1 year ago in reply to Clark1812 +2

I think I remember this being an issue with this particular release. Is there a reason you haven't updated to 2024.1? That's what I'm running and I just checked the DB Maintenance logs and those issues…

Parents

KMSigma.SWI over 1 year ago

What version are you running? You don't mention that in the post.
Cancel
Vote Up 0 Vote Down

Cancel
Clark1812 over 1 year ago in reply to KMSigma.SWI

Sorry.. We are running 202.4.2. Also, I forgot to said that our Database is in a SQL cluster.. this is the only instance having issues.
Cancel
Vote Up 0 Vote Down

Cancel
KMSigma.SWI over 1 year ago in reply to Clark1812

Your version number got truncated. Are you running 2023.4.2?
Cancel
Vote Up 0 Vote Down

Cancel
Clark1812 over 1 year ago in reply to KMSigma.SWI

yes
Cancel
Vote Up 0 Vote Down

Cancel
KMSigma.SWI over 1 year ago in reply to Clark1812

I think I remember this being an issue with this particular release. Is there a reason you haven't updated to 2024.1? That's what I'm running and I just checked the DB Maintenance logs and those issues you report aren't in the logs anywhere.
Cancel
Vote Up +2 Vote Down

Cancel
Clark1812 over 1 year ago in reply to KMSigma.SWI

Thanks... I'll try that this weekend. Been working with support on this issue for sometime now and it's frustrating.
Cancel
Vote Up 0 Vote Down

Cancel

Reply

Clark1812 over 1 year ago in reply to KMSigma.SWI

Thanks... I'll try that this weekend. Been working with support on this issue for sometime now and it's frustrating.
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data