Consultor Eletrônico



Kbase P148262: A JDBC client running a report generating many pages fails with error: ""[DataDirect][OpenEdge JDBC
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   13/10/2009
Status: Verified

SYMPTOM(s):

Running a JDBC client report that generates many pages fails with an Insufficient Memory error

[DataDirect][OpenEdge JDBC Driver][OpenEdge] Insufficient Memory. Memory allocation failed at 139 in /vobs_sql/sql/src/rds/psr_env.cxx.

The error still occurs after lowering the fetch array size from 50 to 25.

FACT(s) (Environment):

Most SQL-Width settings for fields in tables referenced in the report are not large.
A few SQL-Width settings for fields in tables referenced in the report are in the 1000 -2000 range.
The per-proc-data-size kernel parameter, which sets the default size of the data segment for a user process, is set to 124217728 (128MB)
Compaq Tru64 UNIX
OpenEdge 10.1B03 Service Pack

CAUSE:

A user process data segment size of 128MB is too small to run the report.

FIX:

Increase the per-proc-data-size kernel parameter. For this particular report, increasing this parameter value to 512MB allows the report to run successfully.