topic Re: Access value of process variable in the database in Alfresco Archive

Access value of process variable in the database

caiw — Thu, 23 Aug 2012 06:51:53 GMT

Hi,I'm using BIRT to create reports to show information from a couple of Activiti processes. I'd like to access the value of a process variable that is set in a script task in one of my Activiti processes, but when I look for the variable in the database table "ACT_RU_VARIABLE" the row looks like th

Re: Access value of process variable in the database

mitziuro — Thu, 23 Aug 2012 07:03:47 GMT

Actually the create for ACT_RU_VARIABLE is:


create table ACT_RU_VARIABLE (
    ID_ nvarchar(64) not null,
    REV_ int,
    TYPE_ nvarchar(255) not null,
    NAME_ nvarchar(255) not null,
    EXECUTION_ID_ nvarchar(64),
    PROC_INST_ID_ nvarchar(64),
    TASK_ID_ nvarchar(64),
    BYTEARRAY_ID_ nvarchar(64),
    DOUBLE_ double precision,
    LONG_ numeric(19,0),
    TEXT_ nvarchar(4000),
    TEXT2_ nvarchar(4000),
    primary key (ID_)
);

You'll have to look at LONG_ and TEXT_ columns

Re: Access value of process variable in the database

caiw — Thu, 23 Aug 2012 07:05:38 GMT

They are both empty, that's why I removed them from my excerpt, as I wrote.

Re: Access value of process variable in the database

mitziuro — Thu, 23 Aug 2012 07:08:54 GMT

…like this (I removed the columns that are empty):

It means that value it's the empty string or you don't save the correct value .

Re: Access value of process variable in the database

caiw — Thu, 23 Aug 2012 07:17:54 GMT

No, I don't think so, because the process works like it's supposed to (I use the process variables in conditions to direct the process flow) and I can se that the value is set correctly when I look at the process instance in the Activiti Explorer.

It's just in the database I can't find the value. It's the same with other process variables, they look the same in the database, with TYPE_ serializable and empty TEXT_ column but a value in BYTEARRAY_ID_.

Re: Access value of process variable in the database

mitziuro — Thu, 23 Aug 2012 07:20:57 GMT

Look in ACT_GE_BYTEARRAY at the 14187 entry. It's serialized in the BYTES_ field.

Re: Access value of process variable in the database

caiw — Thu, 23 Aug 2012 07:38:40 GMT

Then I get this:

ID_ REV_ NAME_ DEPLOYMENT_ID_ BYTES_ GENERATED_
14187 1 FFFFFFAC FFFFFFED 0 5 74 0 13 74 …

I don't really know what to do with this..