BPM update definition fails

Hi guys,
Database is mysql Ver 14.14 Distrib 5.6.35, for Linux (x86_64) .

There is an error when I am trying to update process definition.

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bpm_test.TL_BPM_PROC_TASK' doesn't exist
Query: UpdateAllQuery(referenceClass=ProcTask sql="CREATE TEMPORARY TABLE IF NOT EXISTS TL_BPM_PROC_TASK (ID UUID NOT NULL, ACT_EXECUTION_ID VARCHAR(255), ACT_PROCESS_DEFINITION_ID VARCHAR(255), ACT_TASK_DEFINITION_KEY VARCHAR(255), ACT_TASK_ID VARCHAR(255), CANCELLED TINYINT(1) default 0, CLAIM_DATE DATETIME, COMMENT_ LONGTEXT, CREATE_TS DATETIME, CREATED_BY VARCHAR(255), DELETE_TS DATETIME, DELETED_BY VARCHAR(255), END_DATE DATETIME, NAME VARCHAR(255), OUTCOME VARCHAR(255), START_DATE DATETIME, UPDATE_TS DATETIME, UPDATED_BY VARCHAR(255), VERSION INTEGER, PROC_ACTOR_ID UUID, PROC_INSTANCE_ID UUID, PRIMARY KEY (ID))")

Full Tomcat stack trace: https://pastebin.com/jQe8RLK3
Full mysql query.log: https://pastebin.com/8iHGyudW

Tested also in another project without any interference to cuba bpm, runing on mysql Ver 14.14 Distrib 5.6.36, for Linux (x86_64), same problem.

Thank you for any help.

Hi,
what platform version do you use? It seems that this error was fixed in 6.5.4. Here is the issue: https://youtrack.cuba-platform.com/issue/PL-9182

1 Like

I am still on 6.5.1, thank you Max for information, I will migrate to latest version soon.