Salesforce: Insert fails in case of tables with salesforce standard objects --------------------------------------------------------------------------- Key: TEIID-5919 URL: https://issues.redhat.com/browse/TEIID-5919 Project: Teiid Issue Type: Bug Components: Query Engine, Salesforce Connector Affects Versions: 13.1 Reporter: Dmitrii Pogorelov Assignee: Steven Hawkins Priority: Major Fix For: 14.0, 13.1.1 Original Estimate: 2 hours Time Spent: 2 hours, 30 minutes Remaining Estimate: 0 minutes An insert fails in the case of a Salesforce table with standard objects. For example, the Contact table (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api...) in salesforce contains Name standard object: https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api.... The field can't be null, doesn't support create(), insert() and so on operations but should be filled automatically by salesforce. As a result when running the following query: {code:sql} INSERT INTO sf34.Contact ("LastName", "FirstName", "Salutation", "MailingStreet", "MailingCity", "MailingPostalCode", "MailingCountry") VALUES ('Hillrichsen', 'Suse', 'Mrs.', 'Frankfurter Allee 29', 'Berlin', '10247','Deutschland') ;; {code} Teiid generates the following error: {code} 2020-03-16 16:35:15,105 WARN [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue50) ij6teT/JNA+c TEIID30020 Processing exception for request ij6teT/JNA+c.18 'TEIID30492 Element sf34.Contact.Name of sf34.Contact is neither nullable nor has a default value. A value must be specified in the insert.'. Originally QueryValidatorException Request.java:343. Enable more detailed logging to see the entire stacktrace. {code} The problem can be solved by a native call, for example: {code:sql} SELECT * FROM (call "sf34.native"('create;type=Contact;attributes=LastName,FirstName,Salutation,MailingStreet,MailingCity,MailingPostalCode,MailingCountry','Erich','Honecker','Herr','Magdalenenstr. 99','Berlin','11799','DE')) lpk ;; {code} but it won't work with dates/timestamps types (no sample request available).