操作步骤,在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---