[teiid-issues] [JBoss JIRA] Reopened: (TEIID-1402) SELECTing data from salesforce with a WHERE condition which includes ID results in a NPE

[ https://issues.jboss.org/browse/TEIID-1402?page=com.atlassian.jira.plugin... ] Wanja Pernath reopened TEIID-1402: ---------------------------------- I've used current 7.1.x branch sources to test the fix. Unfortunately, I am now getting the following exception when trying to scan an entity by ID: 2010-12-21 22:29:04,989 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue9) cNxqZ61arIWD.0.1.2 Create State 2010-12-21 22:29:04,990 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) cNxqZ61arIWD.0.1.2 Processing NEW request: SELECT gss.salesforce.Account.Id, gss.salesforce.Account.Name FROM gss.salesforce.Account WHERE gss.salesforce.Account.Id = '001A000000K65hEIAR' 2010-12-21 22:29:04,991 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) cNxqZ61arIWD.0.1.2 Obtained execution 2010-12-21 22:29:04,991 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) gss.cNxqZ61arIWD.cNxqZ61arIWD.0.1: Incoming Query: SELECT Account.Id, Account.Name FROM Account WHERE Account.Id = '001A000000K65hEIAR' 2010-12-21 22:29:04,993 ERROR [org.jboss.remoting.transport.http.HTTPClientInvoker] (Worker4_QueryProcessorQueue10) Error creating SSL Socket Factory for client invoker: Error initializing socket factory SSL context: Can not find truststore url. 22:29:04,993 ERROR [HTTPClientInvoker] Error creating SSL Socket Factory for client invoker: Error initializing socket factory SSL context: Can not find truststore url. 2010-12-21 22:29:05,995 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) cNxqZ61arIWD.0.1.2 Executed command 2010-12-21 22:29:05,996 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) cNxqZ61arIWD.0.1.2 Sending results from connector 2010-12-21 22:29:05,996 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) SalesForce Object Name = Account 2010-12-21 22:29:05,996 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) FieldCount = 1 2010-12-21 22:29:05,996 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) Field # 0 is Name 2010-12-21 22:29:05,999 ERROR [org.jboss.remoting.transport.http.HTTPClientInvoker] (Worker4_QueryProcessorQueue10) Error creating SSL Socket Factory for client invoker: Error initializing socket factory SSL context: Can not find truststore url. 22:29:05,999 ERROR [HTTPClientInvoker] Error creating SSL Socket Factory for client invoker: Error initializing socket factory SSL context: Can not find truststore url. 2010-12-21 22:29:06,205 ERROR [org.jboss.ws.core.CommonClient] (Worker4_QueryProcessorQueue10) Exception caught while (preparing for) performing the invocation: javax.xml.ws.soap.SOAPFaultException: INVALID_QUERY_LOCATOR: invalid query locator at org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS.getSOAPFaultException(SOAPFaultHelperJAXWS.java:85) at org.jboss.ws.core.jaxws.binding.SOAP11BindingJAXWS.throwFaultException(SOAP11BindingJAXWS.java:107) at org.jboss.ws.core.CommonSOAPBinding.unbindResponseMessage(CommonSOAPBinding.java:558) at org.jboss.ws.core.CommonClient.invoke(CommonClient.java:396) at org.jboss.ws.core.jaxws.client.ClientImpl.invoke(ClientImpl.java:231) at org.jboss.ws.core.jaxws.client.ClientProxy.invoke(ClientProxy.java:171) at org.jboss.ws.core.jaxws.client.ClientProxy.invoke(ClientProxy.java:157) at $Proxy157.queryMore(Unknown Source) at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.queryMore(SalesforceConnectionImpl.java:193) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:194) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:183) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:166) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108) 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) 22:29:06,205 ERROR [CommonClient] Exception caught while (preparing for) performing the invocation: javax.xml.ws.soap.SOAPFaultException: INVALID_QUERY_LOCATOR: invalid query locator at org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS.getSOAPFaultException(SOAPFaultHelperJAXWS.java:85) at org.jboss.ws.core.jaxws.binding.SOAP11BindingJAXWS.throwFaultException(SOAP11BindingJAXWS.java:107) at org.jboss.ws.core.CommonSOAPBinding.unbindResponseMessage(CommonSOAPBinding.java:558) at org.jboss.ws.core.CommonClient.invoke(CommonClient.java:396) at org.jboss.ws.core.jaxws.client.ClientImpl.invoke(ClientImpl.java:231) at org.jboss.ws.core.jaxws.client.ClientProxy.invoke(ClientProxy.java:171) at org.jboss.ws.core.jaxws.client.ClientProxy.invoke(ClientProxy.java:157) at $Proxy157.queryMore(Unknown Source) at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.queryMore(SalesforceConnectionImpl.java:193) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:194) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:183) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:166) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108) 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) Caused by: com.sforce.soap.partner.InvalidQueryLocatorFault: INVALID_QUERY_LOCATOR: invalid query locator at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.jboss.ws.metadata.umdm.FaultMetaData.toServiceException(FaultMetaData.java:383) at org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS.getSOAPFaultException(SOAPFaultHelperJAXWS.java:144) ... 24 more at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: com.sforce.soap.partner.InvalidQueryLocatorFault: INVALID_QUERY_LOCATOR: invalid query locator at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.jboss.ws.metadata.umdm.FaultMetaData.toServiceException(FaultMetaData.java:383) at org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS.getSOAPFaultException(SOAPFaultHelperJAXWS.java:144) ... 24 more 2010-12-21 22:29:06,207 WARN [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue10) Connector worker process failed for atomic-request=cNxqZ61arIWD.0.1.2 [TranslatorException]INVALID_QUERY_LOCATOR: invalid query locator 1 [ResourceException]INVALID_QUERY_LOCATOR: invalid query locator 2 [InvalidQueryLocatorFault]INVALID_QUERY_LOCATOR: invalid query locator at org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:205) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:183) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:166) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108) 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) Caused by: javax.resource.ResourceException: INVALID_QUERY_LOCATOR: invalid query locator at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.queryMore(SalesforceConnectionImpl.java:199) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:194) ... 15 more Caused by: com.sforce.soap.partner.InvalidQueryLocatorFault: INVALID_QUERY_LOCATOR: invalid query locator at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.jboss.ws.metadata.umdm.FaultMetaData.toServiceException(FaultMetaData.java:383) at org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS.getSOAPFaultException(SOAPFaultHelperJAXWS.java:144) at org.jboss.ws.core.jaxws.binding.SOAP11BindingJAXWS.throwFaultException(SOAP11BindingJAXWS.java:107) at org.jboss.ws.core.CommonSOAPBinding.unbindResponseMessage(CommonSOAPBinding.java:558) at org.jboss.ws.core.CommonClient.invoke(CommonClient.java:396) at org.jboss.ws.core.jaxws.client.ClientImpl.invoke(ClientImpl.java:231) at org.jboss.ws.core.jaxws.client.ClientProxy.invoke(ClientProxy.java:171) at org.jboss.ws.core.jaxws.client.ClientProxy.invoke(ClientProxy.java:157) at $Proxy157.queryMore(Unknown Source) at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.queryMore(SalesforceConnectionImpl.java:193) ... 16 more 22:29:06,207 WARN [CONNECTOR] Connector worker process failed for atomic-request=cNxqZ61arIWD.0.1.2 [TranslatorException]INVALID_QUERY_LOCATOR: invalid query locator 1 [ResourceException]INVALID_QUERY_LOCATOR: invalid query locator 2 [InvalidQueryLocatorFault]INVALID_QUERY_LOCATOR: invalid query locator at org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:205) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:183) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:166) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108) 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) Caused by: javax.resource.ResourceException: INVALID_QUERY_LOCATOR: invalid query locator at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.queryMore(SalesforceConnectionImpl.java:199) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:194) ... 15 more Caused by: com.sforce.soap.partner.InvalidQueryLocatorFault: INVALID_QUERY_LOCATOR: invalid query locator at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.jboss.ws.metadata.umdm.FaultMetaData.toServiceException(FaultMetaData.java:383) at org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS.getSOAPFaultException(SOAPFaultHelperJAXWS.java:144) at org.jboss.ws.core.jaxws.binding.SOAP11BindingJAXWS.throwFaultException(SOAP11BindingJAXWS.java:107) at org.jboss.ws.core.CommonSOAPBinding.unbindResponseMessage(CommonSOAPBinding.java:558) at org.jboss.ws.core.CommonClient.invoke(CommonClient.java:396) at org.jboss.ws.core.jaxws.client.ClientImpl.invoke(ClientImpl.java:231) at org.jboss.ws.core.jaxws.client.ClientProxy.invoke(ClientProxy.java:171) at org.jboss.ws.core.jaxws.client.ClientProxy.invoke(ClientProxy.java:157) at $Proxy157.queryMore(Unknown Source) at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.queryMore(SalesforceConnectionImpl.java:193) ... 16 more 2010-12-21 22:29:06,210 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue12) cNxqZ61arIWD.0.1.2 Processing Close : SELECT gss.salesforce.Account.Id, gss.salesforce.Account.Name FROM gss.salesforce.Account WHERE gss.salesforce.Account.Id = '001A000000K65hEIAR' 2010-12-21 22:29:06,211 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue12) SynchQueryExecution.close() called 2010-12-21 22:29:06,210 WARN [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue11) Processing exception 'INVALID_QUERY_LOCATOR: invalid query locator' for request cNxqZ61arIWD.0. Exception type org.teiid.core.TeiidProcessingException thrown from sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method). Enable more detailed logging to see the entire stacktrace. 22:29:06,210 WARN [PROCESSOR] Processing exception 'INVALID_QUERY_LOCATOR: invalid query locator' for request cNxqZ61arIWD.0. Exception type org.teiid.core.TeiidProcessingException thrown from sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method). Enable more detailed logging to see the entire stacktrace. 2010-12-21 22:29:06,211 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue12) cNxqZ61arIWD.0.1.2 Closed execution 2010-12-21 22:29:06,212 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue12) cNxqZ61arIWD.0.1.2 Remove State 2010-12-21 22:29:06,213 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue12) cNxqZ61arIWD.0.1.2 Closed connection -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira