【搞定】紧急：流程流转不了，出现错误信息

qujinhai

用了很长时间的流程，在流转下一步时出现如下错误信息：


错误栈：
错误类型：EFileExecuteAction
错误信息：在操作文件：Org:的时候出现异常，操作代码：34，异常信息：执行取数据的时候出现错误：ORA-04030: 在尝试分配
20976 字节 (callheap,temporary memory) 时进程内存不足
连接参数：数据库URL：Biz:\SYSTEM\SYSTEM.Database

SQL语句：select 0 as FILEINDEX, A.*,  (select COUNT(FGUID) from TORGSYSTEM where FPARENTGUID = A.FGUID  and

FDELETELEVEL = 0) AS CHILDRENCOUNT from TORGSYSTEM A  

where FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE

(FGUID IN (SELECT b.FGUID FROM TORGSYSTEM b, TORGSYSTEM

a where a.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE

FGUID IN (SELECT b.FGUID FROM TORGSYSTEM b, TORGSYSTEM

a where a.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE

FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE (FDEPT

= 'U_ORG_XM_BDGHYJS') and (FPOSITION = '' or FPOSITION is null)

and (FPERSON = '' or FPERSON is null)))  AND ((( (b.FPATH LIKE

a.FPATH || a.FID || a.FKIND || '\%') OR ((a.FKIND = '.PTN') AND

((b.FID = a.FID AND b.FKIND = '.PTM') OR (b.FPATH || b.FID || b.FKIND

LIKE '%\' || a.FID || '.PTM' || '\%'))) ) OR ( a.FPATH || a.FID || a.FKIND =

b.FPATH || b.FID || b.FKIND )))))  AND b.FGUID IN (SELECT FGUID

FROM TORGSYSTEM WHERE ( (UPPER(FFILENAME)

LIKE 'U_ORG_GW_XM_XMJL.PTM') ))  AND ( (b.FPATH LIKE a.FPATH

|| a.FID || a.FKIND || '\%') OR ((a.FKIND = '.PTN') AND ((b.FID = a.FID

AND b.FKIND = '.PTM') OR (b.FPATH || b.FID || b.FKIND LIKE '%\' ||

a.FID || '.PTM' || '\%'))) )) AND FGUID IN (SELECT b.FGUID FROM

TORGSYSTEM b, TORGSYSTEM a where a.FGUID IN (SELECT

FGUID FROM TORGSYSTEM WHERE (FGUID in (select FGUID from

TORGINDEX where UPPER(FID) = 'ORGUNIT.FUNCREF' and UPPER

(FVALUE) = '\ZJYJ\FUNC\FUNC_WZJCJLB_SH.FUNC')))  AND

b.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE ( (UPPER

(FFILENAME) LIKE '%%.PTM')  OR  (UPPER(FFILENAME)

LIKE '%.PSM') ))  AND ((( (b.FPATH LIKE a.FPATH || a.FID || a.FKIND || '\

%') OR ((a.FKIND = '.PTN') AND ((b.FID = a.FID AND b.FKIND = '.PTM')

OR (b.FPATH || b.FID || b.FKIND LIKE '%\' || a.FID || '.PTM' || '\%'))) ) OR (

a.FPATH || a.FID || a.FKIND = b.FPATH || b.FID || b.FKIND )))) and

FDELETELEVEL = 0) AND (FDELETELEVEL = 0))
错误描述：

环境栈：
错误类型：EFileExecuteAction
无环境信息

调用栈：




错误信息出现后，流程接受者窗口空白。再次流转下一步有时行，有时不行。下面是错误信息文件。

atiger

正在处理，有结果跟贴告知

SMP

从出错信息上来看是内存不足了，楼主看一下Oracle客户端、服务端、应用服务器三个机器的内存是不是有一个已经用尽了!如果用尽了看内存被谁占上了!

alang

请参考
http://www.cnoug.org/thread-85115-1-3.html
http://dev2dev.bea.com.cn/bbs/th ... &threadID=34216

qujinhai

我看一下

alang

楼主，问题怎样了？搞定没有？

qujinhai

我们看了一下，参考了给出的链接，初步确定是oracle数据库sga和pga两个参数配置不好，导致内存不足。
可是我们不会修改oracle参数，我们的oracle是群集，10g版本，和单机版的oracle内存参数修改方法不一样，不会改，能告诉我怎么改吗？

alang

这么复杂啊，那我就不清楚了，找Oracle的资料看看吧，我还没有弄过Oracle集群呢

qujinhai

好，我找资料，此帖可结帖了。谢谢！