PT135994补丁执行脚本报错
389次浏览
编辑于2019年07月17日 14:18:33
PT135994补丁执行脚本报错错误原因:执行脚本出现错误,请仔细分析[解决方案]中的错误信息,并试图获取具体的错误原因。解决方案:请将如下错误信息提单反馈:[Execute provider[./sql/PT107870_fi_cpbc_table.sql], sql[DECLARE CNT PLS_INTEGER;BEGINSELECT COUNT(*) FCOUNT INTO CNT FROM T_BAS_Param WHERE fid = 'c6oAAABWt0CogfPn';IF CNT = 0 THENEXECUTE 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 (''c6oAAABWt0CogfPn'', NULL, ''false'', NULL, NULL, ''false'', NULL, NULL, N''参数值等于是时,费用报销单据申请人/报销人F7显示委托当前公司记账的行政组织下的所有人;为否,则显示本人及其代理的人员。默认为否。'', NULL, 0, NULL, N''申请人F7显示全公司职员'', NULL, ''CP044'', 0, 1, NULL, 1, ''00000000-0000-0000-0000-00000000000013B7DE7F'', TO_DATE(''2016-09-18 16:07:23'', ''YYYY-MM-DD HH24:MI:SS''), ''00000000-0000-0000-0000-00000000000013B7DE7F'', TO_DATE(''2016-09-18 16:07:23'', ''YYYY-MM-DD HH24:MI:SS''), ''c6oAAABWt0EbKFGT'', 3, ''com.kingdee.eas.cp.bc.bc'', NULL, 0, NULL, NULL, ''00000000-0000-0000-0000-000000000000CCE7AED4'')';END IF;END;] failed, sqlcode[1] sqlstat[23000],Causedby[ORA-00001: 违反唯一约束条件 (ZTEAS18.UX_BAS_PARAMNUM)ORA-06512: 在 line 5],DBType=[Oracle]]异常堆栈:com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./sql/PT107870_fi_cpbc_table.sql], sql[DECLARE CNT PLS_INTEGER;BEGINSELECT COUNT(*) FCOUNT INTO CNT FROM T_BAS_Param WHERE fid = 'c6oAAABWt0CogfPn';IF CNT = 0 THENEXECUTE 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 (''c6oAAABWt0CogfPn'', NULL, ''false'', NULL, NULL, ''false'', NULL, NULL, N''参数值等于是时,费用报销单据申请人/报销人F7显示委托当前公司记账的行政组织下的所有人;为否,则显示本人及其代理的人员。默认为否。'', NULL, 0, NULL, N''申请人F7显示全公司职员'', NULL, ''CP044'', 0, 1, NULL, 1, ''00000000-0000-0000-0000-00000000000013B7DE7F'', TO_DATE(''2016-09-18 16:07:23'', ''YYYY-MM-DD HH24:MI:SS''), ''00000000-0000-0000-0000-00000000000013B7DE7F'', TO_DATE(''2016-09-18 16:07:23'', ''YYYY-MM-DD HH24:MI:SS''), ''c6oAAABWt0EbKFGT'', 3, ''com.kingdee.eas.cp.bc.bc'', NULL, 0, NULL, NULL, ''00000000-0000-0000-0000-000000000000CCE7AED4'')';END IF;END;] failed, sqlcode[1] sqlstat[23000],Causedby[ORA-00001: 违反唯一约束条件 (ZTEAS18.UX_BAS_PARAMNUM)ORA-06512: 在 line 5],DBType=[Oracle] at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:3025) at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:4307) at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:4001) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46) at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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)
推荐阅读