OraFAQ Forum: Reports & Discoverer » REP-1800: Formatter error. VGS-1701: Not enough memory

Home » Developer & Programmer » Reports & Discoverer » REP-1800: Formatter error. VGS-1701: Not enough memory (Report 6i, windows XP)

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

REP-1800: Formatter error. VGS-1701: Not enough memory [message #288043]

Fri, 14 December 2007 07:59

junaidsystems
Messages: 30
Registered: June 2006

Member

While running large report to screen the error is:

"REP-1800: Formatter error. VGS-1701: Not enough memory"

My Observation:
When running report to screen, report builder creates 3 temporary files to REPORTS60\TEMP folder. When one of the file size reaches to exactly 2GB it gives the above mentioned error and report crashes.

I have visited metalink and get the following:

****************************************************
Problem Description
-------------------
You are running a very large report to screen or preview and
you get the following errors:

rep-1800 formatter error
vgs-1701 not enough memory

Solution Description
--------------------
Increase the size of the buffer for the report.
***********************************************************

i've tried following solutions but problem still there:

1) increase and decrease the size of the buffers
2) Removing total number of pages filed so all pages not formated at once.
3) increase the size of the virtual memory of OS
4) increase the size of the PC to 1 GB

I am using report builder 6i, Oracle 10g and windows XP

need urgent help
thanks in advance.

Report message to a moderator