topic Re: Mysql error updating variable in Alfresco Archive

Mysql error updating variable

daniel123 — Fri, 29 Nov 2013 08:52:19 GMT

Hi everybody,I developed an activiti application that launches an exe on a set of files and all works great but i get a mysql data truncated error setting variables if i run the process again.I have a windows xp server running activiti 5.13 on tomcat 8, jdk 7, and mysql 5.5.24.here is the error i ge

Re: Mysql error updating variable

martin_grofcik — Mon, 02 Dec 2013 10:11:48 GMT

Hi Daniel,

It seems your variable content is too long. I do not know why because:
ACT_RU_VARIABLE.TEXT_ is varchar(4000). (It should be enough for the most cases).

Could you check your DB table, content of variable which is inserted to get more info?


create table ACT_RU_VARIABLE (
    ID_ varchar(64) not null,
    REV_ integer,
    TYPE_ varchar(255) not null,
    NAME_ varchar(255) not null,
    EXECUTION_ID_ varchar(64),
    PROC_INST_ID_ varchar(64),
    TASK_ID_ varchar(64),
    BYTEARRAY_ID_ varchar(64),
    DOUBLE_ double,
    LONG_ bigint,
    TEXT_ varchar(4000),
    TEXT2_ varchar(4000),
    primary key (ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

Re: Mysql error updating variable

daniel123 — Mon, 02 Dec 2013 14:00:18 GMT

hallo Martin.
It's very strange: the length of the string i try to set is very short (5 or 4 characters).

Re: Mysql error updating variable

martin_grofcik — Tue, 03 Dec 2013 08:08:33 GMT

Could you create simple jUnit test? (Or you can use currently existing one e.g. org.activiti.examples.variables.VariablesTest)
and run it against your mySQL DB?