•Eloqua recommends a record limit of 2000 records, when you perform "Read/Fetch" operation using "Insert" task operation.
•When you want fetch records in bulk, it is recommended to use Eloqua bulk data transfer service.
•Few DSS tasks might result in "Connection Reset" or "Java.net.SocketTimeoutException" error, large number of records in the result set or large page size causes the Eloqua web service to reset its connection with the Eloqua connector.
•Add appropriate filters to the task to overcome "Connection Reset" or "Java.net.SocketTimeoutException" error.
•Perform appropriate field mapping to limit the number of fields being fetched from Eloqua to overcome "Connection Reset" or "Java.net.SocketTimeoutException" error.