SAM Database Maintenance Is Overdue

Question

Seeing this issue every day now

Tables in your database contain data that is older than data retention policies allow. This can be an indication of database maintenance errors. Help me fix this

Tables overdue for maintenance:

* Component status details table is 5 days overdue

I followed the link help me fix this .. manually ran the database maintenance yesterday but this morning got the above again saying 5 days

Steve

janene16 · Answer

There might be something in the logs causing the DB Maintenance to halt.

Can you login to your Orion server and go to C:\ProgramData\Solarwinds\Logs\Orion then find the most recent swdebugMaintenance.log

Did it complete?

When is the last time it ran?

Where did it stopped?

fitzy141 · Answer

Yes I am seeing some errors - any one specific should I be looking for ...

fitzy141 · Answer

Presently I am running 6.2.3 and this just started recently