To protect customer instances and associated services from outages, B2C Commerce restricts rogue queries that produce 200 thousand results or more. To better protect Salesforce B2C Commerce, Salesforce plans to limit the allowed offset value from 200 thousand to 10 thousand..
When: The new limit will be implemented in the 24.6 Release in June 2024.
How: A rogue query generated by the APIs returns an error message. A manual query generated with Business Manager returns a timeout.
Search request offset <value> is greater than offset limit 10000 for tenant '<GroupID>_<Instance'>, type 'order']To learn more, see Rogue Query Timeouts in the Commerce Cloud B2C Platform