# Disable Flowable Table auto create and manually run the scripts

**URL:** <https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601>\
**Category:** Uncategorized\
**Created:** [August 26, 2020, 2:09pm UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601 "2020-08-26T14:09:56Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![joyal.joy777](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joyal.joy777/32/1791_2.png) [@joyal.joy777](https://forum.flowable.org/u/joyal.joy777)\
**Post date:** [August 26, 2020, 2:09pm UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/1 "2020-08-26T14:09:57Z")

</div>

Hi Guys,

We have requirement for our processEngine which is to seperate out the Flowable schema script files and manually run the scripts. If any Flowable upgrade happens, then we should manually run those upgrade sql files and the Flowable should not upgrade the tables using liquibase. So I have tried to include **config.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB\_SCHEMA\_UPDATE\_FALSE);** in processEngine configuration. I expect if config is DB\_SCHEMA\_UPDATE\_FALSE, then version check only should happen and version mismatch is there, then an error will throw and engine should not start. But this config is not working as expected. Irrespective of true or false for this config, it is running the scripts and creating the new tables for the flowable upgrade.

How I can achieve this isolation of scripts and restricting flowable to upgrade the schemas. Is there any additional configurations required? I am using Flowable 6.5.0.

Thanks…

---

<div class="post-metadata">

**Author:** ![fiki574](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/fiki574/32/1675_2.png) [@fiki574](https://forum.flowable.org/u/fiki574)\
**Post date:** [August 27, 2020, 6:51am UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/2 "2020-08-27T06:51:41Z")

</div>

Hey.

You sure it doesn’t work? Last time I checked, it did work for me, both FALSE and TRUE versions respecitvely.

```
  @Bean
  public EngineConfigurationConfigurer<SpringProcessEngineConfiguration> processEngineConfigurer() {
    return configuration -> {
      configuration.setDataSource(dataSource);
      configuration.setTransactionManager(transactionManager);
      configuration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE);
      configuration.setHistoryLevel(HistoryLevel.FULL);
    };
  }
```

---

<div class="post-metadata">

**Author:** ![joyal.joy777](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joyal.joy777/32/1791_2.png) [@joyal.joy777](https://forum.flowable.org/u/joyal.joy777)\
**Post date:** [August 27, 2020, 7:22am UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/3 "2020-08-27T07:22:40Z")

</div>

Hai @fiki574,

No it is not working. I am using the following configuration.

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/flowable/original/2X/d/d9ca227ba70467082b87c4de1fe460b3306d8571.png)

My current flowable version is 6.4.0 and I am trying to upgrade to 6.5.0. The cofig **setDatabaseSchemaUpdate** is set to false and I am expecting to get an error due to version mismatch. Instead it is updating the tables. Is anything wrong with the configuration?

Thanks…

---

<div class="post-metadata">

**Author:** ![fiki574](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/fiki574/32/1675_2.png) [@fiki574](https://forum.flowable.org/u/fiki574)\
**Post date:** [August 27, 2020, 7:42am UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/4 "2020-08-27T07:42:32Z")

</div>

Okay, try adding this:

```
@Configuration
@ConditionalOnAppEngine //<---
public class FlowableConfiguration
...

```

And do the bean configuration with usage of EngineConfigurationConfigurer, just like I did up above. It doesn’t work for you because you’re not properly doing it.

---

<div class="post-metadata">

**Author:** ![joyal.joy777](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joyal.joy777/32/1791_2.png) [@joyal.joy777](https://forum.flowable.org/u/joyal.joy777)\
**Post date:** [August 27, 2020, 7:55am UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/5 "2020-08-27T07:55:05Z")

</div>

Hi @fiki574

I have tried with this configuration also… Still not working… It is updating the tables…

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/flowable/original/2X/3/3ca6c6edc17476be38a030d777e3f72020312218.png)

Thanks…

---

<div class="post-metadata">

**Author:** ![fiki574](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/fiki574/32/1675_2.png) [@fiki574](https://forum.flowable.org/u/fiki574)\
**Post date:** [August 27, 2020, 7:58am UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/6 "2020-08-27T07:58:59Z")

</div>

I don’t know what’s the problem here then, the following thread contains all other snippets I needed to get it working: [Spring Boot integration with a differnet database](https://forum.flowable.org/t/spring-boot-integration-with-a-differnet-database/5993/2)

---

<div class="post-metadata">

**Author:** ![joyal.joy777](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joyal.joy777/32/1791_2.png) [@joyal.joy777](https://forum.flowable.org/u/joyal.joy777)\
**Post date:** [August 27, 2020, 9:12am UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/7 "2020-08-27T09:12:17Z")

</div>

Thanks @fiki574. I will try furthur…

---

<div class="post-metadata">

**Author:** ![filiphr](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/filiphr/32/315_2.png) [@filiphr](https://forum.flowable.org/u/filiphr)\
**Post date:** [September 1, 2020, 2:17pm UTC](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/8 "2020-09-01T14:17:51Z")

</div>

Hey @joyal.joy777,

Why do you need to have `@Primary` on the process engine configuration that you are creating? If there is another engine configuration then it is most likely the cause for the problem.

The solution provided by @fiki574 in [Disable Flowable Table auto create and manually run the scripts](https://forum.flowable.org/t/disable-flowable-table-auto-create-and-manually-run-the-scripts/6601/2) is the way to go.

Cheers,  
Filip