The swdebugMaintenance.log file contains only a header

Overview

The swdebugMaintenance.log file, which is created from the nightly database maintenance, generally has date and time stamps with defaults and information about the job, as well as the statement of the job completing. However, sometimes you might find a file that has only heading information and no other, not even a completion message

Environment

• Orion Platform, all versions

Detail

The LogAdjuster influences the level of logging that is in the swdebugMaintenance.log. The setting in LogAdjuster can be found in Orion, Database Maintenance.  The default level is INFO.

Your file might look similar to the following without a completion message. (The ERROR messages are harmless and can be ignored.)

*** SolarWinds Orion Database Maintenance v2017.1.5300.1698, .Net Runtime v4.0.30319 ***
*** Assembly Database-Maint, Version=2017.1.5300.1698, ....
*** Assembly SolarWinds.Orion.Core.Data, Version=2017.1.5300.1825, ....
2018-03-06 09:43:35,922 [4] ERROR SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - No TableHandlers descriptions found!
2018-03-06 09:43:35,969 [4] ERROR SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - No TableHandlers descriptions found!
*** Assembly SolarWinds.Orion.Common, Version=2.0.0.0, ...
*** Assembly SolarWinds.Orion.Proxy.I18N, Version=1.0.0.0, ...
.

.

The above listing is normal for ERROR level setting.  Notice there is no message saying the job has completed.

The WARN level also does not produce the message saying the job has completed.

The INFO and the DEBUG levels will show the message that the Database Maintenance is complete. (Only INFO level messages are displayed if the logging level is INFO.)

2018-03-06 10:03:15,137 [4] INFO  SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Database Maintenance Complete.
2018-03-06 10:03:15,137 [4] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: dbm_EndMaintenance