-
Bug
-
Resolution: Obsolete
-
Major
-
9.0.1
-
None
-
None
-
Workaround Exists
-
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
Log attached
With dynamic VDB created manually or with import using Teiid Connection Importer via Designer everything works.
Project from Designer + dynamic VDB attached
- relates to
-
TEIID-3670 Salesforce query issue
-
- Closed
-