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.
39 comments:
Thank you for taking the time to post it. It did the trick and saved me time and effort.
elena
+1
Thanks
Thanks a lot. Saved my time.
thaaaaaaaaaaaaaaaankssss :D
I was getting angry with this!
+1 Thanks as well :)
WOW! thank you sooo much! Saved me hours of searching!
Yes, thanks. You saved me some time, too. I was messing with accounts and permissions, etc. and found your post.
Thanks David. I spent about an hour over this till I stumbled across your article about it.
Thanks, David... You saved me quite a bit of time too.
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!!
ThanX man !
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
What is source control? Where can I do it? And how? Can someone please tell me the steps of removing it? Please! Thanks :)
What is source control? Where can I do it? And how? Can someone please tell me the steps of removing it? Please! Thanks :)
Thank you - perfect solution!
"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.
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
Yet another person you've helped with this. I can move on to the actual report changes instead of this sillyness
Thanks. I just deleted the .data file and the problem was gone.
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.
this is good solution, and saved my time , Many thx to David.. :)
Thanks for this blog, This have saved my time, Many thanks to David
Thank you very much!
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!
Thanks for the post David, saved me lots of time.
Worked just Fine! Thank you!
Cheers, worked a treat.
Excellent. I was wondering what had caused this and looking up online for solutions on this. Thanks for posting this :)
My cousin recommended this blog and she was totally right keep up the fantastic work!
Data Conversion Services India
not always correct solution not under source control and solution has never been placed into source control?
remove the .data file does work?
Thanks,
Matthew
Crane & Rigging
This helped me as well. Thank you!
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.
Thanks a lot!
Thanks a lot. you saved my hours, I was going crazy
My Friend, Thank you very much!
This post helped me a lot.
Thank you David - This helped me this afternoon.
Not sure why you needed this step though? "and mark the local file as read only"
Post a Comment