[teiid-issues] [JBoss JIRA] Commented: (TEIID-1302) Selecting data from salesforce results in a IndexOutOfBoundsException

[Steven Hawkins (JIRA)]

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

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