8.2升级到8.5执行补丁脚本报错
执行补丁脚本报错如下:
[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执行补丁脚本报错
本文2024-09-22 19:16:35发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-106174.html