The CreatorCon Call for Content is officially open! Get started here.

Getting error on workspace list - Can't display this list

ServiceNowVS
Tera Expert

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:

ServiceNowVS_0-1705946888386.png

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.

4 REPLIES 4

Siddhesh Gawade
Mega Sage
Mega Sage

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

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.

Siddhesh Gawade
Mega Sage
Mega Sage

Hello @ServiceNowVS ,

 

Not sure, but maybe this will resolve issue https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1118065.

 

Regards,

Siddhesh

 

ThunderDev
Tera Guru

Were you able to find a resolution for this issue? I am having a similar issue