配置mysql8外接数据库

配置外接数据库为mysql8，请参考FR帮助文档 配置MYSQL8外接数据库

已配置外接数据库为mysql8，但是没有按照FR帮助文档进行操作，导致出现以下异常

1. 经营任务-任务创建页面提交数据提示“数据保存失败”，经营任务-任务跟进、任务查询页面提示“数据获取失败”

   
   

2. 服务器无法启动，出现配置异常提示

方案一：

（仅限于工程当前为启动状态）

1.插件管理页面删除FineEPM插件

2.修改数据库字符集为utf8，排序规则为utf8_bin

3.插件管理页面重新安装FineEPM插件

方案二：

（工程启动或未启动均适用）

手动创建数据库表，建表语句见附件

DROP TABLE IF EXISTS `amb_manage_task`;

CREATE TABLE `amb_manage_task`  (

  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `sortId` bigint(0) NOT NULL,

  `allocationDepartCodes` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `beginDate` datetime(0) NOT NULL,

  `endDate` datetime(0) NOT NULL,

  `generation` varchar(3000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `improve` varchar(3000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `principal` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `principalDepartCode` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `progress` double NOT NULL,

  `recordDate` datetime(0) NOT NULL,

  `recorder` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `remark` varchar(3000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `strategy` varchar(3000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `target` varchar(3000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

  `taskId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `taskName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  `taskTypeCode` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `UK_mbn32vqwrvdcoe5vsod5l3g6y`(`sortId`) USING BTREE,

  UNIQUE INDEX `UK_bnrbb0qoj7d6bifb564ds4npg`(`taskId`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;