主题 : jeecmsx 1.2 商业授权版 启动报错
级别: 解元
UID: 127187
积分:209 加为好友
威望: 0 精华: 0
主题:14 回复:142
注册时间:2018-12-10
在线时长:0
1#   发表于:2020-04-22 11:34:17  IP:221.100.*.*
 Caused by: org.flowable.common.engine.api.FlowableWrongDbException: version mismatch: library version is '6.5.0.1', db version is 5.99.0.0 Hint: Set <property name="databaseSchemaUpdate" to value="true" or value="create-drop" (use create-drop for testing only!) in bean processEngineConfiguration in flowable.cfg.xml for automatic schema creation                                                                                                                                        at org.flowable.idm.engine.impl.db.IdmDbSchemaManager.schemaCheckVersion(IdmDbSchemaManager.java:77)                                                                                                                                         at org.flowable.idm.engine.impl.db.IdmDbSchemaManager.performSchemaOperationsIdmEngineBuild(IdmDbSchemaManager.java:148)                                                                                                                     at org.flowable.idm.engine.impl.SchemaOperationsIdmEngineBuild.execute(SchemaOperationsIdmEngineBuild.java:29)                                                                                                                               at org.flowable.idm.engine.impl.SchemaOperationsIdmEngineBuild.execute(SchemaOperationsIdmEngineBuild.java:24)                                                                                                                               at org.flowable.common.engine.impl.interceptor.DefaultCommandInvoker.execute(DefaultCommandInvoker.java:22)                                                                                                                                  at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53)                                                                                                                  at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:72)                                                                                                                          at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)                                                                                                                                                at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)                                                                                                                                              at org.flowable.idm.engine.impl.IdmEngineImpl.<init>(IdmEngineImpl.java:45)                                                                                                                                                                  at org.flowable.idm.engine.IdmEngineConfiguration.buildIdmEngine(IdmEngineConfiguration.java:166)                                                                                                                                            at org.flowable.idm.engine.configurator.IdmEngineConfigurator.configure(IdmEngineConfigurator.java:57)                                                                                                                                       at org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:904)                                                                                                                  at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:1016)                                                                                                                                at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:915)                                                                                                                   at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:72)                                                                                                                         at org.flowable.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:60)                                                                                                                                                  at org.flowable.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)                                                                                                                                                  at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:171)                                                                                                      ... 335 more                                                                                                                                           
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
2#   发表于:2020-04-22 11:38:59  IP:59.51.*.*
您这个是工作流的功能报错  您可以开启下项目里数据库的自更新功能 
每天告诉自己一次,“我真的很不错”。
级别: 解元
UID: 127187
积分:209 加为好友
威望: 0 精华: 0
主题:14 回复:142
注册时间:2018-12-10
在线时长:0
3#   发表于:2020-04-22 13:42:07  IP:221.100.*.*
flowable.database-schema-update=true 这里是么
级别: 解元
UID: 127187
积分:209 加为好友
威望: 0 精华: 0
主题:14 回复:142
注册时间:2018-12-10
在线时长:0
4#   发表于:2020-04-22 13:43:05  IP:221.100.*.*
数据库中是否所有`act_`开头的表都需要删掉
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
5#   发表于:2020-04-22 13:44:41  IP:59.51.*.*
不用删除数据库  您只要改哪个配置参数就可以了
每天告诉自己一次,“我真的很不错”。
级别: 解元
UID: 127187
积分:209 加为好友
威望: 0 精华: 0
主题:14 回复:142
注册时间:2018-12-10
在线时长:0
6#   发表于:2020-04-22 13:49:04  IP:221.100.*.*
改了之后,jpa会自动创建些Flowable相关的表 例如 `ACT_HI_ACTINST`,回和之前小写的表冲突 ,这块需要改哪里的配置呢。
级别: 解元
UID: 127187
积分:209 加为好友
威望: 0 精华: 0
主题:14 回复:142
注册时间:2018-12-10
在线时长:0
7#   发表于:2020-04-22 13:50:00  IP:221.100.*.*
这个错误应该也和大小写有关

Exception in thread "Quartz Scheduler [schedulerFactoryBean]" org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler after delay; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'jeecmsx.1.2.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecmsx.1.2.QRTZ_LOCKS' doesn't exist]]                                                                                                                                                                                                  at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:733)                                                                                                                                   Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'jeecmsx.1.2.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecmsx.1.2.QRTZ_LOCKS' doesn't exist]]                                                                                                                              at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:697)                                                                                                                                                   at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:539)                                                                                                                                                                           at org.quartz.impl.StdScheduler.start(StdScheduler.java:142)                                                                                                                                                                                 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:730)                                                                                                                                   Caused by: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'jeecmsx.1.2.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecmsx.1.2.QRTZ_LOCKS' doesn't exist]                                                                                                                                                                                                                                at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157)                                                                                                                                                 at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)                                                                                                                                                                 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3842)                                                                                                                                         at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:839)                                                                                                                                                        at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:695)                                                                                                                                                   ... 3 more                                                                                                                                                                                                                           Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jeecmsx.1.2.QRTZ_LOCKS' doesn't exist                                                                                                                                   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)                                                                                                                                                                     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)                                                                                                                                              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)                                                                                                                                      at java.lang.reflect.Constructor.newInstance(Constructor.java:423)                                                                                                                                                                           at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)                                                                                                                                                                                      at com.mysql.jdbc.Util.getInstance(Util.java:408)                                                                                                                                                                                            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)                                                                                                                                                                             at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)                                                                                                                                                                                at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)                                                                                                                                                                                at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)                                                                                                                                                                                     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)                                                                                                                                                                                  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)                                                                                                                                                                           at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)                                                                                                                                                             at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)                                                                                                                                                                at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)                                                                                                                                                at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)                                                                                                                                       at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96)                                                                                                                                                  ... 7 more 
级别: 论坛管理员
UID: 122721
积分:57884 加为好友
威望: 2 精华: 1
主题:5 回复:50085
注册时间:2018-05-07
在线时长:0
8#   发表于:2020-04-22 13:50:35  IP:59.51.*.*
只需要忽略数据库的大写写就可以了
每天告诉自己一次,“我真的很不错”。
1 共1页