Db create script error

Support
#1

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"?>

', null);

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?

#3

Hi @gmirko95 ,

Could you please specify more details about your MS SQL Sever configuration?
What default language is set for the login used to connection (by default, dbUser = ‘sa’)?

Regards,
Maria.