财务会计-报表-报表制作报错
杜学磊
1,352次浏览
编辑于2014年09月09日 14:23:36
打开财务会计-报表-报表制作报错：
错误信息：
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 = ? Caused exception message is: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB 错误详细堆栈信息：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 = ? Caused exception message is: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB 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.GeneratedMethodAccessor694.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 $Proxy416.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:103)Caused by: java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3383) 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 moreCaused by: java.sql.SQLExceptionjava.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3383) 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.GeneratedMethodAccessor694.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 $Proxy416.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:103)
错误信息：
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 = ? Caused exception message is: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB 错误详细堆栈信息：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 = ? Caused exception message is: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB 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.GeneratedMethodAccessor694.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 $Proxy416.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:103)Caused by: java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3383) 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 moreCaused by: java.sql.SQLExceptionjava.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3383) 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.GeneratedMethodAccessor694.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 $Proxy416.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:103)
推荐阅读