5 Replies Latest reply on Sep 3, 2014 3:32 PM by Steven Hawkins

    Teiid 8.8 Version : Issues faced with executing query on a Salesforce model in Teiid Embedded

    Joseph CHIDIAC Novice

      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.