nerdexam
Microsoft

70-466 · Question #85

You need to ascertain why Marc did not receive his reports. What should you do?

The correct answer is A. Search the ReportServerService_<timestamp>.log file for errors.. This question tests where SSRS logs subscription and report delivery errors for troubleshooting failed report delivery.

Implement a reporting services solution

Question

You need to ascertain why Marc did not receive his reports. What should you do?

Options

  • ASearch the ReportServerService_<timestamp>.log file for errors.
  • BSearch the registry for errors.
  • CUse the Windows Event Viewer to search the Application log for errors.
  • DUse SQL Server Management Studio to search the SQL Server logs for errors.

How the community answered

(38 responses)
  • A
    89% (34)
  • B
    3% (1)
  • C
    3% (1)
  • D
    5% (2)

Why each option

This question tests where SSRS logs subscription and report delivery errors for troubleshooting failed report delivery.

ASearch the ReportServerService_<timestamp>.log file for errors.Correct

The ReportServerService_<timestamp>.log file is the SSRS service trace log that records subscription processing, delivery attempts, and errors in detail. When a user does not receive a scheduled or subscribed report, this log captures the exact delivery failure reason including delivery extension errors, rendering errors, and scheduling problems. It is the primary diagnostic file for SSRS report delivery issues.

BSearch the registry for errors.

The Windows registry stores configuration settings, not runtime error logs, so it will not contain information about a failed report delivery event.

CUse the Windows Event Viewer to search the Application log for errors.

The Windows Application Event Viewer may log high-level SSRS service crashes but does not contain the detailed subscription and delivery error information needed to diagnose why a specific user's report was not received.

DUse SQL Server Management Studio to search the SQL Server logs for errors.

SQL Server engine logs record database engine activity such as startup and query errors, not SSRS subscription delivery failures, which are handled at the reporting services layer.

Concept tested: Troubleshooting SSRS report delivery using service trace logs

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources

Topics

#SSRS logs#report subscriptions#troubleshooting#ReportServerService log

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice