OraFAQ Forum: Reports & Discoverer » ORA-04030 error when open the report

Home » Developer & Programmer » Reports & Discoverer » ORA-04030 error when open the report (Oracle report 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04030 error when open the report [message #290029]

Thu, 27 December 2007 03:32

payazal
Messages: 8
Registered: October 2007
Location: KL

Junior Member

Dear all,

I have one report execute using oracle report 6i and at server-client based. that report can compiled well at my computer but when it run it at server it cause error below :

ORA-04030: out of process memory when trying allocate 131096 bytes (hash join subh, kllcqs:klltba)
==> Select count '01-02' as qTempoh ,

the query it attached

Thank all...

Attachment: query_prob.txt
(Size: 15.23KB, Downloaded 1263 times)

Report message to a moderator

Re: ORA-04030 error when open the report [message #290033 is a reply to message #290029]

Thu, 27 December 2007 03:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

The error says that there's no enough RAM to complete the task. So, you might

add more RAM
check whether hard disk is full (and it can not expand virtual memory)
decrease SHARED_POOL_SIZE and DB_CACHE_SIZE initialization parameters so that Oracle uses less memory

The fact that report compiled has nothing to do with the error - it only prooved that there are no syntax and similar errors. Runtime is something different.

There are many values you select in a query. You might try to create several FUNCTIONS (stored in a database, not function columns in the report) which would calculate those values and return them to report. Perhaps you'd avoid such a problem.

Report message to a moderator

Re: ORA-04030 error when open the report [message #290036 is a reply to message #290029]

Thu, 27 December 2007 03:51

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi payazal,

Sorry littlefoot,
I am also sending the same solution to him Smile

This can be caused by a shortage of RAM on a dedicated (non shared server) environment.

RAM shortage - Depending on your release of Oracle, you have several options:

Increase pga_aggregate_target
Decrease sort_area_size and/or hash_area_size
Move to multi-threaded server (a.k.a. MTS or shared servers)

Ashu

Report message to a moderator

Re: ORA-04030 error when open the report [message #290161 is a reply to message #290029]

Thu, 27 December 2007 18:48

payazal
Messages: 8
Registered: October 2007
Location: KL

Junior Member

thanks all...
i will try it.

Report message to a moderator

Re: ORA-04030 error when open the report [message #290650 is a reply to message #290161]

Mon, 31 December 2007 00:49

payazal
Messages: 8
Registered: October 2007
Location: KL

Junior Member

dear all,

there are any solution besides solution above.
I still can't solve this problem.
other report is ok and only this report have this error. Confused

Report message to a moderator

Re: ORA-04030 error when open the report [message #290665 is a reply to message #290650]

Mon, 31 December 2007 01:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you did all we said previously but nothing helped, I guess this won't help either, but won't cost much to try: recompile the report using the "compile ALL" option (<Ctrl + Shift + K>) and run it again.

Report message to a moderator

Previous Topic:	what is the substitute for BUTTON in 10g?
Next Topic:	How can i see the parameter form before run the report in 9iR1as environment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:34:36 CST 2024