[
https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin...
]
sameer P edited comment on TEIID-4284 at 10/27/16 8:11 AM:
-----------------------------------------------------------
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}
I got it when I had to query the table multiple times. I hope you will be able to
reproduce this issue :)
was (Author: sameerp):
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_asy...
.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)