Export Failed

Export failures are usually caused by permission issues, destination configuration problems, or resource constraints during large exports. The Job Status Dialog will show the specific error message — use that as your first reference point.

Database Export Failures

Insufficient Permissions

The database user configured for export must have the appropriate permissions for the export mode you have chosen:

• Insert only: Requires INSERT permission on the target table.
• Truncate and reload: Requires INSERT and TRUNCATE permissions.
• Drop and recreate: Requires INSERT, DROP TABLE, and CREATE TABLE permissions.

Fix: Grant the export user the permissions matching your chosen export mode, or switch to a mode that requires fewer permissions.

Table Already Exists Without Truncate

If you are inserting into a table that already contains data and the mode is set to "Insert Only," duplicate key violations may cause the export to fail if the table has unique constraints.

Fix: Switch the export mode to Truncate and Reload to clear existing data before writing, or to Drop and Recreate to fully rebuild the table.

Schema Mismatch

If the target table already exists with a different column structure than what MatchLogic expects to write, column mismatch errors will occur.

Fix: Use Drop and Recreate mode to automatically rebuild the table with the correct schema. Alternatively, manually alter the existing table to match the expected output columns.

Command Timeout

Very large exports may exceed the database command timeout, causing the export to fail part way through.

Fix: Increase the command timeout value in the export settings. For extremely large datasets, consider exporting to a file format (CSV or Excel) first and then bulk-loading into the database using native database tools.

File Export Failures

Output Path Not Writable

If exporting to a local or network file path, the MatchLogic server process must have write permissions to that directory.

Fix: Verify the output directory exists and that the server's service account has write access. Create the directory in advance if it does not exist.

Cloud Storage Permission Denied

• Google Drive / Dropbox / OneDrive: Re-authenticate the OAuth connection. The access token may have expired.
• S3: Verify the IAM user has s3:PutObject permission on the target bucket and prefix.
• FTP/SFTP: Confirm the user has write access to the specified remote directory.

Excel Row Limit

Excel files are limited to approximately 1,048,576 rows. If your export contains more rows than this, the export to Excel format will fail or truncate silently.

Fix: Export to CSV for datasets exceeding one million rows. CSV has no row limit.