SQLServer: Failed to re-open log file 5 times. Logging is deactivated.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

sqlserver alarm: SQLServer: Failed to re-open log file 5 times.  Logging is deactivated and Permission denied errors in the sqlserver log.

Environment

- UIM 8.x or higher
- sqlserver probe
- Windows Authentication

Cause

- Normally, the probe cannot create .MET files in the robot's niscache folder where the probe is deployed. This results in the QoS data not being inserted into the database and the data is not visible in USM, and/or a file, log file cannot be written to.

Resolution

1. Confirm that the configure sqlserver user has full access/security/control rights.

2. Confirm that a full exception has been configured in your Anti-Virus/scanning for all Nimsoft programs/dirs/files.

3. Check that the sqlserver probe "Access Prerequisites" here in the release notes have been met:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/sqlserver-sql-server-monitoring/sqlserver-sql-server-monitoring-release-notes.html#concept.dita_b49428046e49ef6a121825f32deba3fc96c0ff27_ProbeSpecificSoftwareRequirements

4. For the 'Failed to re-open log file sqlserver_monitor alarm', please apply this key via sqlserver probe Raw Configure mode to address this issue.

Follow these steps:

    a. Select Raw Configure-> setup
    b. Set the value of the flag_reverttoself option to yes
    c. Apply the change, then cold start (Deactivate, then Activate) the sqlserver probe.

This should allow the probe to roll over and re-open the sqlserver_monitor.log file to continue logging.

This also documented here:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/sqlserver-sql-server-monitoring/sqlserver-troubleshooting.html

You also may have to check with your DBA to make sure the correct role/permissions were added.

In many other cases where this error occurred, what  is described above, resolved the problem.

***If the above doesn't resolve the errors, it is quite possible that the probe, when configured to use Windows Auth for the database connection - it may get caught in a 'context switch' when the log file is to be rolled to the backup (meaning that instead of the commands being executed as the Local SYSTEM Account (which the robot runs as) it may be using the SQL Windows NT User which does NOT have access to the local filesystem (niscache, and probe directory) and results in access being denied.*** Restart the Nimbus Robot Service to see if that clears the issue.

5. If you added the new parameter and still experience the problem/errors, please have your DBA GRANT the database user access to the robot niscache folder and sqlserver probe folders and then restart the probe and see if the errors are alleviated.