Consultor Eletrônico



Kbase P23274: Attempt to update data exceeding 32000 when using extent variables (arrays)
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   24/01/2011
Status: Verified

SYMPTOM(s):

Attempt to update data exceeding 32000 when using extent variables (arrays)

Trying to increase the size of an already large array


Attempt to update data exceeding 32000 . (12371)

FACT(s) (Environment):

All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x

CAUSE:

Progress procedures have two memory segments of 32k to store variables, one for NO-UNDO variables, one for variables that can be undone. These segments hold all variables, including all extents for all arrays. The error will occur if too many variables and/or extents are defined, causing them to exceed the 32k segment limit.

FIX:

Define the array as a NO-UNDO variable or use a temp-table to handle such large amounts of data. Temp-tables are stored and handled in a different way and don't take as much memory in the variable storage segments. Also, while it takes more code to handle a temp-table, it can contain much more data and is more flexible in usage.