Scheduled Task screen exists bug

deployment
databases

(RAY.LV) #1

Hi,
Run the scheduled task function, occurs the following error:

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 DESCRIPTION]

image

Platform: 7.0.4
DB: HSQL


(Andrey Subbotin) #2

Hi,

This is a known issue with Studio 9 and projects using HSQL. See SQLSyntaxErrorException: unexpected token: AS required: ( in statement


(RAY.LV) #3

Hi, Andrey

Thanks a lot.