Empty error message in insert procedure transformation ------------------------------------------------------ Key: TEIIDDES-2344 URL: https://issues.jboss.org/browse/TEIIDDES-2344 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 8.6 Reporter: Andrej Šmigala Assignee: Barry LaFond Priority: Minor Fix For: 9.0, 8.6.1, 9.0.1 When creating a virtual insert procedure and omitting a non-nullable column from the insert, the error message is simply {quote}ERROR: ERROR{quote} E. g. I have a PUBLISHERS table with three columns, of which PUBLISHER_ID is NOT NULL, the insert procedure is {code:sql} FOR EACH ROW BEGIN ATOMIC INSERT INTO Books.PUBLISHERS (Books.PUBLISHERS.NAME) VALUES ("NEW".NAME); END {code} The error in previous versions of Designer for the same procedure would be {quote} ERROR: Element Books.PUBLISHERS.PUBLISHER_ID of books.publishers is neither nullable nor has a default value. A value must be specified in the insert. {quote}