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.