SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS report never loads for one user


SSRS report never loads for one user

Author
Message
tacy.highland
tacy.highland
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 473
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!
Jack Corbett
  Jack Corbett
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45513 Visits: 14925
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
tacy.highland
tacy.highland
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 473
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
Jack Corbett
  Jack Corbett
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45513 Visits: 14925
What version of IE?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
tacy.highland
tacy.highland
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 473
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?
Jack Corbett
  Jack Corbett
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45513 Visits: 14925
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
tacy.highland
tacy.highland
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 473
Unfortunately neither one helped. Same behavior as before.

Anything else?
Jack Corbett
  Jack Corbett
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45513 Visits: 14925
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
tacy.highland
tacy.highland
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 473
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.
Jack Corbett
  Jack Corbett
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45513 Visits: 14925
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search