• Mik Pellicci 10
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
here is the link
https://developer.salesforce.com/forums/ForumsMain?id=9060G000000I2MSQA0

Apex test: "Error MessageSystem.QueryException: List has no rows for assignment to SObject"
Hi All
Please can you help resolve this issue I am having with Step 2 of the Security Specialist Badge.
Having got to step 2 but cannot get any response other than this after running the Apex test: "Error MessageSystem.QueryException: List has no rows for assignment to SObject" this is not telling me anything just that it hs passed 0/2. I have configuresd the following:
I have tried loging in for each profile and it all seems to work ok including the the Project manager (add Samantha to the group to test)
OWD 
Account Public read/Write (Was Public read only) Opportunity (Private) Contacts Default (Controlled by Parent)
User
Samantha Cordero Filed Sales User (profile) Field Sales Role.
Profiles and Roles:
Field Sales User Profile  Account (RE) Opportunity (RCE)
 Field Sales Role (Users in this role cannot access opportunities that they do not own that are associated with accounts that they do own)
Inside Sales User Profile Account(RCE) Opportunities (RCE)
Inside Sales Role (Users in this role can edit all opportunities associated with accounts that they own, regardless of who owns the opportunities)
Executive Sales User Profile (Account R VA) Opportunity (R VA)
Executive Sales Role(Users in this role can view all opportunities associated with accounts that they own, regardless of who owns the opportunities)

Group
Project Managers
(Criteria based sharing rule below)

Sharing Rules
User-added imageUser-added image


Thanks in advance for any assistance that can be given