Error: Comparison Method Violates Its General Contract

Issue

Syncs fail with the following error:

Comparison method violates its general contract!

Environment

All file connectors

Resolution

If you can manage the contents of your source folder, follow the steps below:

1. In Fivetran, go to your connection page.
2. Select the Setup tab.
3. Click Edit connection.
4. Check the value in the File Type field.
5. Go to your source folder and remove files that don't match the configured file type.

If you can't manage the contents of your source folder, configure Fivetran to include only the desired file types:

1. In Fivetran, go to your connection page.
2. Select the Setup tab.
3. Click Edit connection.
4. In the File Pattern field, enter a regex pattern that matches only the file extensions you want to sync.
   Ensure your regex pattern can detect the applicable files and names. You can use Rubular to test your regex.

5. Click Save & Test.

Cause

This error occurs when the source folder contains files that don't match the expected file type.