Problem:-
Error Code: 1067. Invalid default value for 'END_DATE'
Solution:
This issues was fixed in Domibus 4.1.5. Please upgrade to the latest Domibus in order to fix this issue.
1. For a new domibus 4.1.2 or 4.1.3 database, these are the scripts that can be used to correctly create the TB_CERTIFICATE and TB_SEND_ATTEMPT table:
CREATE TABLE TB_CERTIFICATE (ID_PK BIGINT AUTO_INCREMENT NOT NULL, CERTIFICATE_ALIAS VARCHAR(255) NOT NULL, NOT_VALID_BEFORE_DATE datetime NULL, NOT_VALID_AFTER_DATE datetime NULL, REVOKE_NOTIFICATION_DATE timestamp NULL, ALERT_IMM_NOTIFICATION_DATE timestamp NULL, ALERT_EXP_NOTIFICATION_DATE timestamp NULL, CERTIFICATE_STATUS VARCHAR(255) NOT NULL, CERTIFICATE_TYPE VARCHAR(255) NOT NULL, CONSTRAINT PK_TB_CERTIFICATE PRIMARY KEY (ID_PK));
CREATE TABLE TB_SEND_ATTEMPT (ID_PK BIGINT AUTO_INCREMENT NOT NULL, MESSAGE_ID VARCHAR(255) NOT NULL, START_DATE datetime NOT NULL, END_DATE datetime NOT NULL, STATUS VARCHAR(255) NOT NULL, ERROR VARCHAR(255) NULL, CONSTRAINT PK_TB_SEND_ATTEMPT PRIMARY KEY (ID_PK));
Please find enclosed the script mysql5innoDb-4.1.3_fix.ddl modified to replace the mysql5innoDb-4.1.3.ddl for the purpose.
2. If the databases has already been created (and for any existing domibus 4.1.2 or 4.1.3 database), please run this script to correct the data types:
ALTER TABLE TB_CERTIFICATE MODIFY NOT_VALID_BEFORE_DATE datetime;
ALTER TABLE TB_CERTIFICATE MODIFY NOT_VALID_AFTER_DATE datetime;
ALTER TABLE TB_SEND_ATTEMPT MODIFY START_DATE datetime NOT NULL;
ALTER TABLE TB_SEND_ATTEMPT MODIFY END_DATE datetime NOT NULL;