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

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.