8.2升级到8.5执行补丁脚本报错

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-22浏览:1

8.2升级到8.5执行补丁脚本报错

1 问题描述

执行补丁脚本报错如下:


[com.kingdee.eas.tools.admin.domain.DomainException: Upgrade datacenter error, dcNum=CS001

cause by java.lang.Exception: com.kingdee.eas.tools.admin.domain.DomainException: Upgrade data error, subSystemName=eas-fi-vc

cause by com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./fi/./vc/.\EAS8.5_fi_vc_data_init.sql], sql[DECLARE CNT PLS_INTEGER;

BEGIN

SELECT COUNT(*) FCOUNT INTO CNT FROM t_vc_subsystem WHERE (FSEQ = 6 AND FSUBSYSTEM = 2);

IF CNT = 0 THEN

EXECUTE IMMEDIATE 'INSERT INTO t_vc_subsystem (FSEQ, FSUBSYSTEM, FNEEDRALTEACCOUNT) VALUES (6, 2, 0)';

END IF;

END;] failed, sqlcode[1] sqlstat[23000],Causedby[ORA-00001: 违反唯一约束条件 (EAS202403.PK_VC_SUBSYSTEM)

2 解决方法

先执行备份脚本

SELECT * into t_vc_subsystem_bas FROM  t_vc_subsystem

删除有问题的数据

 delete FROM t_vc_subsystem where FSUBSYSTEM =2

 注意事项(可选)

  • 操作完成后重新执行补丁脚本即可





8.2升级到8.5执行补丁脚本报错

1 问题描述执行补丁脚本报错如下:[com.kingdee.eas.tools.admin.domain.DomainException: Upgrade datacenter error, dcNum=CS001cau...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息