I tried to do a lookup through salesforce connector. It works fine with small number of records. However, it did not work when I tried to do a 500K records. I paste the error logs. I am wondering if SF connector is only good for small number of records.
[Function: Connector Call]: Error received executing Salesforce Get; Caused by: Error received executing Salesforce Get; Caused by: com.boomi.util.retry.RetryException: com.boomi.model.connector.common.salesforce.SalesforceException: Error executing query. Error message received from Webservice.