Getting error on workspace list - Can't display this list
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 10:09 AM
Hi Team,
We have created a database view where we have joined multiple tables and used Query BR to display certain data to user. We are displaying that report on workspace view.
However for few users when they are clicking on that report list, they are getting below error:
Is this because of the number of data? because for few users having less data it is displaying.
But this user has more than 2500+ records which they should be seeing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 11:28 AM
Hello @ServiceNowVS,
I think it should be beacause of ACLs. as you are using the multiple tables for database view. The user must need access to all tables. So please confirm the user has all required access.
Kindly mark the answer ✔️Correct or Helpful ✔️If it addresses your concern.
Regards,
Siddhesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 11:32 AM
Hi Siddhesh,
User has access to all tables. If the record number is less then they are able to see data.
However when it increases around 2000+ then it gives error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 11:43 AM
Hello @ServiceNowVS ,
Not sure, but maybe this will resolve issue https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1118065.
Regards,
Siddhesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2024 11:09 AM
Were you able to find a resolution for this issue? I am having a similar issue