topic Re: Question about History Level in Alfresco Archive

Question about History Level

brianrook — Fri, 30 Sep 2011 17:03:49 GMT

We just upgraded from 5.2 to 5.6 and we're using DB2 as our RDBMS platform. We are currently creating the database and seed data manually from the scripts because the 'automatic' DB upgrade tool doesn't work. However, we ran into an issue last night that I am curious about. My development and tes

Re: Question about History Level

trademak — Sat, 01 Oct 2011 13:49:32 GMT

Hi,

What Activiti configuration are you using? Could you post the activiti.cfg.xml contents or equivalent info?

Best regards,

Re: Question about History Level

brianrook — Mon, 03 Oct 2011 14:40:43 GMT

Here's the current Activiti configuration for that project:


<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
  http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
  http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">

  <bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration" >
    <property name="databaseType" value="db2" />
    <property name="dataSource" ref="documentDataSource" />
    <property name="transactionManager" ref="iipTransactionManager" />
    <property name="databaseSchemaUpdate" value="true" />
    <property name="jobExecutorActivate" value="false" />
    <property name="deploymentResources" value="classpath*:bpmn20/*.bpmn20.xml" /> <!– Deploy all process definitions –>
  </bean>
  
  <bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean">
    <property name="processEngineConfiguration" ref="processEngineConfiguration" />
  </bean>
  
  <bean id="repositoryService" factory-bean="processEngine" factory-method="getRepositoryService" />
  <bean id="runtimeService" factory-bean="processEngine" factory-method="getRuntimeService" />
  <bean id="taskService" factory-bean="processEngine" factory-method="getTaskService" />
  <bean id="historyService" factory-bean="processEngine" factory-method="getHistoryService" />
  <bean id="managementService" factory-bean="processEngine" factory-method="getManagementService" />


</beans>

I assume that this gives historyLevel the default value of "audit" which I think is equal to "2".

And here is the ACT_GE_PROPERTY insert statements:


insert into ACT_GE_PROPERTY
values ('schema.version', '5.6', 1);

insert into ACT_GE_PROPERTY
values ('schema.history', 'create(5.6)', 1);

insert into ACT_GE_PROPERTY
values ('next.dbid', '1', 1);

However, I get the historyLevel error with these values in that table until I add this one:


insert into ACT_GE_PROPERTY
values ('historyLevel', '2', 1);

which seems to enable it to work

Re: Question about History Level

trademak — Tue, 04 Oct 2011 09:07:51 GMT

Okay thanks. The history level in the database is the one used in the Activiti Engine.
The history level in the configuration is only used to fill the history level in the database.
If the history level is not set during the upgrade then that's probably a bug. Maybe it works if you set the history level explicitly in the configuration.
But if this works for you then that's good right?

Best regards,

Re: Question about History Level

brianrook — Tue, 04 Oct 2011 15:03:13 GMT

When we first encountered this problem, we added a history property in the process engine. However, this would cause an error… I don't remember what it was off the top of my head, but we would see something like historyLevel 1 is not equal to 2 or something like that. That's when we figured out that we needed a value in the database and added that insert ourselves. Once we had that and made it agree with what was in the history property in the configuration file we were okay.

I was just concerned because it appears that a value is needed in the database, but it's not being inserted by the setup scripts.

Re: Question about History Level

frederikherema1 — Wed, 05 Oct 2011 06:11:47 GMT

It's inserted by code when schema is created the first time, and inserted so you DON'T change the histry level on an existing engine (to prevent inconsistency of data and really really bad things from happening ). So changing the property in the database is a bad idea…

Re: Question about History Level

jrussell — Fri, 13 Apr 2012 02:31:41 GMT

We just ran into this ourselves, and the answer given is not acceptable.

Many envrionments (such as ours) do not allow the database schema to be maintaned by the application, rather by DBAs. Thus the databaseSchemaUpdate MUST be set to "false" and the database created/updated via external scripts by the DBAs.

Saying the only way for this to be set is by having update=true makes this product unusable for environments like ours.

For us, we were able to read the code and figure out what was missing, but this should be documented.