Report_view - "Widget cancelled - maximum execution time exceeded"

[Jose MMR]

Hi all,

I have a dashboard that shows to users on a report list on a dashboard the message :

"Access to the content denied based on report_view ACLs"

Well, this report reads from a database view. I create a new report_view ACL for each table that belongs to this database_view.

Now seems that is loading but after 30 secord shows me a message that says:

"Widget cancelled - maximum execution time exceeded"

¿anyone can said me if i forguet any or somethins?

Seems that in past, user can access without problem of widget load time.

I open with admin user and loads correctly the 5k records.

Regards

[Mohan raj]

Hi @Jose MMR,

Check out the below-mentioned knowledge article for a similar problem to yours.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0715793#:~:text=The%20message....

If my response helps you to resolve the issue close the question by Accepting solution and hit thumb icon. From Correct answers others will get benefited in future.

Regards,

T Mohan.

[Jose MMR]

Hi Mohan

Yes, I try testing with 50 and 70.

Not more tiem, I only want to test it. Higher levels seems me that penalize environment behaviour.

Regards.

[Jose MMR · Accepted solution]

Hi,

We delete user_preferences sort records and now all reports on dashboards loads correctly.

I follow point 2 in this link:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0793303

Regards.