INVALID_TYPE error in DV joining two tables of a salesforce datasource

Solution Verified - Updated -


  • 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


  • 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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content