登录管理员账户，用户管理，选定某一用户，点“分配权限”或“查看权限”按钮，提示“获取权限信息失败”，错误日志如下：sql:SELECT RolePerm.FPermItemID FPERMITEMID, RolePerm.FPermType FPERMTYPE, RolePerm.FRuleStructure FRULESTRUCTURE, RolePerm.FRuleExpr FRULEEXPR, PermItem.FAlias_L2 FALIAS, PermItem.FOrgRelation FORGRELATION, PermItem.FIsLeaf FISLEAF, PermItem.FParentID FPARENTID, PermItem.FObjectType FOBJECTTYPE, PermItem.FIsApplyToF7 FISAPPLYTOF7 FROM T_PM_RolePerm ROLEPERM INNER JOIN T_PM_PermItem PERMITEM ON PermItem.FID = RolePerm.FPermItemID INNER JOIN T_PM_UserRoleOrg USERROLEORG ON UserRoleOrg.FRoleID = RolePerm.FRoleID WHERE ((UserRoleOrg.FUserID = ? AND UserRoleOrg.FOrgID = ?) AND (PermItem.FOrgRelation = 100 OR PermItem.FOrgRelation = 4 OR PermItem.FOrgRelation = 0 OR PermItem.FOrgRelation = 3 OR PermItem.FOrgRelation = 1 OR PermItem.FOrgRelation = 24 OR PermItem.FOrgRelation = 10 OR PermItem.FOrgRelation = 16 OR PermItem.FOrgRelation = 5 OR PermItem.FOrgRelation = 2 OR PermItem.FOrgRelation = 32)) UNION SELECT RolePerm.FPermItemID FPERMITEMID, RolePerm.FPermType FPERMTYPE, RolePerm.FRuleStructure FRULESTRUCTURE, RolePerm.FRuleExpr FRULEEXPR, PermItem.FAlias_L2 FALIAS, PermItem.FOrgRelation FORGRELATION, PermItem.FIsLeaf FISLEAF, PermItem.FParentID FPARENTID, PermItem.FObjectType FOBJECTTYPE, PermItem.FIsApplyToF7 FISAPPLYTOF7 FROM T_PM_RolePerm ROLEPERM INNER JOIN T_PM_PermItem PERMITEM ON PermItem.FID = RolePerm.FPermItemID INNER JOIN T_PM_UserRoleOrg USERROLEORG ON UserRoleOrg.FRoleID = RolePerm.FRoleID WHERE ((UserRoleOrg.FUserID = ? AND UserRoleOrg.FOrgID = ?) AND PermItem.FOrgRelation = -1) UNION SELECT UserOrgPerm.FPermItemID FPERMITEMID, UserOrgPerm.FPermType FPERMTYPE, UserOrgPerm.FRuleStructure FRULESTRUCTURE, UserOrgPerm.FRuleExpr FRULEEXPR, PermItem.FAlias_L2 FALIAS, PermItem.FOrgRelation FORGRELATION, PermItem.FIsLeaf FISLEAF, PermItem.FParentID FPARENTID, PermItem.FObjectType FOBJECTTYPE, PermItem.FIsApplyToF7 FISAPPLYTOF7 FROM T_PM_UserOrgPerm USERORGPERM INNER JOIN T_PM_PermItem PERMITEM ON PermItem.FID = UserOrgPerm.FPermItemID WHERE (UserOrgPerm.FOwner = ? AND (UserOrgPerm.FOrgID = ? OR UserOrgPerm.FOrgID = '11111111-1111-1111-1111-111111111111CCE7AED4'))
ksql: SELECT RolePerm.FPermItemID AS FPermItemID, RolePerm.FPermType AS FPermType, RolePerm.FRuleStructure AS FRuleStructure, RolePerm.FRuleExpr AS FRuleExpr, PermItem.FAlias_L2 AS FAlias, PermItem.FOrgRelation AS FOrgRelation, PermItem.FIsLeaf AS FIsLeaf, PermItem.FParentID AS FParentID, PermItem.FObjectType AS FObjectType, PermItem.FIsApplyToF7 AS FIsApplyToF7 FROM T_PM_RolePerm RolePerm INNER JOIN T_PM_PermItem PermItem ON PermItem.FID = RolePerm.FPermItemID INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleID WHERE UserRoleOrg.FUserID = ? AND UserRoleOrg.FOrgID = ? AND ( PermItem.FOrgRelation = 100 OR PermItem.FOrgRelation = 4 OR PermItem.FOrgRelation = 0 OR PermItem.FOrgRelation = 3 OR PermItem.FOrgRelation = 1 OR PermItem.FOrgRelation = 24 OR PermItem.FOrgRelation = 10 OR PermItem.FOrgRelation = 16 OR PermItem.FOrgRelation = 5 OR PermItem.FOrgRelation = 2 OR PermItem.FOrgRelation = 32 ) UNION SELECT RolePerm.FPermItemID AS FPermItemID, RolePerm.FPermType AS FPermType, RolePerm.FRuleStructure AS FRuleStructure, RolePerm.FRuleExpr AS FRuleExpr, PermItem.FAlias_L2 AS FAlias, PermItem.FOrgRelation AS FOrgRelation, PermItem.FIsLeaf AS FIsLeaf, PermItem.FParentID AS FParentID, PermItem.FObjectType AS FObjectType, PermItem.FIsApplyToF7 AS FIsApplyToF7 FROM T_PM_RolePerm RolePerm INNER JOIN T_PM_PermItem PermItem ON PermItem.FID = RolePerm.FPermItemID INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleID WHERE UserRoleOrg.FUserID = ? AND UserRoleOrg.FOrgID = ? AND PermItem.FOrgRelation = -1 UNION SELECT UserOrgPerm.FPermItemID AS FPermItemID, UserOrgPerm.FPermType AS FPermType, UserOrgPerm.FRuleStructure AS FRuleStructure, UserOrgPerm.FRuleExpr AS FRuleExpr, PermItem.FAlias_L2 AS FAlias, PermItem.FOrgRelation AS FOrgRelation, PermItem.FIsLeaf AS FIsLeaf, PermItem.FParentID AS FParentID, PermItem.FObjectType AS FObjectType, PermItem.FIsApplyToF7 AS FIsApplyToF7 FROM T_PM_UserOrgPerm UserOrgPerm INNER JOIN T_PM_PermItem PermItem ON PermItem.FID = UserOrgPerm.FPermItemID WHERE UserOrgPerm.FOwner = ? AND ( UserOrgPerm.FOrgID = ? OR UserOrgPerm.FOrgID = '11111111-1111-1111-1111-111111111111CCE7AED4' )
2015-04-10 09:06:43 INFO [con.out] [2015-04-10 09:06:43,173 ERROR RPC-1]sql is: SELECT RolePerm.FPermItemID AS FPermItemID, RolePerm.FPermType AS FPermType, RolePerm.FRuleStructure AS FRuleStructure, RolePerm.FRuleExpr AS FRuleExpr, PermItem.FAlias_L2 AS FAlias, PermItem.FOrgRelation AS FOrgRelation, PermItem.FIsLeaf AS FIsLeaf, PermItem.FParentID AS FParentID, PermItem.FObjectType AS FObjectType, PermItem.FIsApplyToF7 AS FIsApplyToF7 FROM T_PM_RolePerm RolePerm INNER JOIN T_PM_PermItem PermItem ON PermItem.FID = RolePerm.FPermItemID INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleID WHERE UserRoleOrg.FUserID = ? AND UserRoleOrg.FOrgID = ? AND ( PermItem.FOrgRelation = 100 OR PermItem.FOrgRelation = 4 OR PermItem.FOrgRelation = 0 OR PermItem.FOrgRelation = 3 OR PermItem.FOrgRelation = 1 OR PermItem.FOrgRelation = 24 OR PermItem.FOrgRelation = 10 OR PermItem.FOrgRelation = 16 OR PermItem.FOrgRelation = 5 OR PermItem.FOrgRelation = 2 OR PermItem.FOrgRelation = 32 ) UNION SELECT RolePerm.FPermItemID AS FPermItemID, RolePerm.FPermType AS FPermType, RolePerm.FRuleStructure AS FRuleStructure, RolePerm.FRuleExpr AS FRuleExpr, PermItem.FAlias_L2 AS FAlias, PermItem.FOrgRelation AS FOrgRelation, PermItem.FIsLeaf AS FIsLeaf, PermItem.FParentID AS FParentID, PermItem.FObjectType AS FObjectType, PermItem.FIsApplyToF7 AS FIsApplyToF7 FROM T_PM_RolePerm RolePerm INNER JOIN T_PM_PermItem PermItem ON PermItem.FID = RolePerm.FPermItemID INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleID WHERE UserRoleOrg.FUserID = ? AND UserRoleOrg.FOrgID = ? AND PermItem.FOrgRelation = -1 UNION SELECT UserOrgPerm.FPermItemID AS FPermItemID, UserOrgPerm.FPermType AS FPermType, UserOrgPerm.FRuleStructure AS FRuleStructure, UserOrgPerm.FRuleExpr AS FRuleExpr, PermItem.FAlias_L2 AS FAlias, PermItem.FOrgRelation AS FOrgRelation, PermItem.FIsLeaf AS FIsLeaf, PermItem.FParentID AS FParentID, PermItem.FObjectType AS FObjectType, PermItem.FIsApplyToF7 AS FIsApplyToF7 FROM T_PM_UserOrgPerm UserOrgPerm INNER JOIN T_PM_PermItem PermItem ON PermItem.FID = UserOrgPerm.FPermItemID WHERE UserOrgPerm.FOwner = ? AND ( UserOrgPerm.FOrgID = ? OR UserOrgPerm.FOrgID = '11111111-1111-1111-1111-111111111111CCE7AED4' ) param is:param 0 is:s4bJ9fVGSvGa4CuhJlHBUhO33n8=param 1 is:00000000-0000-0000-0000-000000000000CCE7AED4param 2 is:s4bJ9fVGSvGa4CuhJlHBUhO33n8=param 3 is:00000000-0000-0000-0000-000000000000CCE7AED4param 4 is:s4bJ9fVGSvGa4CuhJlHBUhO33n8=param 5 is:00000000-0000-0000-0000-000000000000CCE7AED4
2015-04-10 09:06:43 INFO [con.out] [2015-04-10 09:06:43,173 ERROR RPC-1]sql error!
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got 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.base.permission.app.PermissionManagerControllerBean._getAllPerms(PermissionManagerControllerBean.java:160)
at com.kingdee.eas.base.permission.app.AbstractPermissionManagerControllerBean.getAllPerms(AbstractPermissionManagerControllerBean.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
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 $Proxy141.getAllPerms(Unknown Source)
at com.kingdee.eas.base.permission.PermissionManager.getAllPerms(PermissionManager.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:193)
at $Proxy140.getAllPerms(Unknown Source)
at com.kingdee.eas.base.permission.app.UserPermViewUIHandler._handleInit(UserPermViewUIHandler.java:55)
at com.kingdee.eas.framework.app.CoreUIHandler.handleInit(CoreUIHandler.java:19)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.eas.framework.app.ItemActionUIHandler.actionPerformed(ItemActionUIHandler.java:44)
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.eas.framework.app.ServiceHandlerFacadeControllerBean._Execute(ServiceHandlerFacadeControllerBean.java:46)
at com.kingdee.eas.framework.app.AbstractServiceHandlerFacadeControllerBean.Execute(AbstractServiceHandlerFacadeControllerBean.java:25)
at com.kingdee.eas.framework.ServiceHandlerFacade.Execute(ServiceHandlerFacade.java:50)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_framework_1_IServiceHandlerFacade.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_framework_1_IServiceHandlerFacade.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)
推荐阅读