EAS7.0 编码规则无法修改或查看，提示SQL排序规则冲突
EAS Cloud-知识分享
金蝶云社区-williamleer
williamleer
0人赞赏了该文章 1387次浏览 未经作者许可，禁止转载编辑于2015年06月17日 00:01:44

EAS7.0 编码规则无法修改或查看，查看或修改任何一条规则，均提示“绑定数据时发生错误”，点击CTRL+E，具体错误后附。

查看规则数据相关表（如类似T_BAS_CodingRule）的字符字段的排序规则均为"Chinese_PRC_CS_AS",不知道究竟是那里有问题，请指教，谢谢。

------------------------------------------------------------------------------------------------------------------------------------------------------------------
错误信息：select data error.无法解决 equal to 运算中 "Chinese_PRC_CS_AS" 和 "Chinese_PRC_CI_AS" 之间的排序规则冲突。
Caused exception message is: 该游标未声明。
错误详细堆栈信息：com.kingdee.bos.dao.ormapping.SQLAccessException: select data error.无法解决 equal to 运算中 "Chinese_PRC_CS_AS" 和 "Chinese_PRC_CI_AS" 之间的排序规则冲突。
Caused exception message is: 该游标未声明。
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:550)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.getCollection(ORMappingDAO.java:479)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetCollection(AbstractEntityControllerBean.java:495)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean._getCollection(AbstractCoreBaseControllerBean.java:306)
at com.kingdee.eas.framework.app.AbstractObjectBaseControllerBean._getCollection(AbstractObjectBaseControllerBean.java:149)
at com.kingdee.eas.base.codingrule.app.AbstractCodingRuleControllerBean._getCollection(AbstractCodingRuleControllerBean.java:134)
at com.kingdee.eas.base.codingrule.app.AbstractCodingRuleControllerBean.getCodingRuleCollection(AbstractCodingRuleControllerBean.java:122)
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.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy166.getCodingRuleCollection(Unknown Source)
at com.kingdee.eas.base.codingrule.CodingRule.getCodingRuleCollection(CodingRule.java:98)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_codingrule_1_ICodingRule.pi35(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_codingrule_1_ICodingRule.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:629)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:125)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:24)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:103)
Caused by: java.sql.SQLException: 该游标未声明。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:636)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:943)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.(MSCursorResultSet.java:154)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:395)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.execQuerySQL(EntityAccess.java:414)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.select(EntityAccess.java:315)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:199)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:190)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.searchForOneToMulti(ObjectReader.java:588)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSetChildObject(ObjectReader.java:403)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:202)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:190)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.searchForOneToMulti(ObjectReader.java:588)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSetChildObject(ObjectReader.java:403)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:202)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.select(ObjectReader.java:119)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:527)
... 25 more
Caused by: java.sql.SQLException
java.sql.SQLException: 该游标未声明。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:636)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:943)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.(MSCursorResultSet.java:154)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:395)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.execQuerySQL(EntityAccess.java:414)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.select(EntityAccess.java:315)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:199)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:190)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.searchForOneToMulti(ObjectReader.java:588)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSetChildObject(ObjectReader.java:403)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:202)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:190)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.searchForOneToMulti(ObjectReader.java:588)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSetChildObject(ObjectReader.java:403)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:202)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.select(ObjectReader.java:119)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:527)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.getCollection(ORMappingDAO.java:479)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetCollection(AbstractEntityControllerBean.java:495)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean._getCollection(AbstractCoreBaseControllerBean.java:306)
at com.kingdee.eas.framework.app.AbstractObjectBaseControllerBean._getCollection(AbstractObjectBaseControllerBean.java:149)
at com.kingdee.eas.base.codingrule.app.AbstractCodingRuleControllerBean._getCollection(AbstractCodingRuleControllerBean.java:134)
at com.kingdee.eas.base.codingrule.app.AbstractCodingRuleControllerBean.getCodingRuleCollection(AbstractCodingRuleControllerBean.java:122)
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.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy166.getCodingRuleCollection(Unknown Source)
at com.kingdee.eas.base.codingrule.CodingRule.getCodingRuleCollection(CodingRule.java:98)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_codingrule_1_ICodingRule.pi35(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_codingrule_1_ICodingRule.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:629)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:125)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:24)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:103)

ERROR.gif(22.81KB)

推荐阅读

执行EAS某项操作时，提示排序规则冲突

适用版本 EAS7.0.x 问题描述 客户正在操作结账，突然提示报错，client.log及apusic日志中均提示排序规则冲突。 Caused by:com. …

    文章

    685

无法解决排序规则冲突错误

在进行业务操作时提示： select data error.无法解决 equal to 运算中 "Chinese_PRC_CS_AS" 和 "Chinese_P …

    文章

    1494

FAQ-EAS客户端登陆服务器时候提示排序规 …

适用版本 通用 问题现象 EAS客户端登陆服务器时候提示出错，apusic.log日志输出如下错误日志： 2010-11-05 16:14:53 INFO [c …

    文章

    586