[teiid-issues] [JBoss JIRA] (TEIID-4947) Error with Salesforce translator if criteria on outer join on a custom table is from the right side table
RH Bugzilla Integration (JIRA)
issues at jboss.org
Mon Sep 18 12:16:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13465248#comment-13465248 ]
RH Bugzilla Integration commented on TEIID-4947:
------------------------------------------------
Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1492803|https://bugzilla.redhat.com/show_bug.cgi?id=1492803] from NEW to MODIFIED
> Error with Salesforce translator if criteria on outer join on a custom table is from the right side table
> ----------------------------------------------------------------------------------------------------------
>
> Key: TEIID-4947
> URL: https://issues.jboss.org/browse/TEIID-4947
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 8.7.11.6_2, 8.12.10.6_3
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 10.0, 8.12.x-6.4, 9.3.1, 8.12.12.6_3, 8.7.13.6_2
>
>
> Running a left outer join between a parent and child custom table in salesforce results in an error:
> select a.id, a.name, a.LastModifiedDate, b.Order_Recipe_Steps__c, b.name
> from MPRS_Salesforce.Media_Prep_Order_Recipe_Steps__c a left outer join "MPRS_Salesforce"."Recipe_Step_Detail__c" b
> on (a.id = b.Order_Recipe_Steps__c)
> where b.LastModifiedDate >= parsetimestamp('2016-05-04 15:01:03.0', 'yyyy-MM-dd hh:mm:ss.s')
> Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 MPRS_Salesforce: com.sforce.soap.partner.InvalidSObjectFault: INVALID_TYPE:
> Recipe_Step_Detail__c.Catalog_Item__c FROM Recipe_Step_Detail__cs) FROM Media_Prep_Order_Recipe_Steps__c
> ^
> ERROR at Row:1:Column:1137
> Didn't understand relationship 'Recipe_Step_Detail__cs' in FROM part of query call. 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.
> SQLState: 50000
> ErrorCode: 30504
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list