安装金蝶s-HR V8.2 SP2补丁时报错,如下错误,麻烦分析下

栏目:s-hr cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-17浏览:1

安装金蝶s-HR V8.2 SP2补丁时报错,如下错误,麻烦分析下

com.kingdee.eas.tools.admin.domain.DomainException: Run SQLScript Patch[PTM112673] in DC[shr] failed!ErrInfo is:Execute provider[sql/8_2_0sp1to8_2_0sp2/s_HR/emp/sp2_initData_table.sql], sql[IF NOT EXISTS (SELECT * FROM t_bs_shrfiletemplatefields WHERE FID = '8r0AAAAOGamVh944')
BEGIN
EXEC('INSERT INTO t_bs_shrfiletemplatefields (FID, FWidth, FCmpImportTempID, Field, FSortSn, FPropName, FIsNeed, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FIsPrimayField) VALUES (N''8r0AAAAOGamVh944'', 4, ''1aVImgWxRTOXlMQ78r0sL5WH3jc='', NULL, ((SELECT FSORTSN FROM t_bs_shrfiletemplatefields WHERE FID = ''xKl06qqvR3W+6FKcLJlEVJWH3jg='') + 1), N''state'', 1, NULL, N''签订状态'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0)')
END
] failed, sqlcode[1046] sqlstat[S1000],Causedby[在此上下文中不允许使用子查询。只允许使用标量表达式。],DBType=[MS SqlServer]

at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:2976)
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:2682)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
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)
com.kingdee.eas.tools.admin.domain.DomainException: Execute provider[sql/8_2_0sp1to8_2_0sp2/s_HR/emp/sp2_initData_table.sql], sql[IF NOT EXISTS (SELECT * FROM t_bs_shrfiletemplatefields WHERE FID = '8r0AAAAOGamVh944')
BEGIN
EXEC('INSERT INTO t_bs_shrfiletemplatefields (FID, FWidth, FCmpImportTempID, Field, FSortSn, FPropName, FIsNeed, FName_l1, FName_l2, FName_l3, FNumber, FDescription_l1, FDescription_l2, FDescription_l3, FSimpleName, FCreatorID, FCreateTime, FLastUpdateUserID, FLastUpdateTime, FControlUnitID, FIsPrimayField) VALUES (N''8r0AAAAOGamVh944'', 4, ''1aVImgWxRTOXlMQ78r0sL5WH3jc='', NULL, ((SELECT FSORTSN FROM t_bs_shrfiletemplatefields WHERE FID = ''xKl06qqvR3W+6FKcLJlEVJWH3jg='') + 1), N''state'', 1, NULL, N''签订状态'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0)')
END
] failed, sqlcode[1046] sqlstat[S1000],Causedby[在此上下文中不允许使用子查询。只允许使用标量表达式。],DBType=[MS SqlServer]

at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:3011)
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:2682)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
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)


都没有人回复?


刚刚提单了,同问。
请问此问题后来咋处理的?
以上问题还请KSM提单,将报错信息附上,谢谢

安装金蝶s-HR V8.2 SP2补丁时报错,如下错误,麻烦分析下

com.kingdee.eas.tools.admin.domain.DomainException: Run SQLScript Patch[PTM112673] in DC[shr] failed!ErrInfo is:Execute pr...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息