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.
at

39 comments:

  1. Anonymous14 August 2009 at 06:26

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

    ReplyDelete
  2. Anonymous27 August 2009 at 07:11

    +1
    Thanks

    ReplyDelete
  3. podamone20 September 2009 at 13:57

    Thanks a lot. Saved my time.

    ReplyDelete
  4. Junior22 September 2009 at 07:41

    thaaaaaaaaaaaaaaaankssss :D
    I was getting angry with this!

    ReplyDelete
  5. maets22 September 2009 at 20:06

    +1 Thanks as well :)

    ReplyDelete
  6. Anonymous29 October 2009 at 06:20

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

    ReplyDelete
  7. Joe Wilson12 November 2009 at 06:56

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

    ReplyDelete
  8. Anonymous2 December 2009 at 09:10

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

    ReplyDelete
  9. Unknown9 December 2009 at 22:57

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

    ReplyDelete
  10. Aaron4 February 2010 at 07:25

    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!!

    ReplyDelete
  11. Unknown5 February 2010 at 18:43

    ThanX man !

    ReplyDelete
  12. Unknown24 March 2010 at 21:30

    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

    ReplyDelete
  13. [xuan says]23 April 2010 at 17:46

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

    ReplyDelete
  14. [xuan says]23 April 2010 at 17:47

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

    ReplyDelete
  15. Ann Wunderlin26 May 2010 at 11:04

    Thank you - perfect solution!

    ReplyDelete
  16. Gh0st22 July 2010 at 23:36

    "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.

    ReplyDelete
  17. Bacha!!!29 October 2010 at 00:10

    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

    ReplyDelete
  18. Epikto26 May 2011 at 03:26

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

    ReplyDelete
  19. Unknown7 July 2011 at 08:39

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

    ReplyDelete
  20. jt19 July 2011 at 06:48

    This comment has been removed by the author.

    ReplyDelete
  21. jt19 July 2011 at 06:48

    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.

    ReplyDelete
  22. Parixit20 October 2011 at 21:05

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

    ReplyDelete
  23. Parixit20 October 2011 at 21:07

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

    ReplyDelete
  24. Unknown11 November 2011 at 05:55

    Thank you very much!

    ReplyDelete
  25. Anonymous28 April 2012 at 06:36

    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!

    ReplyDelete
  26. Doug Purnell17 May 2012 at 06:35

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

    ReplyDelete
  27. Tiago Bockholt14 June 2012 at 23:39

    Worked just Fine! Thank you!

    ReplyDelete
  28. Ruairi26 July 2012 at 11:07

    Cheers, worked a treat.

    ReplyDelete
  29. Aparna19 September 2012 at 04:46

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

    ReplyDelete
  30. elakkeya yadhavan1 December 2012 at 17:17




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










    Data Conversion Services India

    ReplyDelete
  31. BobF3 March 2013 at 22:36

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

    ReplyDelete
  32. BobF3 March 2013 at 22:38

    remove the .data file does work?

    ReplyDelete
  33. Unknown20 May 2013 at 00:40

    Thanks,
    Matthew
    Crane & Rigging

    ReplyDelete
  34. Anon7 June 2014 at 04:56

    This helped me as well. Thank you!

    ReplyDelete
  35. bob26 June 2014 at 13:09

    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.

    ReplyDelete
  36. shikha17 September 2014 at 10:17

    Thanks a lot!

    ReplyDelete
  37. Vikram G7 November 2014 at 09:15

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

    ReplyDelete
  38. Erick18 March 2015 at 02:56

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

    ReplyDelete
  39. Unknown18 March 2016 at 04:31

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

    ReplyDelete