Full message: ECE_SSLError: We got an error from the SSL module: Timeout on SSL readData - the server took too long to respond.
The source system accepted the connection but did not return data within the allowed SSL read timeout window. The integration timed out while waiting for a response.
1. No source control field (timestamp field) configured : The transfer has no timestamp field meant to read only what has been created and/or updated since the last run. instead it queries the full dataset every time it runs. A full dataset query on large tables will eventually exceed the timeout threshold.
2. Large dataset queried without filters : No filter conditions are applied to the source query, causing the system to attempt a full table scan. On large datasets, this takes too long and the connection times out before data is returned.
3. Non-indexed filter fields : Filters are in place, but the fields used are not indexed on the source system. Without an index, the database performs a full scan anyway, making filters ineffective for performance and the query times out on large volumes.
4. Source system under load : The source server is busy (e.g. during business hours, batch jobs, or backups running in parallel). Even a well-scoped query can time out if the server has insufficient resources at that moment. Intermittent occurrences of this error are a clue.
Comment Editor X