
SQL Server Reporting Services “interal error occurred”
Posted by
Aaron in
SQL Server Reporting Services on
Feb 8th, 2009 |
one response
If you work with SQL Server Reporting Services (SSRS) 2005 for any length of time, you’ll see a number of ambiguous error messages. I recently ran into the error below and found the solution quite easy. Maybe you’ll encounter this one day and I’ll save you some headache.
An error occurred during local report processing.The definition of the report ‘/Main’ is invalid.An internal error occurred on the report server. See the error log for more details.
I could not view the error log, since I was previewing the report. This problem happened simply because I had a Dataset with the same name as my table. I had recently changed the name of my table to make more sense, not realizing that the Dataset was named the same. To solve this problem, I renamed my table, but I could have renamed the Dataset just as easily.
Thank you so much. I had exactly this problem and your post saved me a lot of trouble. After sifting through a lot of posts in several forums, I was close to giving up on this because I couldn’t see any real useful solution to my problem – until I finally bump into this.