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 v220.127.116.11.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 ?