Consultor Eletrônico



Kbase P105202: Error 14675 when receiving messages via the Sonic 4GL Adapter
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   02/09/2010
Status: Verified

SYMPTOM(s):

Error 14675 when receiving messages via the Sonic 4GL Adapter

SYSTEM ERROR: Attempt to define too many indexes for area <area number> database DBI*. (40) (14675)

Getting a lot of 5408 warnings before error 14675

WARNING: -l exceeded. Automatically increasing from <old value> to <new value>. (5408)

The client crashes or freezes after error 14675

FACT(s) (Environment):

Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems

CAUSE:

Consumed messages are not being deleted. This in turn causes too many internal TEMP-TABLEs in the application to be defined. TEMP-TABLEs are stored in their own database, local to each client session (DBI* files). As with any other Progress database, the TEMP-TABLE database can only have up to 32,000 indexes defined. The indexes belonging to each TEMP-TABLE defined by the application will add up to reach this limit.

FIX:

Make sure to run DeleteMessage once each message has been consumed.