SSRS report never loads for one user

  • Hello all

    I have run into an issue with the Report Manager (browser) where a new user that I just created has the ability to view all the necessary reports, but when they actually attempt to run them, they all just stall at the Loading screen and never render. No errors, just Loading, Loading, Loading...

    If I log in as any other user, they have no issue running the same reports.

    Did I miss something in permissions for the new user somewhere? They have Browser Item-Level permissions on the whole folder that houses the reports. I can't think of what would cause one user to not be able to render reports when no one else has the same issue.

    Can anyone help?

    Much appreciated!

  • have you looked in the ExecutionLog3 view in the ReportServer database to see if the execution is ever finishing from the server perspective?

    I think you can also query RunningJobs to see if the report is hung.

  • I did look at the ExecutionLog3 view and it shows a Status of rsSuccess, along with stats for TimeProcessing, TimeRendering, etc. (I've never used this view before, so I'm just assuming that the Report Server believes it was executed.) But it clearly never completes/renders.

    I'm actually recreating this situation now while the page shows Loading and querying both the RunningJobs table and ExecutionLog3 view. The RunningJobs table shows nothing.

    Is this strange or what?

    The reason I think it's a permissions issue is because when I log onto the site and run the reports as the administrator, there's no issue. But I'm not aware of additional permissions for users beyond the "browser" item level which pretty much gives them the ability to view and run the reports.

    Is there anything else I can check?

    Thanks so much

  • What version of IE?

  • It's version 11.

    Here's some additional info I've found:

    - I run into this problem logged in as anyone (even administrator) while I'm on the browser on the actual SQL Server.

    - I run into this problem (or a variation of it) with one of my users who is using her own browser on her machine and using the new login, but it doesn't do the Loading Loading forever, it just doesn't show anything.)

    - I do not run into this problem with one of my users who is using her own browser on her machine and using a different user login (one that's existed for a while).

    - I do not have this problem on my own local browser logging into and running the reports as the administrator (have not yet tried it as regular user as it requires a reboot) **just also tried it locally with the new user and no problem whatsoever.

    So, essentially, on my local machine I have no problem running reports via any user. On other machines (including from the SQL Server itself) it's having problems, (but then again, even the second scenario isn't foolproof. Go figure.)

    Anything else I should check?

  • Okay there are a couple of things I've found that relate to security and UAC that might be the issue, but I haven't seen the behavior you are seeing when these happen:

    1. Run IE as administrator (right-click -> select Run as Administrator)

    2. Add the Report Manager site as a trusted site

  • Unfortunately neither one helped. Same behavior as before.

    Anything else?

  • tacy.highland (8/28/2014)


    Unfortunately neither one helped. Same behavior as before.

    Anything else?

    Sorry, I'm basically tapped out. The only other things I can think of are:

    1. A network trace using something like WireShark or Fiddler to see what's passing from the client to the report server

    2. A SQL trace on the SQL Server hosting the ReportServer to see what's happening there.

    3. A SQL trace on the SQL Server hosting the data to what's happening there.

    These things might show you where the problem is happening.

    One question:

    How are permissions setup on the report?

  • The permissions to the report are inherited from the folder it's in, which is inheriting from the root. So nothing special about the report specifically.

    This is just weird.

    I appreciate all your help on this.

  • tacy.highland (8/28/2014)


    The permissions to the report are inherited from the folder it's in, which is inheriting from the root. So nothing special about the report specifically.

    This is just weird.

    I appreciate all your help on this.

    I wasn't clear enough, I meant how is the report accessing the data? Is it using the users login or some other method?

  • It's using stored credentials in the shared datasource. Is that what you were asking?

    (This is how we set up the security for all of our reports.)

    Could this impact things?

  • tacy.highland (8/28/2014)


    It's using stored credentials in the shared datasource. Is that what you were asking?

    Yes

    Could this impact things?

    I don't think so.

  • Have you tried running the browser in compatibility view and adding the site to the trusted site list?

  • Oh my goodness. Compatibility View did it.

    Thank you so much, never even considered this to be the issue!

    Thanks for everyone's help!

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply