Database View report drilldown not working

yundlu316 · ‎09-01-2016

Hi Everyone,

Our team has created a database view that combines sys_user, tasks, and aprofile table we built separately. From this database view, I was able to create a column report that shows past due tasks by manager. I also created a drilldown view where if someone clicks into one of the columns, they can see a list report of details. The initial view of this column report shows up just fine, however, when you click into a particular column, the list report never shows up and all I see is a spinning circle saying "Loading Report..."

Any ideas?

Thanks.

devi_putra · ‎09-02-2016

Hi David,

So you are impersonating with some other user who has role "HR Supervisor". Here you are able to see the report but when you click on the Red column you are getting that message. So as i mentioned above, whenever you click on the Columns in the Report you will be redirected to the List view of that particular Table which is used in the Report. Here as you have created this report on a Database view, so when you click on Red column you will be redirected to list view of the Database view(here i.e Database view for sys_user, task, and employee profile).

Now the reason why that message is coming is:

The User you have logged in might not have a Read access to any one of the above mentioned tables(sys_user, task, and employee profile).

So could you please open each table individually & check the Read access controls given roles & see if this user has those Roles.

How to check this--->

Login as Admin user, go to "Tables" module, open the required table(for example: say i am opening "Task_sla" table)

Then you will see

Then in the Related Lists you will see the Access Controls for that table,

Search for read operation ACL

Open this ACL, & see the Roles given in this ACL...

So just check the roles given in ACL's similarly for all the 3tables mentioned above & see that those Roles are given to the User you are impersonating to view the Report Content.

Hope this will help you.

Thanks,

Devi.

PS: Hit like, Helpful or Correct depending on the impact of the response.

View solution in original post

devi_putra · ‎09-01-2016

Hi David,

I see a message "Security constraints prevent access to requested page" in the background of the image.

Generally this message is due to ACL's restrictions.

Could you just see how the report "Visibility" is setup, i think this report is given access to a particular user & that user is other than you.

You can see the visibility settings in "Sharing" option which is present in the dropdown of Save button.

Hope this will help you.

Thanks,

Devi

PS: Hit like, Helpful or Correct depending on the impact of the response.

yundlu316 · ‎09-02-2016

Hi Devi,

Thanks so much for your response. I noticed that message in the back as well... The original chart shows up below, but once I click in the red column, I get that security message in the background with the Loading wheel spinning endlessly. I've checked my sharing option and I've given the role HR Supervisor (I created this) to this report. This role contains several other roles for each table in our app. Since this report is a database view, is there a particular role I need to add for being able to view database views?

Thanks!

devi_putra · ‎09-02-2016

Hi David,

So you are able to view the Report but once you click on the Red column in the Chart you are getting that message right..!!

Generally whenever you click on the Chart columns, you will be redirected to the list view of that particular table.

So i think you don't have Read access to that particular table.

So could you please check if you have Read access(ACL's) to all the tables(as you have created this report on a DataBase view, there will be more than one table included) used in this Report.

Hope this will help you.

Please let me know if you have any question on this.

Thanks,

Devi

PS: Hit like, Helpful or Correct depending on the impact of the response.

yundlu316 · ‎09-02-2016

Hi Devi,

What you said above is correct. I actually created a role called HR Supervisor and gave a handful of accounts that role. Within that role, I've given them the following roles:

When I impersonate one of the accounts with the HR Supervisor role, I can see the red column, but when I click into it, that's when I see the everlasting Loading prompt. The database view contains the sys_user, task, and employee profile (we created this one) tables. The role of task_activity_reader is given to the HR Supervisor as indicated in the screenshot above, so I'm a bit confused why my impersonated accounts can't view the drill down.

Any thoughts?

Thanks!!