[jbpm-issues] [JBoss JIRA] Updated: (JBPM-3062) WS-HT task service schema export fails for EmailNotification.emailHeaders under DB2 (SQLCODE=-542)

WS-HT task service schema export fails for EmailNotification.emailHeaders under DB2 (SQLCODE=-542) -------------------------------------------------------------------------------------------------- Key: JBPM-3062 URL: https://issues.jboss.org/browse/JBPM-3062 Project: jBPM Issue Type: Bug Security Level: Public(Everyone can see) Components: Runtime Engine Affects Versions: jBPM 5.0 Environment: DB2 UDB, 9.7. Reporter: Vadim Melnik Assignee: Kris Verlaenen Fix For: jBPM 5.1 JBPM WS-HT task service implementation failed to create schema with DB2 DB. Error log listed below. ERROR SchemaExport:348 - Unsuccessful: create table Notification_email_header (Notification_id bigint not null, emailHeaders_id bigint not null, mapkey varchar(255), primary key (Notification_id, mapkey), unique (emailHeaders_id)) ERROR SchemaExport:349 - DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=MAPKEY, DRIVER=4.11.77 ERROR SchemaExport:348 - Unsuccessful: alter table Notification_email_header add constraint FKF30FE3441F7B912A foreign key (emailHeaders_id) references email_header ERROR SchemaExport:349 - DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC= NOTIFICATION_EMAIL_HEADER, DRIVER=4.11.77 ERROR SchemaExport:348 - Unsuccessful: alter table Notification_email_header add constraint FKF30FE34430BE501C foreign key (Notification_id) references Notification ERROR SchemaExport:349 - DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC= NOTIFICATION_EMAIL_HEADER, DRIVER=4.11.77 Issue is related to org.jbpm.task.EmailNotification.emailHeaders mapping. Probably problem nature is similar to this one - https://issues.jboss.org/browse/JBPAPP-1071 .