[JBoss JIRA] Created: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException
8:22 p.m.
Selecting data from salesforce results in a IndexOutOfBoundsException
---------------------------------------------------------------------
Key: TEIID-1302
URL: https://jira.jboss.org/browse/TEIID-1302
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1
Environment: Fedora 12, x86_64, java 6u21
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1
After importing of the salesforce data structure via designer, connection with an EAP 5.1
runtime with Teiid7.1 installed, I get an IndexOutOfBoundsException when I am trying to do
simple SELECTing of salesforce data:
SELECT *
from sfdc.salesforce.Opportunity o
WHERE (1 = 1)
and (o.Fiscal = '2011 2')
and (o.Country_of_Order__c = 'Germany')
Exception:
2010-10-12 20:10:32,376 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue21)
Unexpected exception for request cy2xWqMIKJHq.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
The connector only works if I am selecting data of an Account:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and Name like 'Bit%'
and BillingCountry = 'Germany';
(97 results)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:24 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException
[
https://jira.jboss.org/browse/TEIID-1302?page=com.atlassian.jira.plugin.s...
]
Wanja Pernath commented on TEIID-1302:
--------------------------------------
BTW, I am using Salesforce API Version 10. The URL is:
https://na4.salesforce.com/services/Soap/u/10.0
Selecting data from salesforce results in a
IndexOutOfBoundsException
---------------------------------------------------------------------
Key: TEIID-1302
URL: https://jira.jboss.org/browse/TEIID-1302
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1
Environment: Fedora 12, x86_64, java 6u21
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1
After importing of the salesforce data structure via designer, connection with an EAP 5.1
runtime with Teiid7.1 installed, I get an IndexOutOfBoundsException when I am trying to do
simple SELECTing of salesforce data:
SELECT *
from sfdc.salesforce.Opportunity o
WHERE (1 = 1)
and (o.Fiscal = '2011 2')
and (o.Country_of_Order__c = 'Germany')
Exception:
2010-10-12 20:10:32,376 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue21)
Unexpected exception for request cy2xWqMIKJHq.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
The connector only works if I am selecting data of an Account:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and Name like 'Bit%'
and BillingCountry = 'Germany';
(97 results)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:53 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException
[
https://jira.jboss.org/browse/TEIID-1302?page=com.atlassian.jira.plugin.s...
]
Ramesh Reddy commented on TEIID-1302:
-------------------------------------
Teiid classes are compiled for version 17, can you try with that version and see if you
still have a issue?
Selecting data from salesforce results in a
IndexOutOfBoundsException
---------------------------------------------------------------------
Key: TEIID-1302
URL: https://jira.jboss.org/browse/TEIID-1302
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1
Environment: Fedora 12, x86_64, java 6u21
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1
After importing of the salesforce data structure via designer, connection with an EAP 5.1
runtime with Teiid7.1 installed, I get an IndexOutOfBoundsException when I am trying to do
simple SELECTing of salesforce data:
SELECT *
from sfdc.salesforce.Opportunity o
WHERE (1 = 1)
and (o.Fiscal = '2011 2')
and (o.Country_of_Order__c = 'Germany')
Exception:
2010-10-12 20:10:32,376 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue21)
Unexpected exception for request cy2xWqMIKJHq.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
The connector only works if I am selecting data of an Account:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and Name like 'Bit%'
and BillingCountry = 'Germany';
(97 results)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:59 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException
[
https://jira.jboss.org/browse/TEIID-1302?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins commented on TEIID-1302:
---------------------------------------
It's unclear from the docs whether the queryresult size is for the entire result set
or for just the batch that the queryresult represents. It seems safer in any case to use
the size of the records list for iterating rather than the size property.
Selecting data from salesforce results in a
IndexOutOfBoundsException
---------------------------------------------------------------------
Key: TEIID-1302
URL: https://jira.jboss.org/browse/TEIID-1302
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1
Environment: Fedora 12, x86_64, java 6u21
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1
After importing of the salesforce data structure via designer, connection with an EAP 5.1
runtime with Teiid7.1 installed, I get an IndexOutOfBoundsException when I am trying to do
simple SELECTing of salesforce data:
SELECT *
from sfdc.salesforce.Opportunity o
WHERE (1 = 1)
and (o.Fiscal = '2011 2')
and (o.Country_of_Order__c = 'Germany')
Exception:
2010-10-12 20:10:32,376 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue21)
Unexpected exception for request cy2xWqMIKJHq.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
The connector only works if I am selecting data of an Account:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and Name like 'Bit%'
and BillingCountry = 'Germany';
(97 results)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:17 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException
[
https://jira.jboss.org/browse/TEIID-1302?page=com.atlassian.jira.plugin.s...
]
Wanja Pernath commented on TEIID-1302:
--------------------------------------
I can reproduce the error also with another SELECT:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and BillingCountry = 'Germany';
With this one I get the following exception:
17:14:03,231 ERROR [PROCESSOR] Unexpected exception for request 5yPuXOebToHl.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
But if I add more WHERE conditions (to get a smaller result size) there is no problem.
So I would guess, it belongs to the batch processing.
Thanks for your help.
Cheers,
Wanja
Selecting data from salesforce results in a
IndexOutOfBoundsException
---------------------------------------------------------------------
Key: TEIID-1302
URL: https://jira.jboss.org/browse/TEIID-1302
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1
Environment: Fedora 12, x86_64, java 6u21
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1
After importing of the salesforce data structure via designer, connection with an EAP 5.1
runtime with Teiid7.1 installed, I get an IndexOutOfBoundsException when I am trying to do
simple SELECTing of salesforce data:
SELECT *
from sfdc.salesforce.Opportunity o
WHERE (1 = 1)
and (o.Fiscal = '2011 2')
and (o.Country_of_Order__c = 'Germany')
Exception:
2010-10-12 20:10:32,376 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue21)
Unexpected exception for request cy2xWqMIKJHq.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
The connector only works if I am selecting data of an Account:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and Name like 'Bit%'
and BillingCountry = 'Germany';
(97 results)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:20 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException
[
https://jira.jboss.org/browse/TEIID-1302?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins resolved TEIID-1302.
-----------------------------------
Resolution: Done
The fix was tested and allowed larger results to be fetched through an older salesforce
version.
Selecting data from salesforce results in a
IndexOutOfBoundsException
---------------------------------------------------------------------
Key: TEIID-1302
URL: https://jira.jboss.org/browse/TEIID-1302
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1
Environment: Fedora 12, x86_64, java 6u21
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1
After importing of the salesforce data structure via designer, connection with an EAP 5.1
runtime with Teiid7.1 installed, I get an IndexOutOfBoundsException when I am trying to do
simple SELECTing of salesforce data:
SELECT *
from sfdc.salesforce.Opportunity o
WHERE (1 = 1)
and (o.Fiscal = '2011 2')
and (o.Country_of_Order__c = 'Germany')
Exception:
2010-10-12 20:10:32,376 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue21)
Unexpected exception for request cy2xWqMIKJHq.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
The connector only works if I am selecting data of an Account:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and Name like 'Bit%'
and BillingCountry = 'Germany';
(97 results)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:37 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException
[
https://jira.jboss.org/browse/TEIID-1302?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins commented on TEIID-1302:
---------------------------------------
There was an additional issue. QueryExecutionImpl was not resetting its index for each
batch, which would lead to either additional Index out of bounds or result truncation.
Selecting data from salesforce results in a
IndexOutOfBoundsException
---------------------------------------------------------------------
Key: TEIID-1302
URL: https://jira.jboss.org/browse/TEIID-1302
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1
Environment: Fedora 12, x86_64, java 6u21
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1
After importing of the salesforce data structure via designer, connection with an EAP 5.1
runtime with Teiid7.1 installed, I get an IndexOutOfBoundsException when I am trying to do
simple SELECTing of salesforce data:
SELECT *
from sfdc.salesforce.Opportunity o
WHERE (1 = 1)
and (o.Fiscal = '2011 2')
and (o.Country_of_Order__c = 'Germany')
Exception:
2010-10-12 20:10:32,376 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue21)
Unexpected exception for request cy2xWqMIKJHq.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
The connector only works if I am selecting data of an Account:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and Name like 'Bit%'
and BillingCountry = 'Germany';
(97 results)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:32 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException
[
https://issues.jboss.org/browse/TEIID-1302?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1302.
---------------------------------
Selecting data from salesforce results in a
IndexOutOfBoundsException
---------------------------------------------------------------------
Key: TEIID-1302
URL: https://issues.jboss.org/browse/TEIID-1302
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1
Environment: Fedora 12, x86_64, java 6u21
Reporter: Wanja Pernath
Assignee: Steven Hawkins
Fix For: 7.1.1
After importing of the salesforce data structure via designer, connection with an EAP 5.1
runtime with Teiid7.1 installed, I get an IndexOutOfBoundsException when I am trying to do
simple SELECTing of salesforce data:
SELECT *
from sfdc.salesforce.Opportunity o
WHERE (1 = 1)
and (o.Fiscal = '2011 2')
and (o.Country_of_Order__c = 'Germany')
Exception:
2010-10-12 20:10:32,376 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue21)
Unexpected exception for request cy2xWqMIKJHq.0
java.lang.IndexOutOfBoundsException: Index: 200, Size: 200
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:190)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:165)
at
org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:157)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:285)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:270)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:181)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:53)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:89)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:86)
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
The connector only works if I am selecting data of an Account:
SELECT *
from sfdc.salesforce.Account
WHERE (1 = 1)
and Name like 'Bit%'
and BillingCountry = 'Germany';
(97 results)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4922
days inactive
5012
days old
7 comments
3 participants
participants (3)
-
Ramesh Reddy (JIRA) -
Steven Hawkins (JIRA)
-
Wanja Pernath (JIRA)