search

tomansley / SimpliListViews

Salesforce List Views App Package
GNU General Public License v3.0
0 stars 0 forks source link

User with SOQL Query Error #153

Open amartineverservice opened 3 months ago

amartineverservice commented 3 months ago

Describe the bug A specific (not all) users is receiving an unusual SOQL error whenever trying to select a list view for the Case object. The simpli list view is a Single sitting on an App Page. the error is "Error retrieving Case list views data. This usually indicates the user does not have read access to the object. if you believe this to be an error - simpli_lv:Too many SOQL queries: 101". This user does have access to the object, does have the permission set,

This also only happens on cases, this user can access tasks without issue.

Simpli List View Version 2.267

To Reproduce Steps to reproduce the behavior:

  1. Be this specific user.
  2. Go to the app page where the simpli list view resides.
  3. Select "Case" as the object.
  4. Click to select the list view. Error will appear.

Expected behavior A drop down of all available case list views appears.

Screenshots image

Desktop (please complete the following information):

Additional context I do not receive this error as system admin (and access to all list views), and this does not happen for other users of similar permissions.

tomansley commented 3 months ago

Hello,

Thanks for posting the issue. A few questions -

  1. The issue suggests that the user does not have the ability to even select the list view correct? i.e. immediately after they select "Case" it throws the error.

  2. Does the user have permissions to all objects like the other users that work correctly? See the permissions required here - https://github.com/tomansley/SimpliListViews/wiki/FAQ#what-are-the-profile-security-settings-i-should-use-for-my-users-1

  3. Can you please turn debugging on, rerun for the user and look for error logs. See how to do this in the FAQ - https://github.com/tomansley/SimpliListViews/wiki/FAQ#how-do-i-turn-debugging-on-and-off-1

Thanks Tom

amartineverservice commented 3 months ago

Thank you for the prompt response! I updated the permissions to match the screenshot in your first link and still ran into the error. I turned on debugging, and here are the two logs that were generated when I logged in as the user and recreated the error. listviewdebuglog1.txt listviewdebuglog2.txt

tomansley commented 3 months ago

Thanks for the logs. Are there no other logs? Unfortunately the two provided were not showing any issues.

One thing that might be useful. Turn on standard Salesforce debugging for the user and then rerun the error. The logs should show all the SOQL statements that are running in order to cause the issue. If you are able to send that log it might be useful.

amartineverservice commented 3 months ago

I had some struggles finding anything in the debug logs but I discovered a permissions setting on the profiles. Now, I don't know why this matters, but the users who had no issues were on a profile that accidentally had "View Setup and Configuration" enabled. When I enabled it for the profiles of the users having issues... voila! The problem disappeared. I'd rather NOT give them this permission set though. Any suggestions?

tomansley commented 3 months ago

Hmmm, thats not good. I agree you don't want to give them that permission.

At least given that it sounds like its a permission issue which makes sense to me. Did you check the permissions that all users have against the FAQ article I sent? Permissions is tricky because everybody does their permissions slightly differently so it could be in a number of places.

amartineverservice commented 3 months ago

Looks like I missed a View All on List View User Configs and we are all set. Thank you!

tomansley commented 3 months ago

Excellent!! Glad it all worked out.

amartineverservice commented 1 week ago

Hello; apologies it's me again. I ran into this issue but this time the permission set did not fix it. That said I was able to get different debug logs for you. I've attached them here. (Also I'm not sure what the etiquette is on this, commenting on an old issue or if I should make a new one)

debug4.txt debug3.txt debug2.txt debug1.txt

tomansley commented 1 week ago

No problems keeping this on the same bug. I will reopen it. Unfortunately the debug logs are not looking very useful! :-(

Are you getting the exact same error as the screenshot above? Or is it slightly different?

Is it also the exact same object? i.e. Case

amartineverservice commented 1 week ago

Same exact error. Too many SOQL queries.

tomansley commented 1 week ago

Crazy question. What is the 15 or 18 character Id of the user that is having this issue?

amartineverservice commented 1 week ago

005UN0000022qHVYAY

tomansley commented 1 week ago

ok, good.

Next questions.

  1. If you go to all your Case list views using standard Salesforce. How many list views are there?
  2. Do your list views use Groups or Territories to determine the data that is to be displayed? (you should be able to see this by going to a list view, clicking the icon and selecting "Sharing Settings"

image

  1. The sharing settings could be something like the following -

image

amartineverservice commented 1 week ago

We have a BUNCH of list views for the Case object! 60 total. Their sharing settings are a mixed bag of "shared with everyone" and shared with groups (roles, roles & subordinates, and public groups.) No uniformity.

tomansley commented 1 week ago

Ok, this is making sense now. The issue is a tough one which is going to take me time. But, there is a workaround. Change your page to use the type-ahead search functionality for the list view drop down. I believe this should fix the issue for now.

Let me know if you have issues with getting this done or it still doesn't solve the problem.

From: amartineverservice @.> Sent: Monday, November 18, 2024 3:55:06 PM To: tomansley/SimpliListViews @.> Cc: tomansley @.>; State change @.> Subject: Re: [tomansley/SimpliListViews] User with SOQL Query Error (Issue #153)

We have a BUNCH of list views for the Case object! 60 total. Their sharing settings are a mixed bag of "shared with everyone" and shared with groups (roles, roles & subordinates, and public groups.) No uniformity.

— Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/153#issuecomment-2484211388, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAC3UGPZJO4WEGYBQORVLFD2BJO3VAVCNFSM6AAAAABL24YTEOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOBUGIYTCMZYHA. You are receiving this because you modified the open/close state.Message ID: @.***>

amartineverservice commented 1 week ago

That fixed it, thank you!