Problem Description


Salesforce ingestion job fails with the below error.


[INFO] 2019-07-19 07:51:09,699 [pool-5-thread-1] infoworks.discovery.filecrawler.salesforce.SalesForceBulkConnector:147 :: Constants for SalesForce bulk api copy of table : Contact are -> chunkSize = 250000, number of Retries = 100, sleepTime = 30000, processing Threads = 1

[ERROR] 2019-07-19 07:51:09,757 [main] infoworks.discovery.filecrawler.generic.Crawler:432 :: Table Contact failed [AsyncApiException exceptionCode='InvalidUrl'

exceptionMessage='Destination URL not reset. The URL returned from login must be set'

]

Stacktrace: java.util.concurrent.ExecutionException: [AsyncApiException exceptionCode='InvalidUrl'

exceptionMessage='Destination URL not reset. The URL returned from login must be set'

]

 

Root cause


This issue occurs if connection URL is provided a test.salesforce.com (if it is Sandbox environment) or login.salesforce.com(if it is production). The connection URL for the source should be the Salesforce instance url.


Solution


a) Login to the Environment, in this case it is sandbox using the url https://test.salesforce.com/

b) Go to the top right corner>click on View Profile>and under the user name, you would get the instance URL. In my case it is cs93.salesforce.com.




c) Provide your instance url> Save settings>Test Connection.
d) Run the ingestion job.

This should resolve the issue.


IWX DataFoundry versions: 2.7.x