function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rachel ThibodauxRachel Thibodaux 

List has no rows for assignment to SObject: Volunteers for Salesforce Shift Calendar

The Shift Calendar within our organization's website is not reutrning any values. Normally, it looks like this:
User-added imageOur volunteers are able to click on the shift they want and sign up. Right now, it is showing this:User-added imageI am having trouble identifying what is causing the issue. The Shift Calendar is working just fine and looks normal in our salesforce org. On our actual website, we have the error. Can anyone help?
Best Answer chosen by Rachel Thibodaux
Rachel ThibodauxRachel Thibodaux
This issue has been fixed thanks to Cori O'Brien with Salesforce! In case anyone else ishaving the same problem:
 
 
 
Hi @Rachel Thibodaux (Catholic Services of Acadiana)​, while it might not seem like it should be related, there is a Salesforce Core bug that is preventing the Site Guest User Profile from referencing itself in a SOQL query in the V4S code, when it's looking for the timezone of the Guest User online. In order to resolve the error on the Job Calendar, you just needed to modify OWD for User object to something different (like Private), then changing it back to what it was before. This forces the sharing rules to reset (including others not seemingly applicable to the User object).
 
Hope that helps, and sorry for the trouble! Salesforce core teams are working on resolving the issue, and you can select the "This Issue Affects me" on the Known Issue  (https://success.salesforce.com/issues_view?id=a1p3A000001YoRnQAK" style="color:#015ba7; text-decoration:none" title="https://success.salesforce.com/issues_view?id=a1p3A000001YoRnQAK)to stay on top of the fix.

All Answers

Rachel ThibodauxRachel Thibodaux
This issue has been fixed thanks to Cori O'Brien with Salesforce! In case anyone else ishaving the same problem:
 
 
 
Hi @Rachel Thibodaux (Catholic Services of Acadiana)​, while it might not seem like it should be related, there is a Salesforce Core bug that is preventing the Site Guest User Profile from referencing itself in a SOQL query in the V4S code, when it's looking for the timezone of the Guest User online. In order to resolve the error on the Job Calendar, you just needed to modify OWD for User object to something different (like Private), then changing it back to what it was before. This forces the sharing rules to reset (including others not seemingly applicable to the User object).
 
Hope that helps, and sorry for the trouble! Salesforce core teams are working on resolving the issue, and you can select the "This Issue Affects me" on the Known Issue  (https://success.salesforce.com/issues_view?id=a1p3A000001YoRnQAK" style="color:#015ba7; text-decoration:none" title="https://success.salesforce.com/issues_view?id=a1p3A000001YoRnQAK)to stay on top of the fix.
This was selected as the best answer
HMBA Admin2HMBA Admin2
@Cori O'Brien I am having a similar problem and this recommended fix is not working. Any other advice?
Tim Otremba - GiGi'sTim Otremba - GiGi's
I'm also having the same problem.  I have tried the workaround posted by @Cori O'Brien, but it didn't seem to fix the issue.  If I manaully share the Site Guest User with itself, the problem goes away - but that won't be allowed soon.  Note: I had previously unchecked the "View all Users" setting from the site guest user's profile as was recommended by Salesforce and now that setting is hidden in my sandbox.
Danielle Flood 7Danielle Flood 7
Also struggling! Any updates @Tim Otremba - GiGi's or @HMBA Admin2 ?
Cori OBrienCori OBrien
Hi All, I don't monitor this community (or get it's notifications apparently) as I missed all of this as we only support customers in the Power of Us Hub.
We're seeing that a Salesforce Core bug is causing the job calendar error, and the Salesforce.org Support team will need to get a case from each affected customer so that internal tools can be run to fix it. https://powerofus.force.com/s/article/SFDO-CS-Create-a-Tech-Support-Case
Tim Otremba - GiGi'sTim Otremba - GiGi's
@Daniell Flood - I opened a support ticket on Monday of this week and do not yet have any progress.  My problem is happening in a Sandbox and the guest user security changes have been delayed (https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F93A0000004mDI&fId=0D53A00004oau7F (https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F93A0000004mDI&fId=0D53A00004oau7F)), so I haven't pushed on escalating this just yet.  From Cori's comments, it is best to make sure that the ticket gets to the Salesforce.org support group for faster resolution.  My ticket is with the normal support group.
Danielle Flood 7Danielle Flood 7
Thanks, Tim! My ticket is with Cori now, and I'm hopeful for a resolution soon!