Error when opening scheduled tasks view

hi,
I’ve got the following message when I open the scheduled tasks view in my app :

SQLSyntaxErrorException: unexpected token: AS required: ( in statement [
SELECT LIMIT ? ? ID AS a1, IS_ACTIVE AS a2, BEAN_NAME AS a3, CLASS_NAME AS a4, 
CRON AS a5, DEFINED_BY AS a6, DELETE_TS AS a7, DELETED_BY AS a8, 
DESCRIPTION AS a9, LAST_START_SERVER AS a10, LAST_START_TIME AS a11, 
LOG_FINISH AS a12, LOG_START AS a13, METHOD_NAME AS a14, 
METHOD_PARAMS AS a15, PERIOD AS a16, PERMITTED_SERVERS AS a17, 
SCHEDULING_TYPE AS a18, SCRIPT_NAME AS a19, IS_SINGLETON AS a20, 
START_DATE AS a21, START_DELAY AS a22, TIME_FRAME AS a23, 
TIMEOUT AS a24, USER_NAME AS a25 
FROM SYS_SCHEDULED_TASK 
WHERE (DELETE_TS IS NULL) ORDER BY BEAN_NAME, METHOD_NAME]

my environement :

  • Cuba studio 10.1
  • platform 7.0.6

regards
guillaume lundy

Hello @guillaume.lundy

The problem is related to HSQL version used in a project. Please check “Breaking changes” section in Release notes: link.

You can switch to any other RDBMS to solve the problem.

Regards
Daniil

Hi,
Thanks for the reply and the workaroud

Regards,
Guillaume