Configuration check failed Traceback (most recent ...
# ask-ai
a
Configuration check failed Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/airbyte_cdk/sources/file_based/availability_strategy/default_file_based_availability_strategy.py", line 121, in _check_parse_record record = next( ^^^^^ File "/usr/local/lib/python3.11/site-packages/airbyte_cdk/sources/file_based/file_types/csv_parser.py", line 246, in parse_records for row in data_generator: File "/usr/local/lib/python3.11/site-packages/airbyte_cdk/sources/file_based/file_types/csv_parser.py", line 68, in read_data with stream_reader.open_file(file, file_read_mode, config_format.encoding, logger) as fp: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/airbyte/integration_code/source_sftp_bulk/stream_reader.py", line 92, in open_file remote_file = self.sftp_client.sftp_connection.open(file.uri, mode=mode.value) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/paramiko/sftp_client.py", line 372, in open t, msg = self._request(CMD_OPEN, filename, imode, attrblock) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/paramiko/sftp_client.py", line 857, in _request return self._read_response(num) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/paramiko/sftp_client.py", line 909, in _read_response self._convert_status(msg) File "/usr/local/lib/python3.11/site-packages/paramiko/sftp_client.py", line 940, in _convert_status raise IOError(errno.EACCES, text) PermissionError: [Errno 13] Permission denied The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/airbyte_cdk/sources/file_based/availability_strategy/default_file_based_availability_strategy.py", line 81, in check_availability_and_parsability self._check_parse_record(stream, file, logger) File "/usr/local/lib/python3.11/site-packages/airbyte_cdk/sources/file_based/availability_strategy/default_file_based_availability_strategy.py", line 136, in _check_parse_record raise CheckAvailabilityError( airbyte_cdk.sources.file_based.exceptions.CheckAvailabilityError: Error opening file. Please check the credentials provided in the config and verify that they provide permission to read files. Contact Support if you need assistance. stream=Sheet1-ChartOfAccounts file=//swapfile
k
The error is coming from the SFTP Bulk source’s configuration check step, specifically when the connector tries to open a remote file via Paramiko and gets
PermissionError: [Errno 13] Permission denied
, which the CDK then wraps as: >
CheckAvailabilityError: Error opening file. Please check the credentials provided in the config and verify that they provide permission to read files. ... stream=Sheet1-ChartOfAccounts file=//swapfile
[[Azure Blob issue](https://github.com/airbytehq/airbyte/issues/52623)] This means: - The SFTP connection itself is established, but - The SFTP user does not have read permission on the specific file the connector is trying to open (
//swapfile
in this case). To resolve it, you’ll need to: 1. Confirm the configured path/pattern in the SFTP Bulk source: - Check the folder path and any filename patterns you configured, and make sure they do not match system files like
swapfile
that your user cannot read. - If you only want CSVs in a particular folder, narrow the folder path and/or pattern accordingly so that only allowed data files are picked up. 2. Fix permissions or move files on the SFTP server (if needed): - Either grant your SFTP user read access to the files you actually want to ingest, or - Move unreadable/system files (like swap files) outside the directory that Airbyte is scanning. 3. Re‑run the configuration check after: - Updating the SFTP Bulk source config, or - Adjusting server-side permissions/paths. If you share your current SFTP Bulk config (folder path, filename pattern, and authentication method), I can help you pinpoint exactly what to change.