2:01 p.m.
Teiid should take care of salesforce query limits by itself
-----------------------------------------------------------
Key: TEIID-1412
URL: https://issues.jboss.org/browse/TEIID-1412
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Affects Versions: 7.2, 7.1.1, 7.3
Environment: Teiid 7.1.1 on EAP 5.1 with CXF
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Salesforce has a query string limit of 10.000 chars. When Teiid is calculating and
executing a query like this:
SELECT Opportunity where AccountId in (a,b,c,d,e,f,g,h,i)
It could extend the 10.000 chars limit of Salesforce. Right now teiid just stops with an
Exception.
Expected behavior is to have teiid splitting up the condition into correct portions and to
execute the above query n times to circumvent the limit:
SELECT Opportunity where AccountId in (a, b, c);
SELECT Opportunity where AccountId in (d, e, f);
SELECT Opportunity where AccountId in (g, h, i);
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:52 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1412) Teiid should take care of salesforce query limits by itself
[
https://issues.jboss.org/browse/TEIID-1412?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1412:
---------------------------------------
Teiid has a max IN criteria size of 700 set for the salesforce translator. This issue
could be treated as an enhancement to the engine to perform the splitting you're
looking for based upon that value. The logic is a better fit in the engine in any case
since it already has facilities for this logic based upon dependent joins - however it
will not be directly related to the exact length of the salesforce query.
Teiid should take care of salesforce query limits by itself
-----------------------------------------------------------
Key: TEIID-1412
URL: https://issues.jboss.org/browse/TEIID-1412
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Affects Versions: 7.1.1, 7.2, 7.3
Environment: Teiid 7.1.1 on EAP 5.1 with CXF
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Salesforce has a query string limit of 10.000 chars. When Teiid is calculating and
executing a query like this:
SELECT Opportunity where AccountId in (a,b,c,d,e,f,g,h,i)
It could extend the 10.000 chars limit of Salesforce. Right now teiid just stops with an
Exception.
Expected behavior is to have teiid splitting up the condition into correct portions and
to execute the above query n times to circumvent the limit:
SELECT Opportunity where AccountId in (a, b, c);
SELECT Opportunity where AccountId in (d, e, f);
SELECT Opportunity where AccountId in (g, h, i);
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:53 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1412) Teiid should take care of salesforce query limits by itself
[
https://issues.jboss.org/browse/TEIID-1412?page=com.atlassian.jira.plugin...
]
Wanja Pernath commented on TEIID-1412:
--------------------------------------
Well, especially if IN contains a list of PK numbers which are 18 chars in SFDC, it would
make sense to further limit the IN criteria size:
700 times 18 chars = 12.600 chars plus 700 * 3 chars (each ID is set in apostrophes plus a
comma) which sums up to approx. 14.700 chars.
And this is just for the IN criteria list. You would then like to include the SELECT
statement and all the other conditions.
When I've played with old MetaMatrix, I set the IN criteria limit to something between
250 and 300. I think Oracle has (had?) an IN limit of 256 elements. - I don't think a
typical handwritten query would ever exceed this limit. However, calculated statements
(for dependent joins for example) could easily extend this limit.
Where can I configure this constant?
Thanks a lot + best,
Wanja
Teiid should take care of salesforce query limits by itself
-----------------------------------------------------------
Key: TEIID-1412
URL: https://issues.jboss.org/browse/TEIID-1412
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Affects Versions: 7.1.1, 7.2, 7.3
Environment: Teiid 7.1.1 on EAP 5.1 with CXF
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Salesforce has a query string limit of 10.000 chars. When Teiid is calculating and
executing a query like this:
SELECT Opportunity where AccountId in (a,b,c,d,e,f,g,h,i)
It could extend the 10.000 chars limit of Salesforce. Right now teiid just stops with an
Exception.
Expected behavior is to have teiid splitting up the condition into correct portions and
to execute the above query n times to circumvent the limit:
SELECT Opportunity where AccountId in (a, b, c);
SELECT Opportunity where AccountId in (d, e, f);
SELECT Opportunity where AccountId in (g, h, i);
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:11 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1412) Teiid should take care of salesforce query limits by itself
[
https://issues.jboss.org/browse/TEIID-1412?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1412:
---------------------------------------
So your issue is actually with dependent joins then? In that case the logic is working as
expected, but the 700 value is too large.
Right now setting the max IN would require creating a subclass of
SaleForceExecutionFactory and overriding the getMaxInCriteriaSize method. It seems like
we could reduce the default, make the max a configurable translator property, or both to
avoid this issue.
Teiid should take care of salesforce query limits by itself
-----------------------------------------------------------
Key: TEIID-1412
URL: https://issues.jboss.org/browse/TEIID-1412
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Affects Versions: 7.1.1, 7.2, 7.3
Environment: Teiid 7.1.1 on EAP 5.1 with CXF
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Salesforce has a query string limit of 10.000 chars. When Teiid is calculating and
executing a query like this:
SELECT Opportunity where AccountId in (a,b,c,d,e,f,g,h,i)
It could extend the 10.000 chars limit of Salesforce. Right now teiid just stops with an
Exception.
Expected behavior is to have teiid splitting up the condition into correct portions and
to execute the above query n times to circumvent the limit:
SELECT Opportunity where AccountId in (a, b, c);
SELECT Opportunity where AccountId in (d, e, f);
SELECT Opportunity where AccountId in (g, h, i);
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:17 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1412) Teiid should take care of salesforce query limits by itself
[
https://issues.jboss.org/browse/TEIID-1412?page=com.atlassian.jira.plugin...
]
Wanja Pernath commented on TEIID-1412:
--------------------------------------
Sounds good. Thanks a lot!
Cheers,
Wanja
Teiid should take care of salesforce query limits by itself
-----------------------------------------------------------
Key: TEIID-1412
URL: https://issues.jboss.org/browse/TEIID-1412
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Affects Versions: 7.1.1, 7.2, 7.3
Environment: Teiid 7.1.1 on EAP 5.1 with CXF
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Salesforce has a query string limit of 10.000 chars. When Teiid is calculating and
executing a query like this:
SELECT Opportunity where AccountId in (a,b,c,d,e,f,g,h,i)
It could extend the 10.000 chars limit of Salesforce. Right now teiid just stops with an
Exception.
Expected behavior is to have teiid splitting up the condition into correct portions and
to execute the above query n times to circumvent the limit:
SELECT Opportunity where AccountId in (a, b, c);
SELECT Opportunity where AccountId in (d, e, f);
SELECT Opportunity where AccountId in (g, h, i);
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:52 a.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1412) Teiid should take care of salesforce query limits by itself
[
https://issues.jboss.org/browse/TEIID-1412?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1412.
-----------------------------------
Fix Version/s: 7.1.1
7.3
Resolution: Done
reducing the max in size to a safer value - 300. it's also changed into a translator
property in case it needs further adjustment
Teiid should take care of salesforce query limits by itself
-----------------------------------------------------------
Key: TEIID-1412
URL: https://issues.jboss.org/browse/TEIID-1412
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Affects Versions: 7.1.1, 7.2, 7.3
Environment: Teiid 7.1.1 on EAP 5.1 with CXF
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1, 7.3
Salesforce has a query string limit of 10.000 chars. When Teiid is calculating and
executing a query like this:
SELECT Opportunity where AccountId in (a,b,c,d,e,f,g,h,i)
It could extend the 10.000 chars limit of Salesforce. Right now teiid just stops with an
Exception.
Expected behavior is to have teiid splitting up the condition into correct portions and
to execute the above query n times to circumvent the limit:
SELECT Opportunity where AccountId in (a, b, c);
SELECT Opportunity where AccountId in (d, e, f);
SELECT Opportunity where AccountId in (g, h, i);
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:19 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1412) Teiid should take care of salesforce query limits by itself
[
https://issues.jboss.org/browse/TEIID-1412?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1412.
---------------------------------
Teiid should take care of salesforce query limits by itself
-----------------------------------------------------------
Key: TEIID-1412
URL: https://issues.jboss.org/browse/TEIID-1412
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Affects Versions: 7.1.1, 7.2, 7.3
Environment: Teiid 7.1.1 on EAP 5.1 with CXF
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1, 7.3
Salesforce has a query string limit of 10.000 chars. When Teiid is calculating and
executing a query like this:
SELECT Opportunity where AccountId in (a,b,c,d,e,f,g,h,i)
It could extend the 10.000 chars limit of Salesforce. Right now teiid just stops with an
Exception.
Expected behavior is to have teiid splitting up the condition into correct portions and
to execute the above query n times to circumvent the limit:
SELECT Opportunity where AccountId in (a, b, c);
SELECT Opportunity where AccountId in (d, e, f);
SELECT Opportunity where AccountId in (g, h, i);
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4925
days inactive
5021
days old
6 comments
2 participants
participants (2)
-
Steven Hawkins (JIRA) -
Wanja Pernath (JIRA)