topic Re: activiti database index in Alfresco Archive

activiti database index

christoph_retti — Thu, 25 Oct 2012 16:52:48 GMT

Hello, is there some guide on which database index should be placed per default on a fresh activiti (5.10) installation.I had some database locks and checked the (SQL Server 2008) database (found some hints here in the forum) and there is no index at all on the databaseMaybe you could post a list

Re: activiti database index

jbarrez — Fri, 26 Oct 2012 06:27:54 GMT

No indexes?

I checked the activiti.mssql.create.engine.sql file and found these for the runtime alone:


create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null;
create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);

If you don't have any indexes, I'm afraid something has gone wrong there …

Re: activiti database index

christoph_retti — Fri, 02 Nov 2012 15:47:05 GMT

Hi, I am really sorry, there was a mistake by my side!

I transferred the database schema from a remote activiti database for testing to my local instance and it seems that MS SQL Server 2008 Management Studio
does not create the datanbase index in this case - so I was left without any primary key, index or foreign references

sorry for that!!!

chris