R6018 unexpected heap error

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 ?
LVL 8
sapnamAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
schwertnerConnect With a Mentor Commented:
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
 
schwertnerCommented:
alsp check the character set of the Oracle server. It can be not known for the old good Reports 2.5!
0
 
sapnamAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.