打PTM2报错,数据中心更新不成功
报错信息:
错误原因:
执行脚本出现错误,请仔细分析[解决方案]中的错误信息,并试图获取具体的错误原因。
解决方案:
请将如下错误信息提单反馈:
[Execute provider[sql/s_HR1.5/s_HR/base/base_init_data.sql], sql[IF NOT EXISTS (SELECT * FROM t_bs_shrfiletemplatefields WHERE fpropname = 'orgFunction')
BEGIN
EXEC('INSERT INTO t_bs_shrfiletemplatefields (FID, FWIDTH, FCMPIMPORTTEMPID, FIELD, FSORTSN, FNAME_L1, FNAME_L2, FNAME_L3, FNUMBER, FDESCRIPTION_L1, FDESCRIPTION_L2, FDESCRIPTION_L3, FSIMPLENAME, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FCONTROLUNITID, FISNEED, FPROPNAME, FISPRIMAYFIELD) VALUES (''7dIa6xF0RE2IkagaKt+F75WH3jg='', 4, (SELECT fid FROM T_BS_SHRFileTemplate t WHERE t.fentitytable = ''T_ORG_Admin''), NULL, 13, NULL, N''组织职能'', NULL, NULL, NULL, NULL, NULL, NULL, ''n82kV0MzQI6qjYPlAlCRJxO33n8='', ''2014-06-12 14:31:27'', ''n82kV0MzQI6qjYPlAlCRJxO33n8='', ''2014-06-12 14:31:27'', ''lHDbB+kPSvqu8bTwCEh3O8znrtQ='', 0, N''orgFunction'', 0)')
END
] failed, sqlcode[1046] sqlstat[S1000],Causedby[在此上下文中不允许使用子查询。只允许使用标量表达式。],DBType=[MS SqlServer]
]
异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[sql/s_HR1.5/s_HR/base/base_init_data.sql], sql[IF NOT EXISTS (SELECT * FROM t_bs_shrfiletemplatefields WHERE fpropname = 'orgFunction')
BEGIN
EXEC('INSERT INTO t_bs_shrfiletemplatefields (FID, FWIDTH, FCMPIMPORTTEMPID, FIELD, FSORTSN, FNAME_L1, FNAME_L2, FNAME_L3, FNUMBER, FDESCRIPTION_L1, FDESCRIPTION_L2, FDESCRIPTION_L3, FSIMPLENAME, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FCONTROLUNITID, FISNEED, FPROPNAME, FISPRIMAYFIELD) VALUES (''7dIa6xF0RE2IkagaKt+F75WH3jg='', 4, (SELECT fid FROM T_BS_SHRFileTemplate t WHERE t.fentitytable = ''T_ORG_Admin''), NULL, 13, NULL, N''组织职能'', NULL, NULL, NULL, NULL, NULL, NULL, ''n82kV0MzQI6qjYPlAlCRJxO33n8='', ''2014-06-12 14:31:27'', ''n82kV0MzQI6qjYPlAlCRJxO33n8='', ''2014-06-12 14:31:27'', ''lHDbB+kPSvqu8bTwCEh3O8znrtQ='', 0, N''orgFunction'', 0)')
END
] failed, sqlcode[1046] sqlstat[S1000],Causedby[在此上下文中不允许使用子查询。只允许使用标量表达式。],DBType=[MS SqlServer]
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:2953)
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:4189)
at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:3891)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
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)