Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SSRS report never loads for one user Expand / Collapse
Author
Message
Posted Wednesday, August 27, 2014 9:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 12:16 PM
Points: 145, Visits: 419
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!
Post #1607890
Posted Wednesday, August 27, 2014 11:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 11,305, Visits: 13,094
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.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1607957
Posted Wednesday, August 27, 2014 3:45 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 12:16 PM
Points: 145, Visits: 419
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
Post #1608067
Posted Wednesday, August 27, 2014 6:23 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 11,305, Visits: 13,094
What version of IE?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1608105
Posted Wednesday, August 27, 2014 6:38 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 12:16 PM
Points: 145, Visits: 419
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?
Post #1608108
Posted Thursday, August 28, 2014 6:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 11,305, Visits: 13,094
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





Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1608246
Posted Thursday, August 28, 2014 8:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 12:16 PM
Points: 145, Visits: 419
Unfortunately neither one helped. Same behavior as before.

Anything else?
Post #1608313
Posted Thursday, August 28, 2014 9:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 11,305, Visits: 13,094
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?




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1608327
Posted Thursday, August 28, 2014 10:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 12:16 PM
Points: 145, Visits: 419
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.
Post #1608342
Posted Thursday, August 28, 2014 11:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 11,305, Visits: 13,094
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?




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1608361
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse