埃微助手连接服务器异常,很抱歉系统检测到您的网络连接或服务器响应异常，系统......

最新推荐文章于 2021-08-09 15:31:30 发布

ivancyzhang

最新推荐文章于 2021-08-09 15:31:30 发布

阅读量785

点赞数

文章标签：埃微助手连接服务器异常

在尝试查询财务系统辅助明细账时遇到错误，系统反馈网络连接或服务器响应异常。错误信息显示为'Sqlexecuteexception'，具体为'该游标未声明'。问题可能源于数据库查询语句执行时游标未正确声明或管理，导致数据无法正常获取。堆栈跟踪显示错误发生在数据库访问层及业务逻辑层的相关方法中。

摘要由CSDN通过智能技术生成

操作总账-账簿查询-辅助明细账报错：什么原因

很抱歉系统检测到您的网络连接或服务器响应异常，系统不能正常执行操作任务，请选择重

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

错误信息：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: 该游标未声明。