Resolving Common Errors in TargetX Communities

Error:  TX_MakeUniqueNickname: execution of BeforeInsert caused by: System.QueryException: Non-selective query against large object type (more than 200000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times) Failing Query: SELECT Id, CommunityNickname FROM User WHERE CommunityNickname = :tmpVar1 Current Apex position:TX_UniqueNicknameHelper [8,1] Apex stack:Trigger.TX_MakeUniqueNickname: line 6, column 1 Class.TX_UniqueNicknameHelper.getMatchingUsers: line 8, column 1 Trigger.TX_MakeUniqueNickname: line 6, column 1

Cause: This error occurs when your Salesforce Org exceeds 200,000 user records.

Resolution: Submit a case to Salesforce Support and request the Nickname (API: CommunityNickname) field on User be indexed. If Salesforce Support asks for the query that is failing, provide the following:

Applicant record has the wrong email address

1. Go to the Contact record and select Disable Community User from the picklist:

2. Navigate to Setup and search for Users.
3. Click Edit.
4. Update the Email on the User record.
5. Save your changes.
6. Go back to the Contact record and select Enable Community User from the picklist:

Note: The student will need to update their password after this process. 

Communities reset password link goes in a loop

Recommended workarounds: 
    
If an Outlook user is experiencing this issue, ask them to perform the following [1]:

1. Open Outlook.com in their browser.
2. Go to Settings | Options.
3. Go to Mail | Layout | Link preview.
4. Disable the Preview links in email option, and click Save.
5. Go to the community site and perform a password reset.
6. After receiving the email, open it and click the link. It should work correctly.

Option 2: Clear the Cache and Cookies from your browser.

[1] “Knowledge Article 000269112”. 

1. Associate a Contact to a Related User.
2. Navigate to Setup search for Digital Experiences (formerly All Communities), and click All Sites.
3. Select Workspaces for the Community to which the user needs access.
4. Click Administration, then Members.
5. Under Available Profiles, select the profile assigned to your User and click the Add button.
6. Save your changes.

New users can't create a new password

When the Forgot Password page is looping, this is typically caused by email clients (specifically Outlook, Yahoo, and occasionally Gmail), which preview the forgot password link and, therefore cause it to expire before the student can use it. Users can go to the Settings of their email client and ensure that Preview Links is turned off.

You can also update the Password Policies setting in the User Profile:

1. Navigate to the Profile of the user experiencing the problem.
2. Scroll down to the Password Policies section of the profile.
3. You'll see an option labeled Don't Immediately Expire links in forgot password emails. 
4. Check this box.
5. Save your changes.