Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1144324

Summary: Empty error message in insert procedure transformation
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Andrej Smigala <asmigala>
Component: ToolingAssignee: Barry LaFond <blafond>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: dlesage, felias, vhalbert
Target Milestone: ER4   
Target Release: 6.1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
When the user created a virtual insert procedure and omitted a non-nullable column from the insert, the error message was simply "ERROR: ERROR". The more descriptive message "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" is now displayed.
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-11-17 18:08:41 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Andrej Smigala 2014-09-19 08:51:17 UTC
When creating a virtual insert procedure and omitting a non-nullable column from the insert, the error message is simply

    ERROR: ERROR

E. g. I have a PUBLISHERS table with three columns, of which PUBLISHER_ID is NOT NULL, the insert procedure is

FOR EACH ROW
BEGIN ATOMIC
	INSERT INTO Books.PUBLISHERS (Books.PUBLISHERS.NAME) VALUES ("NEW".NAME);
END


The error in previous versions of Designer for the same procedure would be

    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.

Comment 2 JBoss JIRA Server 2014-11-03 16:08:43 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2344 to Resolved

Comment 3 JBoss JIRA Server 2015-02-12 08:48:00 UTC
Andrej Šmigala <asmigala> updated the status of jira TEIIDDES-2344 to Closed