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)
11.rar(1.10KB)
推荐阅读