J Price created TEIID-4402: ------------------------------ Summary: Insert statement with a date field fails Key: TEIID-4402 URL: https://issues.jboss.org/browse/TEIID-4402 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 9.0.2 Environment: WildFly Full 9.0.2.Final (WildFly Core 1.0.2.Final) Teiid 9.0.2 jdk1.8.0_101 Salesforce sandbox Salesforce connectors / translators: salesforce and salesforce-34 Reporter: J Price Assignee: Steven Hawkins I have a custom object created in Salesforce which has date fields. The model has the fields identified as date correctly. When specifying a date using an insert statement I receive an error back from Salesforce: _ org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Sandbox: Start Date: value not of required type: 2016-03-17_ I have tried forcing it to a date using the parsedate function as well as passing it as is. I setup a proxy to try and identify the cause and found that the datatype being passed in the underlying SOAP request is xsd:string instead of xsd:date. Using fiddler I duplicated the underlying SOAP request, but changed the types to xsd:date, and resubmitted the request successfully. -- This message was sent by Atlassian JIRA (v6.4.11#64026)