question

BowersNeil-6746 avatar image
0 Votes"
BowersNeil-6746 asked Joyzhao-MSFT answered

SSRS Trace Log File Parsing

Greetings,

Has anyone come up with either a formatting formula in LogParser, or some other method to easily parse and ingest the Reporting Server trace log files?

For whatever reason, the SSRS developers have chosen to not put the error messages for report execution into the appropriately named ExecutionLog table. Instead the information is only available either with Remote Errors turned on (Security issue), or by reading through the Trace files.

I have a need to ingest these trace files for researching and resolving errors, doing so manually is not an option as I have a scale-out environment with 3 nodes and thousands of users an hour - it's impossible to keep up with the files manually.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @BowersNeil-6746 ,
As far as I know, there is no automatic extraction of related trace logs, but it is supported to add custom configuration settings to specify the dump file location, which means you can dump these trace logs to other paths.
You can manage the trace log behavior in the configuration file ReportingServicesService.exe.config.
When viewing the error log, we usually find "Error" through the "Find" function. Of course, some "WARN" messages sometimes appear, but they likely would not prevent the report server from starting.
For more information, please refer to: Report Server Service Trace Log.
Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.