?
Solved

R6018 unexpected heap error

Posted on 2004-08-17
4
Medium Priority
?
1,407 Views
Last Modified: 2008-02-01
We are running Reports 2.5 on a 9i database.  One report has a before report trigger which inserts data into a table, the report selects data from this table and the after report trigger deletes data from this table.

When we run this report on Screen, the results are shown and when we close the report we get a R6018 -  unexpected heap error.  When we choose File option also, we get the same error although the file gets created.  In both cases, the table in which data is inserted does not have the data so the after report trigger is getting fired.

After this error, the system has to be abnormally closed.

I checked on metalink and found a Note 1029601.6

Problem Description  ===================    Sun Solaris   db v7.3.2 (oracle)  sqlnet v2.3  tcpip    Win NT 3.51  sqlserver  tcpip    Transparent Gateway for MS SQLSERVER v4.0.0.1.0    Runtime error r6018 unexpect heap error    Gateway service was stopping intermittently giving the error in the trace file:  Runtime error r6018  unexpected heap error  Solution Description  =====================    This runtime error r6018 is part of the MS Visual C++ runtime library.  The  process was running out of memory and returning the heap error.  To solve ths problem add more physical ram or reduce the amount of other  services and programs running on the server.
.

We have a good IBM server and all other reports are running fine.  

Any suggestions ?
0
Comment
Question by:sapnam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 750 total points
ID: 11819020
Reports 2.5 is too old for running with 9i. Especially if you use AL32UTF8 character set.
Soon you will need migration. Why you do not start the migration process now?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 11819025
alsp check the character set of the Oracle server. It can be not known for the old good Reports 2.5!
0
 
LVL 8

Author Comment

by:sapnam
ID: 11828145
Thanks, schwertner, I agree with you we should migrate.  In the meanwhile, can you give me some pointers about how can I get more info on the character set and what implications does that have ?  We are having a Linux server.  How do i Check the character set of the server
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question