1.5升级到2.0失败
shr从1.5升级到2.0,升级失败,是什么原因呢?
com.kingdee.eas.tools.admin.domain.DomainException: Upgrade table error, errorList=[shr_objectives]
cause by java.lang.Exception: com.kingdee.eas.tools.admin.domain.DomainException: Upgrade table error, subSystemName=shr_objectives
cause by com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./shr/1_5_0to2_0_0/./s_HR/./shr_objectives/.\create_table.sql], sql[CREATE TABLE T_PF_Task (FTaskContent NVARCHAR (2000) COLLATE Chinese_PRC_CS_AS, FTaskState INT DEFAULT 0, FTargetID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FPlanDate DATETIME, FCompleteDate DATETIME, FResponsiblePersonID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FResponsiblePersonORGID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FResponsiblePersonPositionID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FAssignedID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FAssignedPersonORGID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FAssignedPersonPositionID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FOthers NVARCHAR (2000) COLLATE Chinese_PRC_CS_AS, FTaskType INT DEFAULT 0, FOpenId VARCHAR (200) COLLATE Chinese_PRC_CS_AS, FWeichatID VARCHAR (200) COLLATE Chinese_PRC_CS_AS, FIsAssigned INT DEFAULT 0, FPriorityLV INT, FName_l1 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FName_l2 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FName_l3 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FNumber VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FDescription_l1 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FDescription_l2 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FDescription_l3 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FSimpleName NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FCreatorID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FCreateTime DATETIME, FLastUpdateUserID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FLastUpdateTime DATETIME, FControlUnitID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FID VARCHAR (44) COLLATE Chinese_PRC_CS_AS NOT NULL DEFAULT '', CONSTRAINT PK_Task PRIMARY KEY (FID))] failed, sqlcode[2714] sqlstat[42S01],Causedby[数据库中已存在名为 'PK_Task' 的对象。]
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:627)
at com.kingdee.eas.tools.admin.domain.db.UpdateDCParser.run(UpdateDCParser.java:495)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:3683)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3147)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3331)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
at com.kingdee.eas.tools.admin.domain.db.UpdateDCParser.run(UpdateDCParser.java:499)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:3683)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3147)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3331)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
at com.kingdee.eas.tools.admin.domain.db.UpdateDCParser.run(UpdateDCParser.java:517)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:3683)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3147)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3331)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
at com.kingdee.eas.tools.admin.domain.db.UpdateDCParser.run(UpdateDCParser.java:518)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:3683)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3147)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3331)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./shr/1_5_0to2_0_0/./s_HR/./shr_objectives/.\create_table.sql], sql[CREATE TABLE T_PF_Task (FTaskContent NVARCHAR (2000) COLLATE Chinese_PRC_CS_AS, FTaskState INT DEFAULT 0, FTargetID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FPlanDate DATETIME, FCompleteDate DATETIME, FResponsiblePersonID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FResponsiblePersonORGID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FResponsiblePersonPositionID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FAssignedID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FAssignedPersonORGID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FAssignedPersonPositionID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FOthers NVARCHAR (2000) COLLATE Chinese_PRC_CS_AS, FTaskType INT DEFAULT 0, FOpenId VARCHAR (200) COLLATE Chinese_PRC_CS_AS, FWeichatID VARCHAR (200) COLLATE Chinese_PRC_CS_AS, FIsAssigned INT DEFAULT 0, FPriorityLV INT, FName_l1 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FName_l2 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FName_l3 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FNumber VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FDescription_l1 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FDescription_l2 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FDescription_l3 NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FSimpleName NVARCHAR (255) COLLATE Chinese_PRC_CS_AS, FCreatorID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FCreateTime DATETIME, FLastUpdateUserID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FLastUpdateTime DATETIME, FControlUnitID VARCHAR (44) COLLATE Chinese_PRC_CS_AS, FID VARCHAR (44) COLLATE Chinese_PRC_CS_AS NOT NULL DEFAULT '', CONSTRAINT PK_Task PRIMARY KEY (FID))] failed, sqlcode[2714] sqlstat[42S01],Causedby[数据库中已存在名为 'PK_Task' 的对象。]
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:627)
at com.kingdee.eas.tools.admin.domain.db.UpdateDCParser.run(UpdateDCParser.java:495)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:3683)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3147)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3331)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
麻烦提供一下最新的报错日志,谢谢
1.5升级到2.0失败
本文2024-09-17 01:04:43发表“s-hr cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-shr-65098.html