单据数据量很大时,打开单据出错
金蝶云社区-jingzhong_yan
jingzhong_yan
0人赞赏了该文章 1,727次浏览 未经作者许可,禁止转载编辑于2014年09月04日 20:43:31

通过BOS工具开发的单据,单据分录中有10列,通过后台事务新增单据,单据分录有10万条数据,保存成功。启动客户端,在列表界面中双击单据,单据无法打开,报错如下(数据库是SqlServer,请问是否是数据量超出SqlServer功能范围?谢谢):

错误信息:select data error.查询处理器用尽了内部资源,无法生成查询计划。这种情况很少出现,只有在查询极其复杂或引用了大量表或分区时才会出现。请简化查询。如果您认为该消息的出现纯属错误,请与客户支持服务部门联系,了解详细信息。
Caused exception message is: The executeQuery method must return a result set.
错误详细堆栈信息:com.kingdee.bos.dao.ormapping.SQLAccessException: select data error.查询处理器用尽了内部资源,无法生成查询计划。这种情况很少出现,只有在查询极其复杂或引用了大量表或分区时才会出现。请简化查询。如果您认为该消息的出现纯属错误,请与客户支持服务部门联系,了解详细信息。
Caused exception message is: The executeQuery method must return a result set.
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:552)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetValue(ORMappingDAO.java:293)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.getValue(ORMappingDAO.java:270)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetValue(AbstractEntityControllerBean.java:195)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean._getValue(AbstractCoreBaseControllerBean.java:94)
at com.kingdee.eas.framework.app.AbstractObjectBaseControllerBean._getValue(AbstractObjectBaseControllerBean.java:68)
at com.kingdee.eas.framework.app.AbstractCoreBillBaseControllerBean._getValue(AbstractCoreBillBaseControllerBean.java:353)
at com.kingdee.eas.scm.ty.updateprice.app.AbstractUpdateBasePriceControllerBean._getValue(AbstractUpdateBasePriceControllerBean.java:165)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.getValue(AbstractCoreBaseControllerBean.java:78)
at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source)
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 $Proxy219.getValue(Unknown Source)
at com.kingdee.eas.framework.CoreBase.getValue(CoreBase.java:65)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_ty_1_updateprice_1_IUpdateBasePrice.pi66(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_ty_1_updateprice_1_IUpdateBasePrice.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:140)
Caused by: java.sql.SQLException: The executeQuery method must return a result set.

您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!

请选择打赏金币数 *

10金币20金币30金币40金币50金币60金币
可用金币: 0