[teiid-issues] [JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

[sameer P (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13312938#comment-13312938 ] 

sameer P commented on TEIID-4284:
---------------------------------

Hi [~shawkins], As I tested it on my salesforce Account. looks like there is some critical problem when there are many batches (more than 4) which get created when the number of rows in the table are huge (pretty large than the Maximum Chunk Size or something).  

When I do a simple select * from such a table multiple times in a row (sometimes even on first query), I get the following error : 
{code:java}
Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 TEIID30020 Processing exception for request IR8UKFQnuXi4.17 'TEIID30504 dssSOU: null'. Originally TeiidProcessingException SalesforceConnectionImpl.java:570.
SQLState:  TEIID30504
ErrorCode: 0
{code}

> Implement Salesforce Bulk API for SELECTS to Salesforce Connector
> -----------------------------------------------------------------
>
>                 Key: TEIID-4284
>                 URL: https://issues.jboss.org/browse/TEIID-4284
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Salesforce Connector
>    Affects Versions: 8.13.5
>         Environment: With Salesforce datasource
>            Reporter: sameer P
>            Assignee: Steven Hawkins
>             Fix For: 9.2
>
>
> There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT.  
> The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_code_curl_walkthrough_pk_chunking.htm . 



--
This message was sent by Atlassian JIRA
(v7.2.2#72004)