0

Salesforce data to Incorta

We are trying to run a scheduled job to incrementally pull data from Salesforce. The load fails with the following message whenever it tries to run from the scheduled job. Whenever I test the connection to the datasource and rerun the load manually or set the job to run, it works fine. However it does not retain the connection for long and the job fails. I am using salesforce v2 connector for the datasource.

 

com.incorta.api.exceptions.DataException: INC_03070000: Failed to load data from [Salesforce_SGSales_UAT] due to [com.sforce.ws.ConnectionException: Failed to parse detail:  START_TAG seen ...etail><sf:UnexpectedErrorFault xsi:type="sf:UnexpectedErrorFault">... @2:187 due to: com.sforce.ws.ConnectionException: Incompatible type 'class com.sforce.soap.partner.fault.UnexpectedErrorFault' specified as xsi:type. It must be a subclass of 'class com.sforce.ws.ConnectionException'] with properties [[incremental, true], [describeSObject, true]]
at com.incorta.loader.etl.ExtractionPhase.handleTableExtractionFailure(ExtractionPhase.java:397)
at com.incorta.loader.etl.ExtractionPhase.extractTable(ExtractionPhase.java:345)
at com.incorta.loader.etl.ExtractionPhase$1.doAction(ExtractionPhase.java:159)
at com.incorta.util.ConcurrentService$3.call(ConcurrentService.java:183)
at com.incorta.util.ConcurrentService$3.call(ConcurrentService.java:168)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at com.incorta.util.ConcurrentService$4.run(ConcurrentService.java:201)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.incorta.connector.errors.DataExtractionException: Error while extracting data from [Salesforce_SGSales_UAT] due to: com.sforce.ws.ConnectionException: Failed to parse detail:  START_TAG seen ...etail><sf:UnexpectedErrorFault xsi:type="sf:UnexpectedErrorFault">... @2:187 due to: com.sforce.ws.ConnectionException: Incompatible type 'class com.sforce.soap.partner.fault.UnexpectedErrorFault' specified as xsi:type. It must be a subclass of 'class com.sforce.ws.ConnectionException'
at com.incorta.connector.salesforce.SalesForceDataSet.queryRecordsAPI(SalesForceDataSet.java:164)
at com.incorta.connector.salesforce.SalesForceDataSet.queryRecords(SalesForceDataSet.java:118)
at com.incorta.connector.salesforce.SalesForceDataSet.queryUpdates(SalesForceDataSet.java:91)
at com.incorta.connector.common.AbstractDataSet.queryDataUpdates(AbstractDataSet.java:21)
at com.incorta.loader.etl.IncortaExtractor.extract(IncortaExtractor.java:75)
at com.incorta.loader.etl.ExtractionPhase.extractDataSet(ExtractionPhase.java:449)
at com.incorta.loader.etl.ExtractionPhase.extractDataSetWithCallback(ExtractionPhase.java:507)
at com.incorta.loader.etl.ExtractionPhase.extractTable(ExtractionPhase.java:237)
... 8 more
Caused by: com.sforce.ws.ConnectionException: com.sforce.ws.ConnectionException: Failed to parse detail:  START_TAG seen ...etail><sf:UnexpectedErrorFault xsi:type="sf:UnexpectedErrorFault">... @2:187 due to: com.sforce.ws.ConnectionException: Incompatible type 'class com.sforce.soap.partner.fault.UnexpectedErrorFault' specified as xsi:type. It must be a subclass of 'class com.sforce.ws.ConnectionException'
at com.incorta.connector.salesforce.ConnectionsManager.handleConnectionException(ConnectionsManager.java:719)
at com.incorta.connector.salesforce.ConnectionsManager.discoverTable(ConnectionsManager.java:271)
at com.incorta.connector.salesforce.SalesForceDataSet.queryRecordsAPI(SalesForceDataSet.java:131)
... 15 more
1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Sathya Natarajan please open a ticket with Support. This sounds like a known issue with your version of Incorta and Support will assist with implementing the fix.

    Like
Like Follow
  • 1 mth agoLast active
  • 1Replies
  • 14Views
  • 2 Following

Product Announcement

Incorta 5 is now Generally Available