Tuesday, March 20, 2012

Reporting Services log file roulette - how to tell which log file SSRS is writing to for errors?

I'm sure I'm not the only one frustrated trying to figure out which log file SSRS writes to when an error occurs. Does anybody know a sure way to tell? It doesn't change the date/time of the date modified, so you can't sort by date in windows explorer. There seems to be no rhyme or reason to which file it writes to. For example, I had to go through 6 log files to find which one was being written to. I had thought (hoped) that it would always write to the log files with the latest embedded date/time stamp as part of the file name. It does not.

I'm tempted to start using a file system spy, or resort to other tactics. Does anyone have a sure fired way to see which log file is written to when an error occurs? I'm not talking about SQL Dump files - just "normal" errors when processing reports.

Thanks,

WillyDog

Hi willydog,

If you take a look in the Logfiles folder, you will notice different names for the log files. The first part of the log file name tells you who logged in that file, so you can figure out in what file to look for a specific error. The second part of the log file name contains the time stamp, so if you sort the log files descending by Date Modified, you will have the most recent files in the top of your list.

So, for the first part of the logfile name, this is the meaning:

- file's name starts with ReportServer - the web service logs into that file

- file's name starts with ReportServerService - the Windows service worker appdomain logs into that file

- file's name starts with ReportServerService__main - the Windows service main appdomain logs into that file (only for start/stop the Windows service)

- file's name starts with ReportServerWebApp - ReportManager logs into that file

See also:

http://msdn2.microsoft.com/en-us/ms156500.aspx#

http://blogs.msdn.com/bimusings/archive/2005/06/26/432798.aspx

Mihaela

No comments:

Post a Comment