Friday, 10 July 2009

Fix - SQL Reporting Services 2008 - An error occurred during local report processing. Access Denied with HRESULT 0x80030005


While attempting to preview a report developed by another user (after getting it out of Visual Source Safe), I was confronted by the following error:

An error occurred during local report processing. Access Denied. (Exception from HRESULT: 0x80030005 (STG_E_ACCESSDENIED))

I created another report exactly the same and it seemed to work fine - so there was some other kind of caching issue causing this error.

After investigating, I noticed that the REPORTNAME.rdl.data file (which is a binary file and is how SSRS reports cache their preview information) - was read-only. SSRS was trying to write to the file and consequently getting the access denied errors. This was because the rdl.data file had erroneously been put into source control.

The fix was to remove it from source control (as it should be generated as each user previews the report), and mark the local file as read only.

Of course it would be much nicer (and simpler to troubleshoot the issue) if this particular "Access Denied" error message was more descriptive and actually told me *which* file it was trying to access.

40 comments:

Anonymous said...

Thank you for taking the time to post it. It did the trick and saved me time and effort.
elena

Anonymous said...

+1
Thanks

podamone said...

Thanks a lot. Saved my time.

Junior said...

thaaaaaaaaaaaaaaaankssss :D
I was getting angry with this!

Maets said...

+1 Thanks as well :)

Anonymous said...

WOW! thank you sooo much! Saved me hours of searching!

Joe Wilson said...

Yes, thanks. You saved me some time, too. I was messing with accounts and permissions, etc. and found your post.

Anonymous said...

Thanks David. I spent about an hour over this till I stumbled across your article about it.

hugeheo said...

Thanks, David... You saved me quite a bit of time too.

Aaron said...

I made the mistake of putting these rdl.data files into source control. I removed them and now these files are no longer read-only. Worked perfectly!!

AmiT said...

ThanX man !

sue said...

Thanks David - not just for finding the fix but to take the time to post the solution.

I found your solution just in time for my demo! :-)

Sue

[xuan says] said...

What is source control? Where can I do it? And how? Can someone please tell me the steps of removing it? Please! Thanks :)

[xuan says] said...

What is source control? Where can I do it? And how? Can someone please tell me the steps of removing it? Please! Thanks :)

akerch said...

Thank you - perfect solution!

J. said...

"Of course it would be much nicer...if this particular "Access Denied" error message was more descriptive and actually told me *which* file it was trying to access."

Second! I am no MS basher and generally think they do things alright. But if I see another "null object" message without even SOME indication of the object in question. I don't know what bonehead over at MS is in charge of exception messaging, but he should be canned!

Thanks for this post, have been dealing with .data crap for awhile and your explanation of *what* they are was the most straight forward and helpful.

Bacha!!! said...

I have tried all the options in Microsoft World before looking your post. Closing the Report,Closing the solution and the great Microsoft Soft Solution for everything "Restarting your God Damn System".Thanks a Ton

Ana said...

Thank youuuuuuuuuuuuuuuuu !!!
Really, you've save my life :)

Epikto said...

Yet another person you've helped with this. I can move on to the actual report changes instead of this sillyness

Alex said...

Thanks. I just deleted the .data file and the problem was gone.

jt said...
This comment has been removed by the author.
jt said...

I get the exact same error but I'm not sure if the source control fix is the solution for me. I recently took a 2008 Reporting Services class and the book (MS 6236a) came with a CD that I can use for self practice. I ran the install and all the reports were installed locally on my machine. When I try to view a report within a solution file, I get the same error message as everyone else. In my case, am I dealing with a source control issue? If so, how do I go about fixing? I'm pretty much a noob when it comes to source control, don't know anything about it. The files are located on my local machine and as an attempt to fix I granted myself full control and made myself owner of parent and sub-folders. Any suggestions? Thanks in advance.

Parixit said...

this is good solution, and saved my time , Many thx to David.. :)

Parixit said...

Thanks for this blog, This have saved my time, Many thanks to David

Unknown said...

Thank you very much!

rhandloff said...

Thanks so much! I have only done a little SSRS programming until recently. I wrote stored procedures day in/day out for years. Now my job involved a lot of SSRS/SSIS and soon SSAS and I'm running into lots of little gotchas. These brief posts are very helpful for when I'm in the middle of something and just need the answer instead of a lengthy analysis - as enjoyable as those can be!

Thanks again!

Doug Purnell said...

Thanks for the post David, saved me lots of time.

Tiago Bockholt said...

Worked just Fine! Thank you!

Ruairi said...

Cheers, worked a treat.

Aparna said...

Excellent. I was wondering what had caused this and looking up online for solutions on this. Thanks for posting this :)

elakkeya yadhavan said...




My cousin recommended this blog and she was totally right keep up the fantastic work!










Data Conversion Services India

BobF said...

not always correct solution not under source control and solution has never been placed into source control?

BobF said...

remove the .data file does work?

Matthew Elliott said...

Thanks,
Matthew
Crane & Rigging

Anon said...

This helped me as well. Thank you!

bob said...

Hi, i'm trying to run a report in AX 2012 and getting the following error "an error occurred during local report processing".

I am new bie in AX don't know what's going wrong, i have found a blog which has same error

http://www.ax2012r3.com/blog/error-in-running-auto-report

Any help is appreciated.

shikha said...

Thanks a lot!

Vikram G said...

Thanks a lot. you saved my hours, I was going crazy

Erick said...

My Friend, Thank you very much!
This post helped me a lot.

Andrew Reed said...

Thank you David - This helped me this afternoon.
Not sure why you needed this step though? "and mark the local file as read only"