S-HR8.2打PTM106652时候显示脚本执行错误,打完显示补丁已安装,然后按照《关于金蝶s-HR V8.2SP1安装问题的补充说明》这篇文档,重新下载替换,安装对的时候显示脚本执行失败。
错误原因:
执行脚本出现错误,请仔细分析[解决方案]中的错误信息,并试图获取具体的错误原因。
解决方案:
请将如下错误信息提单反馈:
[Execute provider[sql/8_2_0to8_5_0/s_HR/syssetting/forewarn_template_config.sql], sql[INSERT INTO t_fw_forewarnitem (FID, FNAME_L1, FNAME_L2, FNAME_L3, FNUMBER, FSTATE, FTYPE, FDESCRIPTION_L1, FDESCRIPTION_L2, FDESCRIPTION_L3, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FSCHEDULEID, FMESSAGEID, FCONDITIONID, FTEMPLATEID, FBIZORG, FMAXINSTANCECOUNT, FMAXFOREWARNCOUNT, FBIZSYSTEM_L1, FBIZSYSTEM_L2, FBIZSYSTEM_L3, FMAXMESSAGECOUNT, FPROCESSDEFID, FCONTROLUNITID, FTOUCHTYPE, FTOUCHACTION, FEXTCLASSPATH) VALUES (N'3JMAAAAIxwshkaHb', NULL, N'经理人人力简报预警', NULL, N'mgr_affair_01', 20, 10, NULL, NULL, NULL, '00000000-0000-0000-0000-00000000000013B7DE7F', TO_DATE('2016-10-20 16:11:49', 'YYYY-MM-DD HH24:MI:SS'), '00000000-0000-0000-0000-00000000000013B7DE7F', TO_DATE('2016-10-20 16:11:03', 'YYYY-MM-DD HH24:MI:SS'), N'3JMAAAAIxwzgqay4', N'3JMAAAAIxw2+eZck', N'3JMAAAAIxw4o7rD4', NULL, NULL, 10000, 1000, NULL, N'基本人事', NULL, 1000, NULL, '00000000-0000-0000-0000-000000000000CCE7AED4', N'0', NULL, 'com.kingdee.shr.base.syssetting.cloud.logic.HumanBriefForewarnMessagePost')] failed, sqlcode[904] sqlstat[42000],Causedby[ORA-00904: "FEXTCLASSPATH": 标识符无效
],DBType=[Oracle]
Execute provider[sql/8_2_0to8_5_0/s_HR/syssetting/forewarn_template_config.xml], sql[INSERT INTO T_FW_ForewarnMsg (FID, FTITLE_L1, FTITLE_L2, FTITLE_L3, FBODY_L1, FBODY_L2, FBODY_L3, FDESCRIPTION_L1, FDESCRIPTION_L2, FDESCRIPTION_L3, FAPPENDMSG_L1, FAPPENDMSG_L2, FAPPENDMSG_L3, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FPRIORITY, FBODYSCRIPT, FTITLESCRIPT, FCONTROLUNITID, FNEEDSENDMOBILE, FNEEDSENDEMAIL, FNEEDSENDWEIBO, FCATEGORY, FPARAMSCRIPT, FMERGEMESSAGERULE, FPARAMSCRIPT_L1, FPARAMSCRIPT_L2, FPARAMSCRIPT_L3, FNEEDSENDCLOUD) VALUES ('3JMAAAAIxw2+eZck', ?, ?, ?, ?, ?, ?, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, ?, ?, '11111111-1111-1111-1111-111111111111CCE7AED4', 0, 0, 0, NULL, ?, NULL, ?, ?, ?, 1)] failed, sqlcode[904] sqlstat[42000],Causedby[ORA-00904: "FNEEDSENDCLOUD": 标识符无效
],DBType=[Oracle]
]
异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[sql/8_2_0to8_5_0/s_HR/syssetting/forewarn_template_config.sql], sql[INSERT INTO t_fw_forewarnitem (FID, FNAME_L1, FNAME_L2, FNAME_L3, FNUMBER, FSTATE, FTYPE, FDESCRIPTION_L1, FDESCRIPTION_L2, FDESCRIPTION_L3, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FSCHEDULEID, FMESSAGEID, FCONDITIONID, FTEMPLATEID, FBIZORG, FMAXINSTANCECOUNT, FMAXFOREWARNCOUNT, FBIZSYSTEM_L1, FBIZSYSTEM_L2, FBIZSYSTEM_L3, FMAXMESSAGECOUNT, FPROCESSDEFID, FCONTROLUNITID, FTOUCHTYPE, FTOUCHACTION, FEXTCLASSPATH) VALUES (N'3JMAAAAIxwshkaHb', NULL, N'经理人人力简报预警', NULL, N'mgr_affair_01', 20, 10, NULL, NULL, NULL, '00000000-0000-0000-0000-00000000000013B7DE7F', TO_DATE('2016-10-20 16:11:49', 'YYYY-MM-DD HH24:MI:SS'), '00000000-0000-0000-0000-00000000000013B7DE7F', TO_DATE('2016-10-20 16:11:03', 'YYYY-MM-DD HH24:MI:SS'), N'3JMAAAAIxwzgqay4', N'3JMAAAAIxw2+eZck', N'3JMAAAAIxw4o7rD4', NULL, NULL, 10000, 1000, NULL, N'基本人事', NULL, 1000, NULL, '00000000-0000-0000-0000-000000000000CCE7AED4', N'0', NULL, 'com.kingdee.shr.base.syssetting.cloud.logic.HumanBriefForewarnMessagePost')] failed, sqlcode[904] sqlstat[42000],Causedby[ORA-00904: "FEXTCLASSPATH": 标识符无效
],DBType=[Oracle]
Execute provider[sql/8_2_0to8_5_0/s_HR/syssetting/forewarn_template_config.xml], sql[INSERT INTO T_FW_ForewarnMsg (FID, FTITLE_L1, FTITLE_L2, FTITLE_L3, FBODY_L1, FBODY_L2, FBODY_L3, FDESCRIPTION_L1, FDESCRIPTION_L2, FDESCRIPTION_L3, FAPPENDMSG_L1, FAPPENDMSG_L2, FAPPENDMSG_L3, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FPRIORITY, FBODYSCRIPT, FTITLESCRIPT, FCONTROLUNITID, FNEEDSENDMOBILE, FNEEDSENDEMAIL, FNEEDSENDWEIBO, FCATEGORY, FPARAMSCRIPT, FMERGEMESSAGERULE, FPARAMSCRIPT_L1, FPARAMSCRIPT_L2, FPARAMSCRIPT_L3, FNEEDSENDCLOUD) VALUES ('3JMAAAAIxw2+eZck', ?, ?, ?, ?, ?, ?, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, ?, ?, '11111111-1111-1111-1111-111111111111CCE7AED4', 0, 0, 0, NULL, ?, NULL, ?, ?, ?, 1)] failed, sqlcode[904] sqlstat[42000],Causedby[ORA-00904: "FNEEDSENDCLOUD": 标识符无效
],DBType=[Oracle]
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:3021)
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:4303)
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:3997)
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.GeneratedMethodAccessor6.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)
推荐阅读