Loading

Cache or sync failures on high-volume objects referencing more than 100,000 distinct IDs.

Udgivelsesdato: Jun 25, 2026
Beskrivelse

Metadata Cache generation fails for high-volume objects (e.g., HealthcareProvider) with an error indicating more than 100,000 distinct IDs were returned by the SOQL query.




Root Cause

Object Metadata Cache Configuration SOQL for high-volume objects (e.g., HealthcareProvider) does not include a WHERE clause or LIMIT, causing the query to exceed platform limits.

 

Løsning


  1. Navigate to the Object Metadata Cache Configuration:
    • Go to Admin Console > Mobile > Object Metadata Cache Configuration.
    • Open the record whose SOQL query references the high-volume object (e.g., HealthcareProvider).
  2. Review the existing SOQL query:
    • Check if the query is missing a WHERE clause or LIMIT.
    • Example of a problematic query: SELECT Id, Name FROM HealthcareProvider
  3. Add a WHERE clause and/or LIMIT to the query:
    • Filter by active or relevant records to reduce result size.
    • Example of a corrected query: SELECT Id, Name FROM HealthcareProvider WHERE IsActive = true LIMIT 50000

        4. Avoid loading objects without filters if record volume exceeds 50,000 rows.

Vidensartikelnummer

005387212

 
Indlæser
Salesforce Help | Article