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.
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.
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)
推荐阅读