Teiid 8.8 Version : Issues faced with executing query on a Salesforce model in Teiid Embedded
Hi,
I am facing issues with querying a VDB having a Salesforce model through Teiid Embedded v8.8.
select
Product2Feed.ParentId as Product2Feed_ParentId,
Product2.Description as Product2_Description,
Product2Feed.Title as Product2Feed_Title
from
SalesForceModel.Product2Feed Product2Feed
LEFT OUTER JOIN
SalesForceModel.Product2 Product2 ON Product2Feed.ParentId = Product2.Id
LIMIT 0 , 30
Error :
Error TEIID30504 SalesForceInstance: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
and i got this as log in the console :
Aug 01, 2014 10:22:59 AM org.teiid.logging.JavaLogger log
WARNING: Connector worker process failed for atomic-request=FypKSYQOCoLF.0.0.514
org.teiid.translator.TranslatorException: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:162)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:326)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107)
at java.util.concurrent.FutureTask.run(Unknown Source)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.resource.ResourceException: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:190)
at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:148)
... 12 more
Caused by: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at sun.reflect.GeneratedConstructorAccessor1091.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:144)
at com.sun.xml.ws.client.sei.StubHandler.readResponse(StubHandler.java:253)
at com.sun.xml.ws.db.DatabindingImpl.deserializeResponse(DatabindingImpl.java:181)
at com.sun.xml.ws.db.DatabindingImpl.deserializeResponse(DatabindingImpl.java:258)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:117)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:91)
at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:154)
at com.sun.proxy.$Proxy156.query(Unknown Source)
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:187)
... 13 more
Aug 01, 2014 10:22:59 AM org.teiid.logging.JavaLogger log
WARNING: TEIID30020 Processing exception for request FypKSYQOCoLF.0 'TEIID30504 SalesForceInstance: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.'. Originally TeiidProcessingException sun.reflect.GeneratedConstructorAccessor1091.newInstance(Unknown Source). Enable more detailed logging to see the entire stacktrace.
Aug 01, 2014 10:23:31 AM org.teiid.logging.JavaLogger log
WARNING: Connector worker process failed for atomic-request=ZL204eretyOQ.0.0.515
org.teiid.translator.TranslatorException: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:162)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:326)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107)
at java.util.concurrent.FutureTask.run(Unknown Source)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.resource.ResourceException: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:190)
at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:148)
... 12 more
Caused by: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at sun.reflect.GeneratedConstructorAccessor1091.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:144)
at com.sun.xml.ws.client.sei.StubHandler.readResponse(StubHandler.java:253)
at com.sun.xml.ws.db.DatabindingImpl.deserializeResponse(DatabindingImpl.java:181)
at com.sun.xml.ws.db.DatabindingImpl.deserializeResponse(DatabindingImpl.java:258)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:117)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:91)
at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:154)
at com.sun.proxy.$Proxy157.query(Unknown Source)
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:187)
... 13 more
Aug 01, 2014 10:23:31 AM org.teiid.logging.JavaLogger log
WARNING: TEIID30020 Processing exception for request ZL204eretyOQ.0 'TEIID30504 SalesForceInstance: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.'. Originally TeiidProcessingException sun.reflect.GeneratedConstructorAccessor1091.newInstance(Unknown Source). Enable more detailed logging to see the entire stacktrace.
Aug 01, 2014 10:23:34 AM org.teiid.logging.JavaLogger log
WARNING: Connector worker process failed for atomic-request=qxJKkPvp8B2p.0.0.516
org.teiid.translator.TranslatorException: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:162)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:326)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107)
at java.util.concurrent.FutureTask.run(Unknown Source)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.resource.ResourceException: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:190)
at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:148)
... 12 more
Caused by: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at sun.reflect.GeneratedConstructorAccessor1091.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:144)
at com.sun.xml.ws.client.sei.StubHandler.readResponse(StubHandler.java:253)
at com.sun.xml.ws.db.DatabindingImpl.deserializeResponse(DatabindingImpl.java:181)
at com.sun.xml.ws.db.DatabindingImpl.deserializeResponse(DatabindingImpl.java:258)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:117)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:91)
at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:154)
at com.sun.proxy.$Proxy158.query(Unknown Source)
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:187)
... 13 more
Aug 01, 2014 10:23:34 AM org.teiid.logging.JavaLogger log
WARNING: TEIID30020 Processing exception for request qxJKkPvp8B2p.0 'TEIID30504 SalesForceInstance: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.'. Originally TeiidProcessingException sun.reflect.GeneratedConstructorAccessor1091.newInstance(Unknown Source). Enable more detailed logging to see the entire stacktrace.
Aug 01, 2014 10:23:37 AM org.teiid.logging.JavaLogger log
WARNING: Connector worker process failed for atomic-request=wLgYBw1a+y2B.0.0.517
org.teiid.translator.TranslatorException: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:162)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:326)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107)
at java.util.concurrent.FutureTask.run(Unknown Source)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.resource.ResourceException: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:190)
at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:148)
... 12 more
Caused by: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
at sun.reflect.GeneratedConstructorAccessor1091.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:144)
at com.sun.xml.ws.client.sei.StubHandler.readResponse(StubHandler.java:253)
at com.sun.xml.ws.db.DatabindingImpl.deserializeResponse(DatabindingImpl.java:181)
at com.sun.xml.ws.db.DatabindingImpl.deserializeResponse(DatabindingImpl.java:258)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:117)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:91)
at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:154)
at com.sun.proxy.$Proxy159.query(Unknown Source)
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:187)
... 13 more
Aug 01, 2014 10:23:37 AM org.teiid.logging.JavaLogger log
WARNING: TEIID30020 Processing exception for request wLgYBw1a+y2B.0 'TEIID30504 SalesForceInstance: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
SELECT Product2Feed.ParentId, Product2.Description, Product2Feed.Title
^
ERROR at Row:1:Column:31
Didn't understand relationship 'Product2' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.'. Originally TeiidProcessingException sun.reflect.GeneratedConstructorAccessor1091.newInstance(Unknown Source). Enable more detailed logging to see the entire stacktrace.
