-- 删除所有run开头的表
delete from act_ru_timer_job where 1=1;
delete from act_ru_job where 1=1;
delete from act_ru_identitylink where 1=1;
delete from act_ru_deadletter_job where 1=1;
delete from act_ru_event_subscr where 1=1;
delete from act_ru_suspended_job where 1=1;
delete from act_ru_history_job where 1=1;
delete from act_ru_actinst where 1=1;
delete from act_ru_variable where 1=1;
delete from act_ru_task where 1=1;
delete from act_ru_execution where 1=1;
-- 删除所有his开头的表
delete from act_hi_actinst where 1=1;
delete from act_hi_attachment where 1=1;
delete from act_hi_comment where 1=1;
delete from act_hi_detail where 1=1;
delete from act_hi_entitylink where 1=1;
delete from act_hi_identitylink where 1=1;
delete from act_hi_procinst where 1=1;
delete from act_hi_taskinst where 1=1;
delete from act_hi_tsk_log where 1=1;
delete from act_hi_varinst where 1=1;
-- 删除所有app开头的表
delete from act_app_appdef where 1=1;
delete from act_app_deployment_resource where 1=1;
delete from act_app_deployment where 1=1;
-- 删除所有from开头的表
delete from act_fo_form_definition where 1=1;
delete from act_fo_form_deployment where 1=1;
delete from act_fo_form_instance where 1=1;
delete from act_fo_form_resource where 1=1;
-- 删除所有de开头的表
delete from act_de_model_history where 1=1;
delete from act_de_model_relation where 1=1;
delete from act_de_model where 1=1;
-- 删除所有ge开头的表 (应该是设计流程图对应的内容)
delete from act_ge_bytearray where 1=1;
delete from act_ge_property where 1=1;
-- 删除所有re开头的表(实际部署的)
delete from act_re_deployment where 1=1;
delete from act_re_model where 1=1;
delete from act_re_procdef where 1=1;
-- 删除所有event的表
delete from flw_channel_definition where 1=1;
delete from flw_event_definition where 1=1;
delete from flw_event_deployment where 1=1;
delete from flw_event_resource where 1=1;
-- 删除所有co开头的表
delete from act_co_content_item where 1=1;
act_ge_property
表谨慎删除,否则会导致一下错误
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is java.lang.NullPointerException
dflow-all_1 | at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:176) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1884) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1284) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:345) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1380) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1300) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1 | ... 47 common frames omitted
dflow-all_1 | Caused by: java.lang.NullPointerException: null
dflow-all_1 | at org.flowable.engine.impl.db.ProcessDbSchemaManager.schemaUpdate(ProcessDbSchemaManager.java:232) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:54) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:28) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:67) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:140) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:114) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:72) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.interceptor.BpmnOverrideContextInterceptor.execute(BpmnOverrideContextInterceptor.java:26) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:105) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:57) ~[flowable-spring-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.12.jar:5.3.12]
dflow-all_1 | at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:57) ~[flowable-spring-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:83) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:914) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:76) ~[flowable-spring-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator.initProcessEngine(SpringProcessEngineConfigurator.java:58) ~[flowable-spring-configurator-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator.configure(SpringProcessEngineConfigurator.java:47) ~[flowable-spring-configurator-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1109) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.app.engine.AppEngineConfiguration.init(AppEngineConfiguration.java:237) ~[flowable-app-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1 | at org.flowable.app.engine.AppEngineConfiguration.buildAppEngine(AppEngineConfiguration.java:193) ~[flowable-app-engine-6.7.1.1.jar:6.7.1.