Error: "Sorry, the operation has been cancelled as it took more than expected time to complete. Please try again after some time."

This article covers

The operation has been cancelled error when applying a filter.

Solution

This error usually comes when you are searching and filtering customers/subscriptions/invoices etc. It could show like this (below image) or in the middle of the screen with no results.

This error would occur due to a slow query or query getting timeout due to a huge number of records.

Since sorting the records and applying the index on all the records would be slow and the query would get a timeout.

As a workaround, you can filter the records further by applying the date range as this would reduce the number of records, or any other filters as per your requirement.

Related Article

Is it possible to divide customers into categories based on conditions such as their payment method(Gocardless, Stripe or Offline)?