（补丁发放待确认）2.0安装时新建数据中心报错-路径问题

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

sql2012 IP1已设置为固定的了，是不是字符集不对？

错误原因：
执行脚本[./shr/0_0_0to1_5_0/./7_5_0_patch/./bos/./eip/./PT069676_eip_alter_T_SYN_BaseDataMaping_table.ksql]出现错误，脚本所在路径[D:/kingdee_shr/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)