我的位置：首页 › 大数据分析-亿信BI › BI-问题求助 › 注册成功后，重启发生错误

[亿信BI4.7] 注册成功后，重启发生错误

复制链接 | 收藏本帖

4942

: 4000011866 初学数据Lv2

发表于2021-1-7 18:09

悬赏1

已解决

楼主

Error creating bean with name 'platform_bulletmgr_factory' defined in file [/usr/share/apache-tomcat-8.5.61/webapps/BI@ReportV4.7.1R222_20190613110352/WEB-INF/classes/com/esen/platform/notice/BulletinManagerFactory.class]: Invocation of init method failed; nested exception is com.esen.jdbc.orm.ORMSQLException: 创建表:ES10_BULLETINCREATE TABLE ES10_BULLETIN(ID_ VARCHAR(50) BINARY NOT NULL ,TITLE_ VARCHAR(100) BINARY NOT NULL ,CONTENT_ MEDIUMTEXT NOT NULL ,CONTENTNOSTYLE_ MEDIUMTEXT NOT NULL ,ONTOP_ VARCHAR(1) NOT NULL ,ONTOPTIME_ DATETIME NULL ,ONTOPCHANGETIME_ DATETIME NULL ,PUBTIME_ DATETIME DEFAULT 0 NOT NULL ,PUBLISHER_ VARCHAR(50) BINARY NOT NULL ,GID_ VARCHAR(50) BINARY NULL ,PRIMARY KEY (ID_)) row_format = compressed出现异常:Invalid default value for 'PUBTIME_'客户端环境：(Other) Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66客户端地址：http://192.168.56.30:8080/BI@ReportV4.7.1R222_20190613110352/esmain/error.do服务器版本：V4.7.1R222-build20190613110352-rda51fb5org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platform_bulletmgr_factory' defined in file [/usr/share/apache-tomcat-8.5.61/webapps/BI@ReportV4.7.1R222_20190613110352/WEB-INF/classes/com/esen/platform/notice/BulletinManagerFactory.class]: Invocation of init method failed; nested exception is com.esen.jdbc.orm.ORMSQLException:创建表:ES10_BULLETINCREATE TABLE ES10_BULLETIN(ID_ VARCHAR(50) BINARY NOT NULL ,TITLE_ VARCHAR(100) BINARY NOT NULL ,CONTENT_ MEDIUMTEXT NOT NULL ,CONTENTNOSTYLE_ MEDIUMTEXT NOT NULL ,ONTOP_ VARCHAR(1) NOT NULL ,ONTOPTIME_ DATETIME NULL ,ONTOPCHANGETIME_ DATETIME NULL ,PUBTIME_ DATETIME DEFAULT 0 NOT NULL ,PUBLISHER_ VARCHAR(50) BINARY NOT NULL ,GID_ VARCHAR(50) BINARY NULL ,PRIMARY KEY (ID_)) row_format = compressed出现异常:Invalid default value for 'PUBTIME_'at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1482)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:626)at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389)at com.esen.platform.server.setup.ServerSetupContextLoader.configureAndRefreshWebApplicationContext(ServerSetupContextLoader.java:38)at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294)at com.esen.platform.server.ServerController.startContextListener(ServerController.java:331)at com.esen.platform.server.ServerController.restart(ServerController.java:234)at com.esen.platform.sysmgr.ManagerNode.restartServer(ManagerNode.java:280)at com.esen.platform.sysmgr.ManagerNode$1.run(ManagerNode.java:295)Caused by: com.esen.jdbc.orm.ORMSQLException:创建表:ES10_BULLETINCREATE TABLE ES10_BULLETIN(ID_ VARCHAR(50) BINARY NOT NULL ,TITLE_ VARCHAR(100) BINARY NOT NULL ,CONTENT_ MEDIUMTEXT NOT NULL ,CONTENTNOSTYLE_ MEDIUMTEXT NOT NULL ,ONTOP_ VARCHAR(1) NOT NULL ,ONTOPTIME_ DATETIME NULL ,ONTOPCHANGETIME_ DATETIME NULL ,PUBTIME_ DATETIME DEFAULT 0 NOT NULL ,PUBLISHER_ VARCHAR(50) BINARY NOT NULL ,GID_ VARCHAR(50) BINARY NULL ,PRIMARY KEY (ID_)) row_format = compressed出现异常:Invalid default value for 'PUBTIME_'at com.esen.jdbc.orm.helper.EntityAdvFunc.repairTable(EntityAdvFunc.java:57)at com.esen.jdbc.orm.helper.EntityAdvFunc.repairTable(EntityAdvFunc.java:38)at com.esen.platform.notice.impl.BulletinManagerImpl.repairTable(BulletinManagerImpl.java:116)at com.esen.platform.notice.impl.BulletinManagerImpl.<init>(BulletinManagerImpl.java:109)at com.esen.platform.notice.BulletinManagerFactory.init(BulletinManagerFactory.java:38)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1608)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1549)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1479)... 16 moreCaused by: com.esen.jdbc.pool.PooledSQLException: 创建表:ES10_BULLETINCREATE TABLE ES10_BULLETIN(ID_ VARCHAR(50) BINARY NOT NULL ,TITLE_ VARCHAR(100) BINARY NOT NULL ,CONTENT_ MEDIUMTEXT NOT NULL ,CONTENTNOSTYLE_ MEDIUMTEXT NOT NULL ,ONTOP_ VARCHAR(1) NOT NULL ,ONTOPTIME_ DATETIME NULL ,ONTOPCHANGETIME_ DATETIME NULL ,PUBTIME_ DATETIME DEFAULT 0 NOT NULL ,PUBLISHER_ VARCHAR(50) BINARY NOT NULL ,GID_ VARCHAR(50) BINARY NULL ,PRIMARY KEY (ID_)) row_format = compressed出现异常:Invalid default value for 'PUBTIME_'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:406)at com.mysql.jdbc.Util.getInstance(Util.java:381)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)at com.esen.jdbc.pool.PooledStatement.executeUpdate(PooledStatement.java:116)at com.esen.jdbc.dialect.impl.DbDef.createTableForDefine(DbDef.java:1739)at com.esen.jdbc.dialect.impl.DbDef.createTableNotChangeTableName(DbDef.java:1625)at com.esen.jdbc.dialect.impl.DbDef.createTableForMultithread(DbDef.java:1418)at com.esen.jdbc.dialect.impl.DbDef.createTable(DbDef.java:1577)at com.esen.jdbc.dialect.impl.DbDef.createTable(DbDef.java:315)at com.esen.jdbc.dialect.impl.EasyDbDefiner.createTable(EasyDbDefiner.java:226)at com.esen.jdbc.dialect.impl.EasyDbDefiner.repairTable(EasyDbDefiner.java:200)at com.esen.jdbc.dialect.impl.DbDef.repairTable(DbDef.java:345)at com.esen.jdbc.dialect.impl.DbDef.repairTable(DbDef.java:335)at com.esen.jdbc.orm.helper.EntityAdvFunc.repairTable(EntityAdvFunc.java:52)... 27 more

复制代码