EAS登陆客户端系统提示报中断

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

EAS登陆客户端系统提示报中断

中断信息如下:
错误信息:Sql3 execute exception : select * from (select FID,FName_L1,FName_L2,FName_L3,FDescription_l2,FLongNumber,FImagePath,FIsReport,FVisible,ffunction,FIsLeaf,FParent,FLevel,FOrder,FEnabled,FUiClassName,FUiClassParam,FUiOprt,FOpenMethod,FShortcutCode,FNumber from T_PM_MainMenuItem where (ffunction in ( SELECT UserOrgPerm.FPermItemID "FPermItemID" FROM T_PM_UserOrgPerm UserOrgPerm WHERE UserOrgPerm.FOwner = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F' AND UserOrgPerm.FPermType = 10 UNION all SELECT RolePerm.FPermItemID FROM T_PM_RolePerm RolePerm INNER JOIN (select distinct froleid from T_PM_UserRoleOrg UserRoleOrg where FUserID='256c221a-0106-1000-e000-10d7c0a813f413B7DE7F') UserRole ON UserRole.FRoleID = RolePerm.FRoleID WHERE RolePerm.FPermType = 10 UNION all SELECT FID AS FPermItemID FROM T_PM_PermItem WHERE FIsLeaf = 1 AND FType = 15)) and ( FMenutype is null or FMenutype=10 ) union all select FID,FName_L1,FName_L2,FName_L3,FDescription_l2,FLongNumber,FImagePath,FIsReport,FVisible,ffunction,FIsLeaf,FParent,FLevel,FOrder,FEnabled,FUiClassName,FUiClassParam,FUiOprt,FOpenMethod,FShortcutCode,FNumber from T_PM_MainMenuItem where (ffunction is null) and ( FMenutype is null or FMenutype=10 )) a order by a.FLongNumber
Caused exception message is: ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)

错误详细堆栈信息:com.kingdee.bos.BOSException: Sql3 execute exception : select * from (select FID,FName_L1,FName_L2,FName_L3,FDescription_l2,FLongNumber,FImagePath,FIsReport,FVisible,ffunction,FIsLeaf,FParent,FLevel,FOrder,FEnabled,FUiClassName,FUiClassParam,FUiOprt,FOpenMethod,FShortcutCode,FNumber from T_PM_MainMenuItem where (ffunction in ( SELECT UserOrgPerm.FPermItemID "FPermItemID" FROM T_PM_UserOrgPerm UserOrgPerm WHERE UserOrgPerm.FOwner = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F' AND UserOrgPerm.FPermType = 10 UNION all SELECT RolePerm.FPermItemID FROM T_PM_RolePerm RolePerm INNER JOIN (select distinct froleid from T_PM_UserRoleOrg UserRoleOrg where FUserID='256c221a-0106-1000-e000-10d7c0a813f413B7DE7F') UserRole ON UserRole.FRoleID = RolePerm.FRoleID WHERE RolePerm.FPermType = 10 UNION all SELECT FID AS FPermItemID FROM T_PM_PermItem WHERE FIsLeaf = 1 AND FType = 15)) and ( FMenutype is null or FMenutype=10 ) union all select FID,FName_L1,FName_L2,FName_L3,FDescription_l2,FLongNumber,FImagePath,FIsReport,FVisible,ffunction,FIsLeaf,FParent,FLevel,FOrder,FEnabled,FUiClassName,FUiClassParam,FUiOprt,FOpenMethod,FShortcutCode,FNumber from T_PM_MainMenuItem where (ffunction is null) and ( FMenutype is null or FMenutype=10 )) a order by a.FLongNumber
Caused exception message is: ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)

at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:137)
at com.kingdee.eas.base.uiframe.app.MainMenuQuickHelper.getAllMenu(MainMenuQuickHelper.java:117)
at com.kingdee.eas.base.uiframe.app.MainMenuQuickHelper.getInitMenuData(MainMenuQuickHelper.java:309)
at com.kingdee.eas.base.uiframe.app.MainMenuQuickHelper.getInitMenuData(MainMenuQuickHelper.java:282)
at com.kingdee.eas.base.uiframe.app.MainFunctionMenuControllerBean._getInitMenuData(MainFunctionMenuControllerBean.java:434)
at com.kingdee.eas.base.uiframe.app.AbstractMainFunctionMenuControllerBean.getInitMenuData(AbstractMainFunctionMenuControllerBean.java:205)
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 $Proxy144.getInitMenuData(Unknown Source)
at com.kingdee.eas.base.uiframe.MainFunctionMenu.getInitMenuData(MainFunctionMenu.java:164)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_uiframe_1_IMainFunctionMenu.pi8(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_uiframe_1_IMainFunctionMenu.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: ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)

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.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:956)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1061)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:840)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
at com.kingdee.bos.sql.shell.KDStatement.executeQuery(KDStatement.java:534)
at com.apusic.jdbc.adapter.StatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:127)
... 24 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)

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.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:956)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1061)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:840)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
at com.kingdee.bos.sql.shell.KDStatement.executeQuery(KDStatement.java:534)
at com.apusic.jdbc.adapter.StatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:127)
at com.kingdee.eas.base.uiframe.app.MainMenuQuickHelper.getAllMenu(MainMenuQuickHelper.java:117)
at com.kingdee.eas.base.uiframe.app.MainMenuQuickHelper.getInitMenuData(MainMenuQuickHelper.java:309)
at com.kingdee.eas.base.uiframe.app.MainMenuQuickHelper.getInitMenuData(MainMenuQuickHelper.java:282)
at com.kingdee.eas.base.uiframe.app.MainFunctionMenuControllerBean._getInitMenuData(MainFunctionMenuControllerBean.java:434)
at com.kingdee.eas.base.uiframe.app.AbstractMainFunctionMenuControllerBean.getInitMenuData(AbstractMainFunctionMenuControllerBean.java:205)
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 $Proxy144.getInitMenuData(Unknown Source)
at com.kingdee.eas.base.uiframe.MainFunctionMenu.getInitMenuData(MainFunctionMenu.java:164)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_uiframe_1_IMainFunctionMenu.pi8(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_uiframe_1_IMainFunctionMenu.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)

恳请总部老师给予指导,比较急,因为是客户正式环境出现问题。


oracle参数需要优化,你联系一下cs部门林珊珊,优化一下oracle的参数
经开发同学分析:应该是什么东西占用内存,导致内存不够用了,这个SQL不至于宕机。重启下ORACLE服务应该就好了

ORA-04030 先去百度看看这个错误,应该是oracle参数优化

Caused by: java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)

T_PM_MainMenuItem 这个需要找基础的谭作君看看

EAS登陆客户端系统提示报中断

中断信息如下:错误信息:Sql3 execute exception : select * from (select FID,FName_L1,FName_L2,FName_L3,FDescription_l2,FLon...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息