Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2500

Problems with model created via import from Salesforce when using JOIN query

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Major Major
    • 9.0.4, 9.2
    • 9.0.1
    • None
    • None

      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

        1. log
          12 kB
        2. salesdynamic-vdb.xml
          0.2 kB
        3. SalesforceTD.zip
          1.24 MB

            mdrillin1@redhat.com Mark Drilling (Inactive)
            mmakovy@redhat.com Matus Makovy
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: