Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Database Maintenance Fails after upgrade to 2022.3

We had a page within Orion that showed us the history of the database maintenance, like start time, end time & duration.

Since upgrading to 2022.3 this page no longer works.

On looking at the database itself I can see that the event types have changed from 1000 to 5100 for it starting and 1001 to 5101 for it completing normally.

I changed the swql query that ran and it only populates the start time.

Checking the database maintenance log it says it has completed, and if i run it manually from the server it also says it completed.

However in the backend database its creating an event type 5102 in the logs stating that the maintenance has failed.

The only thing that i can see that list error in the logs, is deletion of some JET*.tmp files.

This was a bug in older versions of NPM (12.5) that got fixed, but it appears to have re-appeared again in 2022.3

Does anyone else have this error, or know how to resolve it?

TIA

Find more posts tagged with

Accepted answers

dunky2k

Raised a ticket with support and like previous issue is a known bug

Post having this issue checked Internally we have noted this alert (Nightly Maintenance failed) as a known bug in the SolarWinds Observability 2022.3, And this is expected to be fixed in the version (2023.1)

For now you can safely ignore this alert, As this is a known bug.

All comments

dodo123

If you havent already log a support case with SolarWinds, currently one of our customers is on 2022.3 and maintenance completes but has failures in it, this one had sql tables with dead locks on them which needed to be cleared.

nickburns186

Same here. See failures on deleting temp sys files but completes otherwise.

dunky2k

Raised a ticket with support and like previous issue is a known bug

h.hendriks

We have the same message: "Nightly maintenance failed. See logs form more details."

kdara

Hello Guys,

I had faced the Database maintenance issues with 2022.3 version then after several weeks troubleshooting.. Support has suggested to upgrading 2022.4. And now we are seeing same DB maintenance errors in this version also not sure why Solarwinds Development team is releasing latest version with bug...