很抱歉系统检测到您的网络连接或服务器响应异常,系统...
金蝶云社区-Volition
Volition
1人赞赏了该文章 9,088次浏览 未经作者许可,禁止转载编辑于2018年04月20日 13:55:29
操作总账-账簿查询-辅助明细账报错:什么原因
很抱歉系统检测到您的网络连接或服务器响应异常,系统不能正常执行操作任务,请选择重

点击“尝试重连”出现如下提示


错误信息:Sql execute exception : SELECT t.SQL_BATCH, t.KSQL_SEQ, sum(CASE WHEN t.FBalSeq = 2 AND t.fperiod = 201802 THEN ISNULL(t.FSubDebitFor, 0.0) ELSE 0.0 END) FDebitFor, sum(CASE WHEN t.FBalSeq = 2 AND t.fperiod = 201802 THEN ISNULL(t.FSubCreditFor, 0.0) ELSE 0.0 END) FCreditFor, sum(CASE t.FBalSeq WHEN 1 THEN ISNULL(t.FEndBalanceFor, 0.0) WHEN 2 THEN (ISNULL(t.FSubDebitFor, 0.0) - ISNULL(t.FSubCreditFor, 0.0)) ELSE 0.0 END) FEndBalanceFor, sum(CASE WHEN t.FBalSeq = 1 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FYearDebitFor, 0.0) WHEN t.FBalSeq = 2 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FSubDebitFor, 0.0) ELSE 0.0 END) FYearDebitFor, sum(CASE WHEN t.FBalSeq = 1 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FYearCreditFor, 0.0) WHEN t.FBalSeq = 2 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FSubCreditFor, 0.0) ELSE 0.0 END) FYearCreditFor FROM VTXFEVLF2L7P94677VQWC154WQG1T09IPC t WHERE t.FAccountID = ?
Caused exception message is: 该游标未声明。
错误详细堆栈信息:com.kingdee.bos.BOSException: Sql execute exception : SELECT t.SQL_BATCH, t.KSQL_SEQ, sum(CASE WHEN t.FBalSeq = 2 AND t.fperiod = 201802 THEN ISNULL(t.FSubDebitFor, 0.0) ELSE 0.0 END) FDebitFor, sum(CASE WHEN t.FBalSeq = 2 AND t.fperiod = 201802 THEN ISNULL(t.FSubCreditFor, 0.0) ELSE 0.0 END) FCreditFor, sum(CASE t.FBalSeq WHEN 1 THEN ISNULL(t.FEndBalanceFor, 0.0) WHEN 2 THEN (ISNULL(t.FSubDebitFor, 0.0) - ISNULL(t.FSubCreditFor, 0.0)) ELSE 0.0 END) FEndBalanceFor, sum(CASE WHEN t.FBalSeq = 1 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FYearDebitFor, 0.0) WHEN t.FBalSeq = 2 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FSubDebitFor, 0.0) ELSE 0.0 END) FYearDebitFor, sum(CASE WHEN t.FBalSeq = 1 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FYearCreditFor, 0.0) WHEN t.FBalSeq = 2 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FSubCreditFor, 0.0) ELSE 0.0 END) FYearCreditFor FROM VTXFEVLF2L7P94677VQWC154WQG1T09IPC t WHERE t.FAccountID = ?
Caused exception message is: 该游标未声明。
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:226)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.executeQuery(AbstractGLRptDao.java:1718)
at com.kingdee.eas.fi.gl.rpt.app.dao.GLRptVoucherDetailDao.getPreRowData(GLRptVoucherDetailDao.java:291)
at com.kingdee.eas.fi.gl.rpt.app.dao.GLRptVoucherDetailDao.calLastPeriodBalance(GLRptVoucherDetailDao.java:195)
at com.kingdee.eas.fi.gl.rpt.app.dao.GLRptVoucherDetailDao.doGLRptRowData(GLRptVoucherDetailDao.java:115)
at com.kingdee.eas.fi.gl.rpt.app.dao.GLRptAsstactBalGDDao.doGLRptRowData(GLRptAsstactBalGDDao.java:669)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.getData(AbstractGLRptDao.java:819)
at com.kingdee.eas.fi.gl.rpt.GLRptQueryResult.(GLRptQueryResult.java:35)
at com.kingdee.eas.fi.gl.rpt.app.GLRptBaseFacadeControllerBean._query(GLRptBaseFacadeControllerBean.java:111)
at com.kingdee.eas.fi.gl.rpt.app.AbstractGLRptBaseFacadeControllerBean.query(AbstractGLRptBaseFacadeControllerBean.java:51)
at sun.reflect.GeneratedMethodAccessor507.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
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 com.sun.proxy.$Proxy432.query(Unknown Source)
at com.kingdee.eas.fi.gl.rpt.GLRptBaseFacade.query(GLRptBaseFacade.java:48)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptAsstactGDFacade.pi18(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptAsstactGDFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
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: 该游标未声明。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2886)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2328)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:644)
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:453)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:979)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:307)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:61)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:210)
... 27 more
Caused by: java.sql.SQLException
java.sql.SQLException: 该游标未声明。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2886)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2328)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:644)
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:453)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:979)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:307)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:61)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:210)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.executeQuery(AbstractGLRptDao.java:1718)
at com.kingdee.eas.fi.gl.rpt.app.dao.GLRptVoucherDetailDao.getPreRowData(GLRptVoucherDetailDao.java:291)
at com.kingdee.eas.fi.gl.rpt.app.dao.GLRptVoucherDetailDao.calLastPeriodBalance(GLRptVoucherDetailDao.java:195)
at com.kingdee.eas.fi.gl.rpt.app.dao.GLRptVoucherDetailDao.doGLRptRowData(GLRptVoucherDetailDao.java:115)
at com.kingdee.eas.fi.gl.rpt.app.dao.GLRptAsstactBalGDDao.doGLRptRowData(GLRptAsstactBalGDDao.java:669)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.getData(AbstractGLRptDao.java:819)
at com.kingdee.eas.fi.gl.rpt.GLRptQueryResult.(GLRptQueryResult.java:35)
at com.kingdee.eas.fi.gl.rpt.app.GLRptBaseFacadeControllerBean._query(GLRptBaseFacadeControllerBean.java:111)
at com.kingdee.eas.fi.gl.rpt.app.AbstractGLRptBaseFacadeControllerBean.query(AbstractGLRptBaseFacadeControllerBean.java:51)
at sun.reflect.GeneratedMethodAccessor507.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
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 com.sun.proxy.$Proxy432.query(Unknown Source)
at com.kingdee.eas.fi.gl.rpt.GLRptBaseFacade.query(GLRptBaseFacade.java:48)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptAsstactGDFacade.pi18(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptAsstactGDFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
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)