[亿信BI4.7] 部署新环境报错

Error creating bean with name 'platform_bulletgroupmgr_factory' defined in file [/opt/apache-tomcat-8.5.82/webapps/BI/WEB-INF/classes/com/esen/platform/notice/BulletinGroupManagerFactory.class]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platform_bulletmgr_factory' defined in file [/opt/apache-tomcat-8.5.82/webapps/BI/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_))出现异常:Invalid default value for 'PUBTIME_'客户端环境：(Other) Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36客户端地址：http://139.196.34.52:8080/BI/esmain/error.do服务器版本：V4.7.1R133-build20180904153258-re964897
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platform_bulletgroupmgr_factory' defined in file [/opt/apache-tomcat-8.5.82/webapps/BI/WEB-INF/classes/com/esen/platform/notice/BulletinGroupManagerFactory.class]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platform_bulletmgr_factory' defined in file [/opt/apache-tomcat-8.5.82/webapps/BI/WEB-INF/classes/com/esen/platform/notice/BulletinManagerFactory.class]: Invocation of init method failed; nested exception is com.esen.jdbc.orm.ORMSQLException:
创建表:ES10_BULLETIN

CREATE 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_))

出现异常: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: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platform_bulletmgr_factory' defined in file [/opt/apache-tomcat-8.5.82/webapps/BI/WEB-INF/classes/com/esen/platform/notice/BulletinManagerFactory.class]: Invocation of init method failed; nested exception is com.esen.jdbc.orm.ORMSQLException:
创建表:ES10_BULLETIN

CREATE 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_))

出现异常: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:198)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1121)
at com.esen.platform.server.EsenServer.getBean(EsenServer.java:138)
at com.esen.platform.server.EsenServer.getLifecycleObject(EsenServer.java:192)
at com.esen.platform.server.EsenServer.getBulletinManager(EsenServer.java:506)
at com.esen.platform.notice.impl.BulletinGroupManagerImpl.<init>(BulletinGroupManagerImpl.java:99)
at com.esen.platform.notice.BulletinGroupManagerFactory.init(BulletinGroupManagerFactory.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 more
Caused by: com.esen.jdbc.orm.ORMSQLException:
创建表:ES10_BULLETIN

CREATE 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_))

出现异常: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)
... 35 more     

您可以参考一下帖子试试
https://bbs.esensoft.com/thread-138351-1-1.html
https://bbs.esensoft.com/thread-131010-1-1.html