急!新建数据中心后升级后报错
金蝶云社区-letgoit_letgoit
letgoit_letgoit
1人赞赏了该文章 723次浏览 未经作者许可,禁止转载编辑于2015年11月24日 16:01:02

操作步骤,在5.0的环境上面创造数据中心,完成后点升级,升级完后出现报错.
补丁环境:PT100116
如图:

Error: [2015-11-24 15:37:54] 执行脚本[PT099001_K3CloudV5.0_ECM_Data.sql(CP_DataModel_5_0)](HV:0.001,CHECK:0.0020001,RESULT:False,RUN:0.3000171,ERROR)
---脚本错误Begin---
SQL脚本错误:IF NOT EXISTS (SELECT 1 FROM T_BAS_SCHEDULEINFO WHERE FSCHEDULEID = '55dc2863b5078a')
INSERT INTO T_BAS_SCHEDULEINFO(FSCHEDULEID,FSCHEDULETYPEID,FEXECUTEINTERVAL,FEXECUTEINTERVALUNIT,FEXECUTETIME,FBEGINTIME,FENDTIME,FISASYNCJOB,FSTATUS,FCREATETIME,FCREATEUSERID,FPARAMETERFORMID,FPARAMETERS,FNOTES) VALUES ('55dc2863b5078a','55dc2863b50788',3,'1',{ts'2015-08-25 00:00:00'},{ts'2015-08-25 00:00:00'},{ts'9998-12-31 00:00:00'},'0','0',null,null,' ',N' ',N' ')
列名 'FNOTES' 无效。
---脚本错误End---
Error: [2015-11-24 15:37:54] 执行脚本[PT099723_K3CloudV5.0_ECM_Data.sql(CP_DataModel_5_0)](HV:0,CHECK:0.0010001,RESULT:False,RUN:0.0250014,ERROR)
---脚本错误Begin---
SQL脚本错误:IF NOT EXISTS (SELECT 1 FROM T_BAS_SCHEDULEINFO WHERE FSCHEDULEID = '55dc2863b5078a')
INSERT INTO T_BAS_SCHEDULEINFO(FSCHEDULEID,FSCHEDULETYPEID,FEXECUTEINTERVAL,FEXECUTEINTERVALUNIT,FEXECUTETIME,FBEGINTIME,FENDTIME,FISASYNCJOB,FSTATUS,FCREATETIME,FCREATEUSERID,FPARAMETERFORMID,FPARAMETERS,FNOTES) VALUES ('55dc2863b5078a','55dc2863b50788',3,'1',{ts'2015-08-25 00:00:00'},{ts'2015-08-25 00:00:00'},{ts'9998-12-31 00:00:00'},'0','0',null,null,' ',N' ',N' ')
列名 'FNOTES' 无效。
---脚本错误End---