INVALID_TYPE error in DV joining two tables of a salesforce datasource

Solution Verified - Updated -

Issue

  • Running query that joins two custom objects/tables of salesforce using primary key and foreign key throws below error:
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

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.2.10, 6.3.6
  • Salesforce Translator

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.