新增数据中心数据库是运行到创建索引处报错
金蝶云社区-Yepls
Yepls
0人赞赏了该文章 1,061次浏览 未经作者许可,禁止转载编辑于2015年06月08日 17:29:20

错误原因:
执行脚本[./sql/patch/pt031775_bs_permission_update_table.sql]出现错误,脚本所在路径[C:/Kingdee/eas/server/properties/sql.jar]

解决方案:
请将如下错误信息提单反馈:
[Execute provider[.\sql\patch\pt031775_bs_permission_update_table.sql], sql[ALTER TABLE T_PM_PermitemChangeReport ALTER COLUMN fcontent_l1 NTEXT COLLATE Chinese_PRC_CS_AS] failed, sqlcode[4928] sqlstat[S1000],Causedby[无法更改列 'fcontent_l1',因为该列是 'ntext'。]]

异常堆栈:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[.\sql\patch\pt031775_bs_permission_update_table.sql], sql[ALTER TABLE T_PM_PermitemChangeReport ALTER COLUMN fcontent_l1 NTEXT COLLATE Chinese_PRC_CS_AS] failed, sqlcode[4928] sqlstat[S1000],Causedby[无法更改列 'fcontent_l1',因为该列是 'ntext'。]
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:621)
at com.kingdee.eas.tools.admin.domain.db.DataCenterParser.run(DataCenterParser.java:434)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.executeSQLJar(DataCenterServiceImpl.java:1930)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:1763)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
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)