Error: Cannot Have More Than 5 Exports Queued

Issue

Connections fail to sync the CUSTOMER table. The following error appears:

Cannot have more than 5 exports queued

Environment

Connector: Customer.io

Resolution

To resolve this issue:

1. Send a GET request to https://api.customer.io/v1/exports using the Customer.io credentials configured for the connection.
2. Identify export jobs with "status": "pending".
3. If five exports have remained in pending status for an extended period, make a note of their export IDs, types, and creation timestamps.
4. Contact Customer.io Support and ask them to investigate and clear the pending export jobs.
5. After Customer.io confirms the jobs have been cleared, query the Exports endpoint again and verify that they're no longer pending.
6. In Fivetran, go to your Customer.io connection page.
7. In the top right, click Sync.
8. Confirm that the sync completes successfully.

Cause

Customer.io allows a maximum of five queued export jobs. This issue occurs when five jobs remain pending, occupying all available export slots. When this happens, we can't create the next export required for the sync, resulting in the above error.