Bug 1216954 - Problems with model created via import from Salesforce when using JOIN query
Summary: Problems with model created via import from Salesforce when using JOIN query
Keywords:
Status: CLOSED WORKSFORME
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: unspecified
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: ---
Assignee: Barry LaFond
QA Contact: Matus Makovy
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-04-29 09:52 UTC by Matus Makovy
Modified: 2016-02-05 10:18 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-02-05 10:18:41 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-2500 0 Major Closed Problems with model created via import from Salesforce when using JOIN query 2016-02-05 10:17:50 UTC

Description Matus Makovy 2015-04-29 09:52:46 UTC 
Discovered this issue when trying to verify TEIID-3112

I am trying to execute this query on VDB created via import from SalesForce in Teiid Designer.


select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from  "SalesForceSource".salesforce.Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".salesforce.Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32


And I get this exception: 

org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: Invalid QName in mapping: sf:INVALID_TYPE



With dynamic VDB created manually or with import using Teiid Connection Importer via Designer everything works.

For attachments see JIRA
Comment 1 Barry LaFond 2015-07-28 14:56:43 UTC 
Pushing to 9.0.4
Comment 2 JBoss JIRA Server 2015-09-02 14:23:56 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-2500 to Resolved
Comment 3 Barry LaFond 2015-09-02 14:25:47 UTC 
TEIIDDES-2500 was retested with DV 6.2 and issue not reproducable.
Comment 4 JBoss JIRA Server 2015-10-12 07:16:58 UTC 
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2500 to Closed
Note You need to log in before you can comment on or make changes to this bug.