应收调整报错
EAS Cloud-供应链
金蝶云社区-舒芬
舒芬
0人赞赏了该文章 509次浏览 未经作者许可，禁止转载编辑于2015年05月05日 17:13:52


应收单调整的时候这个报错是什么回事呀
错误信息：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:822)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetValue(ORMappingDAO.java:433)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.getValue(ORMappingDAO.java:370)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetValue(AbstractEntityControllerBean.java:209)
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.framework.app.AbstractBillBaseControllerBean._getValue(AbstractBillBaseControllerBean.java:95)
at com.kingdee.eas.fi.ar.app.AbstractArApBillBaseControllerBean._getValue(AbstractArApBillBaseControllerBean.java:106)
at com.kingdee.eas.fi.ar.app.AbstractOtherBillControllerBean._getValue(AbstractOtherBillControllerBean.java:98)
at com.kingdee.eas.fi.ar.app.OtherBillControllerBean._getValue(OtherBillControllerBean.java:6574)
at com.kingdee.eas.fi.ar.app.OtherBillControllerBean._buildDebitAdjust(OtherBillControllerBean.java:6049)
at com.kingdee.eas.fi.ar.app.AbstractArApBillBaseControllerBean.buildDebitAdjust(AbstractArApBillBaseControllerBean.java:498)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:57)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy518.buildDebitAdjust(Unknown Source)
at com.kingdee.eas.fi.ar.ArApBillBase.buildDebitAdjust(ArApBillBase.java:332)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_ar_1_IOtherBill.pi54(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_ar_1_IOtherBill.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
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.
at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:962)
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:294)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.execQuerySQL(EntityAccess.java:483)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.select(EntityAccess.java:365)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:241)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:231)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.searchForOneToMulti(ObjectReader.java:649)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSetChildObject(ObjectReader.java:479)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:245)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.select(ObjectReader.java:139)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:785)
... 31 more
Caused by: java.sql.SQLException
java.sql.SQLException: The executeQuery method must return a result set.
at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:962)
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:294)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.execQuerySQL(EntityAccess.java:483)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.select(EntityAccess.java:365)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:241)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:231)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.searchForOneToMulti(ObjectReader.java:649)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSetChildObject(ObjectReader.java:479)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:245)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.select(ObjectReader.java:139)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:785)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetValue(ORMappingDAO.java:433)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.getValue(ORMappingDAO.java:370)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetValue(AbstractEntityControllerBean.java:209)
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.framework.app.AbstractBillBaseControllerBean._getValue(AbstractBillBaseControllerBean.java:95)
at com.kingdee.eas.fi.ar.app.AbstractArApBillBaseControllerBean._getValue(AbstractArApBillBaseControllerBean.java:106)
at com.kingdee.eas.fi.ar.app.AbstractOtherBillControllerBean._getValue(AbstractOtherBillControllerBean.java:98)
at com.kingdee.eas.fi.ar.app.OtherBillControllerBean._getValue(OtherBillControllerBean.java:6574)
at com.kingdee.eas.fi.ar.app.OtherBillControllerBean._buildDebitAdjust(OtherBillControllerBean.java:6049)
at com.kingdee.eas.fi.ar.app.AbstractArApBillBaseControllerBean.buildDebitAdjust(AbstractArApBillBaseControllerBean.java:498)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:57)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy518.buildDebitAdjust(Unknown Source)
at com.kingdee.eas.fi.ar.ArApBillBase.buildDebitAdjust(ArApBillBase.java:332)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_ar_1_IOtherBill.pi54(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_ar_1_IOtherBill.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)

推荐阅读

应收应付对帐调整方案

在应收应付对账业务中，常会出现因历史问题导致的对账余额数据问题。不少客户会有需要在当期调清余额的需求。现将调整方案进行享 案例：应付对账调整案例：某财务2017 …

    文章

    577

EAS应收应付单调整

EAS应收应付单生成借贷调整单的时候，借贷调整单是不是应该自动与原来的应收单上相关金额自动结算，这个如何设置？ 借贷项调整单，只调金额，不调数量，不结算 ,有上 …

    文章

    1,641

应收应付调整、折让功能

以下为应收调整业务为例，讲解调整业务逻辑，应付调整业务和应收相似。 调整 场景：业务中需要调整应收金额单不需要调整数量的功能 步骤：应收单编辑界面及序时簿界面均 …

    知识

    785