Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1863

Default Salesforce URL in teiid-connector-salesforce.rar needs update to SF v22

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7, 8.0
    • 7.4
    • Misc. Connectors
    • None
    • Hide

      Import the Contact table from SF in teiid designer. Then do a preview query of the Contact table. It results in the following exception:

      ERROR at Row:1:Column:813
      No such column 'Jigsaw' on entity 'Contact'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
      at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:191)
      at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:147)
      ... 14 more
      Caused by: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD:
      Contact.EmailBouncedReason, Contact.EmailBouncedDate, Contact.Jigsaw, Contact.Primary_contact__c

      Show
      Import the Contact table from SF in teiid designer. Then do a preview query of the Contact table. It results in the following exception: ERROR at Row:1:Column:813 No such column 'Jigsaw' on entity 'Contact'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:191) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:147) ... 14 more Caused by: com.sforce.soap.partner.InvalidFieldFault: INVALID_FIELD: Contact.EmailBouncedReason, Contact.EmailBouncedDate, Contact.Jigsaw, Contact.Primary_contact__c
    • Hide

      The user can hand edit the salesforce -ds.xml to override the default, including the URL property value line:

      <config-property-value>https://www.salesforce.com/services/Soap/u/22.0</config-property-value>

      Show
      The user can hand edit the salesforce -ds.xml to override the default, including the URL property value line: <config-property-value> https://www.salesforce.com/services/Soap/u/22.0 </config-property-value>

    Description

      The salesforce jars were updated using v22 of the salesforce WSDL, however the default URL in teiid-connector.salesforce.rar was not updated.

      The URL config-property in ra.xml should be changed to:
      <config-property-value>https://www.salesforce.com/services/Soap/u/22.0</config-property-value>

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            mdrillin1@redhat.com Mark Drilling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: