Have Geek Brain

Issues with the SSRS Reports site

So I am working with SSRS (SQL Server 2005) which some of our applications use to create downloads. The problem with this, however, is that the reporting website that is being used to manage it seems to crash randomly. I haven't figured out the rhyme or the reason for this yet - just that it will suddenly exit due to the "Specified cast is invalid" exception and any further attempts to do anything will fail with

Element '/' not found (RsItemNotFound)

Is there a place I can start looking to help me debug this issue? Are there any logs that might contain more detailed information than the useless error messages I receive?

0


a source to share


2 answers


Is there anything in the standard event logs? You will probably find a lot of logs to go through (C: \ Program Files \ Microsoft SQL Server \ MSSQL.3 \ Reporting Services \ LogFiles) ... at least the default path.



+1


a source


We have a web application where I sometimes work, after being alone for a while, it has to "recompile" and take a few seconds before it shows the page. I noticed that ssrs does this from time to time and it may or may not be the cause of your problem.

you can test this by installing an instance of ssrs on your local machine (which you know nobody will be enabled) and running your downloads against that.



also check and make sure no one is doing anything or making backups on boot.

0


a source






More articles:


All Articles