财务会计-报表-报表编制-报表制作报错
EAS Cloud-财务
金蝶云社区-131xxxx9520
131xxxx9520
1人赞赏了该文章 714次浏览 未经作者许可，禁止转载编辑于2018年01月03日 12:42:00
[u]错误信息：Sql execute exception : SELECT UserOrgPerm.FRuleExpr FROM T_PM_UserOrgPerm UserOrgPerm
WHERE UserOrgPerm.FOwner = ?
AND UserOrgPerm.FOrgID = ?
AND UserOrgPerm.FPermItemID = ?
AND UserOrgPerm.FPermType = ?
UNION
SELECT RolePerm.FRuleExpr FROM T_PM_RolePerm RolePerm
INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleID
WHERE UserRoleOrg.FUserID = ?
AND UserRoleOrg.FOrgID = ?
AND RolePerm.FPermItemID = ?
AND RolePerm.FPermType = ? [/u]
[u]Caused exception message is: 该游标未声明。
错误详细堆栈信息：com.kingdee.bos.BOSException: Sql execute exception : SELECT UserOrgPerm.FRuleExpr FROM T_PM_UserOrgPerm UserOrgPerm
WHERE UserOrgPerm.FOwner = ?
AND UserOrgPerm.FOrgID = ?
AND UserOrgPerm.FPermItemID = ?
AND UserOrgPerm.FPermType = ?
UNION
SELECT RolePerm.FRuleExpr FROM T_PM_RolePerm RolePerm
INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleID
WHERE UserRoleOrg.FUserID = ?
AND UserRoleOrg.FOrgID = ?
AND RolePerm.FPermItemID = ?
AND RolePerm.FPermType = ? [/u]
[u]Caused exception message is: 该游标未声明。
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:226)
at com.kingdee.eas.fi.rpt.util.RptUtilForServer.getCommonDataRule(RptUtilForServer.java:720)
at com.kingdee.eas.fi.rpt.app.ReportBaseControllerBean.GetReportIDs(ReportBaseControllerBean.java:784)
at com.kingdee.eas.fi.rpt.app.ReportBaseControllerBean._getTreeData(ReportBaseControllerBean.java:671)
at com.kingdee.eas.fi.rpt.app.AbstractReportBaseControllerBean.getTreeData(AbstractReportBaseControllerBean.java:319)
at sun.reflect.GeneratedMethodAccessor103.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 $Proxy269.getTreeData(Unknown Source)
at com.kingdee.eas.fi.rpt.ReportBase.getTreeData(ReportBase.java:240)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_rpt_1_IReport.pi9(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_rpt_1_IReport.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: 该游标未声明。
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.(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:395)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:210)
... 22 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.(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:395)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:210)
at com.kingdee.eas.fi.rpt.util.RptUtilForServer.getCommonDataRule(RptUtilForServer.java:720)
at com.kingdee.eas.fi.rpt.app.ReportBaseControllerBean.GetReportIDs(ReportBaseControllerBean.java:784)
at com.kingdee.eas.fi.rpt.app.ReportBaseControllerBean._getTreeData(ReportBaseControllerBean.java:671)
at com.kingdee.eas.fi.rpt.app.AbstractReportBaseControllerBean.getTreeData(AbstractReportBaseControllerBean.java:319)
at sun.reflect.GeneratedMethodAccessor103.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 $Proxy269.getTreeData(Unknown Source)
at com.kingdee.eas.fi.rpt.ReportBase.getTreeData(ReportBase.java:240)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_rpt_1_IReport.pi9(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_rpt_1_IReport.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)
[/u]

推荐阅读

财务会计-报表-报表制作报错

打开财务会计-报表-报表制作报错： 错误信息： Sql execute exception : SELECT UserOrgPerm.FRuleExpr FRO …

    文章

    1,350

已制作的报表在[报表编制]界面看不到

【业务描述】 已制作的报表在报表制作界面看不到。 【系统逻辑】 可能是以下两个原因中的一个造成： 1、此报表可能是在【战略管理】→【法定合并】→【报表接收】→【 …

    知识

    28

(FAQ)在【财务会计】-【报表管理】-【报 …

【问题】: (FAQ)在【财务会计】-【报表管理】-【报表编制】-【报表制作】中，9月份预算管理报表上报时提示“不能上报，总账未结账”，可实际平时包括其他报表上 …

    文章

    650