82升级85提示ORA-00001: 违反唯一约束条件
金蝶云社区-广分黄乐
广分黄乐
0人赞赏了该文章 1,698次浏览 未经作者许可,禁止转载编辑于2019年01月17日 17:04:15

错误原因:
执行脚本出现错误,脚本所在路径[/kingdee/kingdee85/eas/server/properties/upgradescript/eas/8_2_0to8_5_0/8_5_0_feature/eas/sem/tbg/pubdata/datatask/PT106715_19_budget_synchro.ksql]

解决方案:
请将如下错误信息提单反馈:
[Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./sem/./tbg/./pubdata/./datatask/.\PT106715_19_budget_synchro.ksql], sql[DECLARE CNT PLS_INTEGER;
BEGIN
SELECT COUNT(*) FCOUNT INTO CNT FROM t_bas_param WHERE FID = '8r0AAAAHffmogfPn';
IF CNT = 0 THEN
EXECUTE IMMEDIATE 'INSERT INTO t_bas_param (FID, FDefaultVal_L1, FDefaultVal_L2, FDefaultVal_L3, FValueAlias_L1, FValueAlias_L2, FValueAlias_L3, FDesc_L1, FDesc_L2, FDesc_L3, FIsUserDefined, FName_L1, FName_L2, FName_L3, FNumber, FIsGroupControl, FCanBeModified, FDefaultVal, FOrgType, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FValueRange, FDataType, FSubSysID, FBaseType, FUserEdit, FUserClass, FValueAlias, FControlUnitID) VALUES (N''8r0AAAAHffmogfPn'', N''false'', N''false'', N''false'', N''false'', N''false'', N''false'', N''合并预算报表是否启用本级审批和上报确认'', N''合并预算报表是否启用本级审批和上报确认'', N''合并预算报表是否启用本级审批和上报确认'', 0, N''合并预算报表是否启用本级审批和上报确认'', N''合并预算报表是否启用本级审批和上报确认'', N''合并预算报表是否启用本级审批和上报确认'', N''BG067'', 1, 0, NULL, -1, ''00000000-0000-0000-0000-00000000000013B7DE7F'', TO_DATE(''2015-01-28 13:33:49'', ''YYYY-MM-DD HH24:MI:SS''), ''00000000-0000-0000-0000-00000000000013B7DE7F'', TO_DATE(''2015-01-28 13:33:49'', ''YYYY-MM-DD HH24:MI:SS''), N''8r0AAAAHffobKFGT'', 3, N''com.kingdee.eas.stm.bg.bg'', NULL, 0, NULL, NULL, ''00000000-0000-0000-0000-000000000000CCE7AED4'')';
END IF;
END;] failed, sqlcode[1] sqlstat[23000],Causedby[ORA-00001: 违反唯一约束条件 (AY.UX_BAS_PARAMNUM)
ORA-06512: 在 line 5
]]

异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./eas/8_2_0to8_5_0/./8_5_0_feature/./eas/./sem/./tbg/./pubdata/./datatask/.\PT106715_19_budget_synchro.ksql], sql[DECLARE CNT PLS_INTEGER;
BEGIN
SELECT COUNT(*) FCOUNT INTO CNT FROM t_bas_param WHERE FID = '8r0AAAAHffmogfPn';
IF CNT = 0 THEN
EXECUTE IMMEDIATE 'INSERT INTO t_bas_param (FID, FDefaultVal_L1, FDefaultVal_L2, FDefaultVal_L3, FValueAlias_L1, FValueAlias_L2, FValueAlias_L3, FDesc_L1, FDesc_L2, FDesc_L3, FIsUserDefined, FName_L1, FName_L2, FName_L3, FNumber, FIsGroupControl, FCanBeModified, FDefaultVal, FOrgType, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FValueRange, FDataType, FSubSysID, FBaseType, FUserEdit, FUserClass, FValueAlias, FControlUnitID) VALUES (N''8r0AAAAHffmogfPn'', N''false'', N''false'', N''false'', N''false'', N''false'', N''false'', N''合并预算报表是否启用本级审批和上报确认'', N''合并预算报表是否启用本级审批和上报确认'', N''合并预算报表是否启用本级审批和上报确认'', 0, N''合并预算报表是否启用本级审批和上报确认'', N''合并预算报表是否启用本级审批和上报确认'', N''合并预算报表是否启用本级审批和上报确认'', N''BG067'', 1, 0, NULL, -1, ''00000000-0000-0000-0000-00000000000013B7DE7F'', TO_DATE(''2015-01-28 13:33:49'', ''YYYY-MM-DD HH24:MI:SS''), ''00000000-0000-0000-0000-00000000000013B7DE7F'', TO_DATE(''2015-01-28 13:33:49'', ''YYYY-MM-DD HH24:MI:SS''), N''8r0AAAAHffobKFGT'', 3, N''com.kingdee.eas.stm.bg.bg'', NULL, 0, NULL, NULL, ''00000000-0000-0000-0000-000000000000CCE7AED4'')';
END IF;
END;] failed, sqlcode[1] sqlstat[23000],Causedby[ORA-00001: 违反唯一约束条件 (AY.UX_BAS_PARAMNUM)
ORA-06512: 在 line 5
]
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:845)
at com.kingdee.eas.tools.admin.domain.upgrade.UpdateDCParser.run(UpdateDCParser.java:659)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:4139)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3521)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3762)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
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)