Hi,
in my project I have used Imap addon.
I tryed to create new database and install application.
In cuba create imap-component init script 30.create-db.sql file, I have this istruction:
insert into SYS_SCHEDULED_TASK
(ID, CREATE_TS, CREATED_BY, UPDATE_TS, UPDATED_BY, DELETE_TS, DELETED_BY, DEFINED_BY, BEAN_NAME, METHOD_NAME, CLASS_NAME, SCRIPT_NAME, USER_NAME, IS_SINGLETON, IS_ACTIVE, PERIOD_, TIMEOUT, START_DATE, CRON, SCHEDULING_TYPE, TIME_FRAME, START_DELAY, PERMITTED_SERVERS, LOG_START, LOG_FINISH, LAST_START_TIME, LAST_START_SERVER, METHOD_PARAMS, DESCRIPTION)
values (‘1082fe3b-3b75-d2f2-d858-dbae487c4549’, ‘2019-03-22 10:26:18’, ‘admin’, ‘2019-03-22 10:26:18’, null, null, null, ‘B’, ‘imap_ImapScheduler’, ‘syncImap’, null, null, null, null, null, 30, null, null, null, ‘P’, null, null, null, true, true, null, null, ’<?xml version="1.0" encoding="UTF-8"?>
This istruction fails if I try to create database.
My mssql installation has date format: dmy.
If I modify manually the insert instruction with correct data format when I run application I lose my modify and Cuba recreate wrong Istruction.
How I can resolve this problem?