topic ACT_RU_TASK table cleaned after new Activiti war file deploy ! in Alfresco Archive

ACT_RU_TASK table cleaned after new Activiti war file deploy !

gi00vani_kun — Tue, 31 Mar 2015 07:06:56 GMT

Hello,I have a strange problem :- on my local environment (oracle 11g xe) when ever I deploy a new WAR file all the previous task created are being erased from the database (ACT_RU_TASK) table- on my development environment it's pretty much the same the super admin (kermit) comes and complete the t

Re: ACT_RU_TASK table cleaned after new Activiti war file deploy !

jbarrez — Tue, 31 Mar 2015 09:25:00 GMT

What is your setting for the databaseSchemaUpdate? Does it recreate the schema on each deploy?

> the super admin (kermit) comes and complete the tasks (some one invalidates the tasks ) upon deploying a new WAR file

That sounds very strange. Can you describe exactly what you see, this is kinda vague.

Re: ACT_RU_TASK table cleaned after new Activiti war file deploy !

gi00vani_kun — Tue, 31 Mar 2015 11:44:54 GMT

Hi,
Thank you for answering !
here is what I have in org.activiti.explorer.conf.ActivitiEngineConfiguration

<code>
@Bean(name = { "processEngineConfiguration" })
    public ProcessEngineConfigurationImpl processEngineConfiguration() {
        SpringProcessEngineConfiguration processEngineConfiguration = new SpringProcessEngineConfiguration();
        processEngineConfiguration.setDataSource(dataSource());
//        processEngineConfiguration.setDatabaseSchemaUpdate(environment
//                .getProperty("engine.schema.update", "false"));

        processEngineConfiguration
                .setTransactionManager(annotationDrivenTransactionManager());
        processEngineConfiguration.setJobExecutorActivate(Boolean
                .valueOf(
                        environment.getProperty("engine.activate.jobexecutor",
                                "false")).booleanValue());

        processEngineConfiguration.setHistory(environment.getProperty(
                "engine.history.level", "full"));

        List<AbstractFormType> formTypes = new ArrayList<AbstractFormType>();
        formTypes.add(new UserFormType());
        formTypes.add(new ProcessDefinitionFormType());
        formTypes.add(new MonthFormType());

        formTypes.add(new GridFormType());

        processEngineConfiguration.setCustomFormTypes(formTypes);
        return processEngineConfiguration;
    }
</code>

I've tried just now both versions
1)
<code>//        processEngineConfiguration.setDatabaseSchemaUpdate(environment
//                .getProperty("engine.schema.update", "false"));
</code>

2)
<code>       processEngineConfiguration.setDatabaseSchemaUpdate(environment
                  .getProperty("engine.schema.update", "false"));
</code>

I can also see that in Processengineconfiguration the default is :
<code>protected String databaseShemaUpdate ="false"; </code>

For the development server I'm not working on that server right now if I'll hit the problem again I'll let you know !

Re: ACT_RU_TASK table cleaned after new Activiti war file deploy !

trademak — Wed, 01 Apr 2015 12:29:00 GMT

databaseSchemaUpdate set to true or false should never delete any data from the database.
Only create-drop would do this.

Best regards,

Re: ACT_RU_TASK table cleaned after new Activiti war file deploy !

gi00vani_kun — Tue, 07 Apr 2015 08:52:21 GMT

Indeed databaseSchemaUpdate set to true or false does not delete data from the database.

I've fixed the issue by upgrading activiti from 5.16.4 to 5.17

Cheers