Troubleshooting Logging and Reporting

The Reporting Application is Unable to Generate Reports

Database is too Large

Over time, the records for the logs will make the database file become large, making the ability to search slower, possibly causing report generation to fail.

Fix:

  1. Create a backup for the database.
  2. Purge old database records.

The MSMQ is Full

In the event the Microsoft Message Queue (MSMQ) becomes full, messages are no longer sent for logging. When the MSMQ fills up on a Workstation, this is normally due to an issue with the Workstation connection to the logging server. If this occurs on the logging server, this indicates an issue with the connection from the logging service to the SQL database.

Note: The below steps will delete any log entries created prior to purging the MSMQ.

Fix:

  1. Open Computer Management.
  2. Go to Services and Applications > Message Queuing > System Queues.
  3. Right-click Transactional Dead-letter messages and click All Tasks > Purge.
  4. When prompted to confirm the deletion of queued messages, click Yes.
  5. In Windows, open Services.
  6. Right-click the Message Queuing service and click Restart.