PT099948制造补丁安装报错?
金蝶云社区-云社区用户ScqD2202
云社区用户ScqD2202
0人赞赏了该文章 953次浏览 未经作者许可,禁止转载编辑于2016年12月17日 22:28:42
EAS8.0安装PT099948补丁报错,错误信息如下:
错误原因:
执行脚本出现错误,请仔细分析[解决方案]中的错误信息,并试图获取具体的错误原因。
解决方案:
请将如下错误信息提单反馈:
[Execute provider[./sql/PT099948_mm_basedata_data.sql], sql[DECLARE CNT PLS_INTEGER;
BEGIN
SELECT COUNT(*) FCOUNT INTO CNT FROM t_mm_tracknumbergroup WHERE fid = 'EOMAAAAM4ODZJgxC';
IF CNT = 0 THEN
EXECUTE IMMEDIATE 'INSERT INTO t_mm_tracknumbergroup (FIsLeaf, FLevel, FLongNumber, FDisplayName_l1, FDisplayName_l2, FDisplayName_l3, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FID, FParentID) VALUES (0, 1, ''默认跟踪号组'', NULL, ''默认跟踪号组'', ''默認跟蹤號組'', NULL, ''默认跟踪号组'', ''默認跟蹤號組'', ''默认跟踪号组'', NULL, NULL, NULL, NULL, ''256c221a-0106-1000-e000-10d7c0a813f413B7DE7F'', TO_DATE(''2012-03-26 15:54:08'', ''YYYY-MM-DD HH24:MI:SS''), ''0O7YVTUVQsyoNvL0ohIQDBO33n8='', TO_DATE(''2012-03-26 19:04:43'', ''YYYY-MM-DD HH24:MI:SS''), ''00000000-0000-0000-0000-000000000000CCE7AED4'', ''EOMAAAAM4ODZJgxC'', NULL)';
END IF;
END;] failed, sqlcode[6550] sqlstat[65000],Causedby[ORA-06550: 第 3 行, 第 38 列:
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 3 行, 第 1 列:
PL/SQL: SQL Statement ignored
],DBType=[Oracle]
]
异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./sql/PT099948_mm_basedata_data.sql], sql[DECLARE CNT PLS_INTEGER;
BEGIN
SELECT COUNT(*) FCOUNT INTO CNT FROM t_mm_tracknumbergroup WHERE fid = 'EOMAAAAM4ODZJgxC';
IF CNT = 0 THEN
EXECUTE IMMEDIATE 'INSERT INTO t_mm_tracknumbergroup (FIsLeaf, FLevel, FLongNumber, FDisplayName_l1, FDisplayName_l2, FDisplayName_l3, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FID, FParentID) VALUES (0, 1, ''默认跟踪号组'', NULL, ''默认跟踪号组'', ''默認跟蹤號組'', NULL, ''默认跟踪号组'', ''默認跟蹤號組'', ''默认跟踪号组'', NULL, NULL, NULL, NULL, ''256c221a-0106-1000-e000-10d7c0a813f413B7DE7F'', TO_DATE(''2012-03-26 15:54:08'', ''YYYY-MM-DD HH24:MI:SS''), ''0O7YVTUVQsyoNvL0ohIQDBO33n8='', TO_DATE(''2012-03-26 19:04:43'', ''YYYY-MM-DD HH24:MI:SS''), ''00000000-0000-0000-0000-000000000000CCE7AED4'', ''EOMAAAAM4ODZJgxC'', NULL)';
END IF;
END;] failed, sqlcode[6550] sqlstat[65000],Causedby[ORA-06550: 第 3 行, 第 38 列:
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 3 行, 第 1 列:
PL/SQL: SQL Statement ignored
],DBType=[Oracle]
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:2967)
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:4190)
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:3884)
at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
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)