SQL Server Reporting Services “interal error occurred”
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.
Thanks so much!! This was so helpful. I knew it had to be simple.
I just fixed a similar problem where I was getting the same useless error message. I told my boss what was happening. He must have
searched his own notes about SSRS problems he experienced. He had me look at this page:
http://apps.craddockfamily.com/blog/?=198
It turns out that the report “forgot” the first dataset when I tried add a second dataset. Here’s what you
can do to check if that’s the problem. Go to the Layout tab, right click the
outer most object that gets its data from the first dataset, click Properties,
on the Properties dialog click the General tab. You’ll see the name of the
object. Look at the dropdown named Dataset name:. If it’s blank, select the
dataset it should be using.