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

Details

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

    Description

      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

      Attachments

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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: