分配角色,选择组织,报错
错误如下.
错误信息:Sql4 execute exception : select "BASEUNIT".FID,"BASEUNIT".FName_l2,"BASEUNIT".FNumber,"BASEUNIT".FLongnumber,"BASEUNIT".FLevel,"BASEUNIT".FIsleaf,"BASEUNIT".FIsUnion,"BASEUNIT".FIsCU from T_ORG_BASEUNIT "BASEUNIT" where "BASEUNIT".FParentId ='00000000-0000-0000-0000-000000000000CCE7AED4' and "BASEUNIT".FLongNumber in (select distinct substring("BASEUNIT".FLongNumber, 0, CHARINDEX('!', "BASEUNIT".FLongNumber||'!', 4)-1) AS FVALIDLN from T_ORG_BASEUNIT "BASEUNIT" INNER JOIN T_PM_ORGRANGE "ORGRANGE" ON "ORGRANGE".FOrgId = "BASEUNIT".FControlUnitID where ("BASEUNIT".FLongNumber like ?) AND ("BASEUNIT".FIsOUSealup = 0 AND "BASEUNIT".FIsAssistantOrg = 0) AND ("BASEUNIT".FID in ( select fid from t_org_baseunit where fid in (select distinct forgid from t_pm_orgrange where fuserid = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F' and ftype = 10) and (fcontrolunitid in (select distinct forgid from t_pm_orgrange where fuserid = '00000000-0000-0000-0000-00000000000013B7DE7F' and ftype = 10) or (fisunion = 1 and fmaintaincuid in (select distinct forgid from t_pm_orgrange where fuserid = '00000000-0000-0000-0000-00000000000013B7DE7F' and ftype = 10))))) AND ("BASEUNIT".FOrgTypeStr <> ';Admin;' AND "BASEUNIT".FOrgTypeStr <> ';;Admin;')) order by "BASEUNIT".FLongNumber
Caused exception message is: The executeQuery method must return a result set.
错误详细堆栈信息:com.kingdee.bos.BOSException: Sql4 execute exception : select "BASEUNIT".FID,"BASEUNIT".FName_l2,"BASEUNIT".FNumber,"BASEUNIT".FLongnumber,"BASEUNIT".FLevel,"BASEUNIT".FIsleaf,"BASEUNIT".FIsUnion,"BASEUNIT".FIsCU from T_ORG_BASEUNIT "BASEUNIT" where "BASEUNIT".FParentId ='00000000-0000-0000-0000-000000000000CCE7AED4' and "BASEUNIT".FLongNumber in (select distinct substring("BASEUNIT".FLongNumber, 0, CHARINDEX('!', "BASEUNIT".FLongNumber||'!', 4)-1) AS FVALIDLN from T_ORG_BASEUNIT "BASEUNIT" INNER JOIN T_PM_ORGRANGE "ORGRANGE" ON "ORGRANGE".FOrgId = "BASEUNIT".FControlUnitID where ("BASEUNIT".FLongNumber like ?) AND ("BASEUNIT".FIsOUSealup = 0 AND "BASEUNIT".FIsAssistantOrg = 0) AND ("BASEUNIT".FID in ( select fid from t_org_baseunit where fid in (select distinct forgid from t_pm_orgrange where fuserid = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F' and ftype = 10) and (fcontrolunitid in (select distinct forgid from t_pm_orgrange where fuserid = '00000000-0000-0000-0000-00000000000013B7DE7F' and ftype = 10) or (fisunion = 1 and fmaintaincuid in (select distinct forgid from t_pm_orgrange where fuserid = '00000000-0000-0000-0000-00000000000013B7DE7F' and ftype = 10))))) AND ("BASEUNIT".FOrgTypeStr <> ';Admin;' AND "BASEUNIT".FOrgTypeStr <> ';;Admin;')) order by "BASEUNIT".FLongNumber
Caused exception message is: The executeQuery method must return a result set.
at com.kingdee.eas.util.app.DbUtil.executeQueryNoTx(DbUtil.java:97)
at com.kingdee.eas.basedata.org.app.helper.TreeNodeTypeAssemblage.executeQuery(TreeNodeTypeAssemblage.java:304)
at com.kingdee.eas.basedata.org.app.helper.DefaultOrgDirectTreeNode.getNodesByAllQueryItem(DefaultOrgDirectTreeNode.java:48)
at com.kingdee.eas.basedata.org.app.helper.DefaultUnitDirectTreeNode.getNodesByAllQueryItem(DefaultUnitDirectTreeNode.java:75)
at com.kingdee.eas.basedata.org.app.helper.BizOrgRangeDirectTreeNode.getDirectTreeNode(BizOrgRangeDirectTreeNode.java:58)
at com.kingdee.eas.basedata.org.app.NewOrgF7FacadeControllerBean._getDirectChildren(NewOrgF7FacadeControllerBean.java:143)
at com.kingdee.eas.basedata.org.app.AbstractNewOrgF7FacadeControllerBean.getDirectChildren(AbstractNewOrgF7FacadeControllerBean.java:73)
at sun.reflect.GeneratedMethodAccessor503.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
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 $Proxy210.getDirectChildren(Unknown Source)
at com.kingdee.eas.basedata.org.NewOrgF7Facade.getDirectChildren(NewOrgF7Facade.java:65)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_INewOrgF7Facade.pi1(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_INewOrgF7Facade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
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: The executeQuery method must return a result set.
at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:962)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.
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:294)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQueryNoTx(DbUtil.java:82)
... 24 more
Caused by: java.sql.SQLException
java.sql.SQLException: The executeQuery method must return a result set.
at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:962)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.
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:294)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQueryNoTx(DbUtil.java:82)
at com.kingdee.eas.basedata.org.app.helper.TreeNodeTypeAssemblage.executeQuery(TreeNodeTypeAssemblage.java:304)
at com.kingdee.eas.basedata.org.app.helper.DefaultOrgDirectTreeNode.getNodesByAllQueryItem(DefaultOrgDirectTreeNode.java:48)
at com.kingdee.eas.basedata.org.app.helper.DefaultUnitDirectTreeNode.getNodesByAllQueryItem(DefaultUnitDirectTreeNode.java:75)
at com.kingdee.eas.basedata.org.app.helper.BizOrgRangeDirectTreeNode.getDirectTreeNode(BizOrgRangeDirectTreeNode.java:58)
at com.kingdee.eas.basedata.org.app.NewOrgF7FacadeControllerBean._getDirectChildren(NewOrgF7FacadeControllerBean.java:143)
at com.kingdee.eas.basedata.org.app.AbstractNewOrgF7FacadeControllerBean.getDirectChildren(AbstractNewOrgF7FacadeControllerBean.java:73)
at sun.reflect.GeneratedMethodAccessor503.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
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 $Proxy210.getDirectChildren(Unknown Source)
at com.kingdee.eas.basedata.org.NewOrgF7Facade.getDirectChildren(NewOrgF7Facade.java:65)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_INewOrgF7Facade.pi1(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_INewOrgF7Facade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
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)
推荐阅读