s-HR管理平台新建数据中心报错
金蝶云社区-河北HR业务线
河北HR业务线
0人赞赏了该文章 988次浏览 未经作者许可,禁止转载编辑于2020年02月13日 08:41:06

s-HR 2.0 管理控制台新建数据中心,创建的数据库的过程中报错(SQL 2012),详细见截图

错误原因:
执行脚本[./shr/0_0_0to1_5_0/./7_5_0_patch/./bos/./eip/./PT069676_eip_alter_T_SYN_BaseDataMaping_table.ksql]出现错误,脚本所在路径[D:/shr/shr20s/eas/server/properties/upgradescript/shr]

解决方案:
请将如下错误信息提单反馈:
[Execute provider[./shr/0_0_0to1_5_0/./7_5_0_patch/./bos/./eip/.\PT069676_eip_alter_T_SYN_BaseDataMaping_table.ksql], sql[IF NOT EXISTS (SELECT syscol.name KSQL_COL_NAME FROM syscolumns syscol left join sysobjects sysobj on syscol.id = sysobj.id left join systypes systype on syscol.xusertype=systype.xusertype WHERE (SYSOBJ.NAME = 'T_SYN_BaseDataMaping' AND SYSCOL.NAME = 'FCompanyOrgUnitID'))
BEGIN
EXEC('ALTER TABLE T_SYN_BaseDataMaping ADD FCompanyOrgUnitID VARCHAR (44) COLLATE Chinese_PRC_CS_AS')
END
] failed, sqlcode[4902] sqlstat[S1000],Causedby[找不到对象“T_SYN_BaseDataMaping”,因为它不存在或者您没有所需的权限。]]

异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./shr/0_0_0to1_5_0/./7_5_0_patch/./bos/./eip/.\PT069676_eip_alter_T_SYN_BaseDataMaping_table.ksql], sql[IF NOT EXISTS (SELECT syscol.name KSQL_COL_NAME FROM syscolumns syscol left join sysobjects sysobj on syscol.id = sysobj.id left join systypes systype on syscol.xusertype=systype.xusertype WHERE (SYSOBJ.NAME = 'T_SYN_BaseDataMaping' AND SYSCOL.NAME = 'FCompanyOrgUnitID'))
BEGIN
EXEC('ALTER TABLE T_SYN_BaseDataMaping ADD FCompanyOrgUnitID VARCHAR (44) COLLATE Chinese_PRC_CS_AS')
END
] failed, sqlcode[4902] sqlstat[S1000],Causedby[找不到对象“T_SYN_BaseDataMaping”,因为它不存在或者您没有所需的权限。]
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:627)
at com.kingdee.eas.tools.admin.domain.db.UpdateDCParser.run(UpdateDCParser.java:495)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.updateDataCenter(DataCenterServiceImpl.java:3683)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.upgradeDataCenter(DataCenterServiceImpl.java:3147)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:1936)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
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:25)
at java.lang.reflect.Method.invoke(Method.java:600)
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)