Salesforce

AppServer SYSTEM ERROR: Attempt to define too many indexes for area 6 database DBI (40)

Printable View
« Go Back

Information

 
TitleAppServer SYSTEM ERROR: Attempt to define too many indexes for area 6 database DBI (40)
URL Name000027788
Article Number000149579
EnvironmentProduct: OpenEdge
Version: 10.2Bx, 11.0
OS: All supported platforms
Other: AppServer
Question/Problem Description
If a State-Reset AppServer Connect Procedure runs a PERSISTENT procedure that defines a NEW GLOBAL SHARED TEMP-TABLE, the AppServer session DBI file keeps growing causing the eventual AppServer process to crash with the error 40 on the client temp-table DBI file

The Agent crashes with error (40) (14675)
Steps to Reproduce
Clarifying Information
When a client session connects and disconnects thousands of times to a State-Reset AppServer and each time runs a PERSISTENT procedure on the AppServer that defines a NEW GLOBAL SHARED TEMP-TABLE, the AppServer session DBI file grows with each connection causing the AppServer to eventually crash with the error: SYSTEM ERROR: Attempt to define too many indexes for area 6 database DBIxxxxaxxxxx. (40)

Following is the full error that appears in th AppServer Broker Server Log file, for example, asbroker1.server.log:

(Procedure: 'Remote.p' Line:0) SYSTEM ERROR: Attempt to define too many indexes for area 6 database DBI3848a03252. (40) (14675)

This issue occurs in OpenEdge 10.2Bx only.  It does not occur in earlier OpenEdge releases
Error MessageSYSTEM ERROR: Attempt to define too many indexes for area 6 database DBI. (40)

(Procedure: 'Remote.p' Line:0) SYSTEM ERROR: Attempt to define too many indexes for area 6 database DBI. (40) (14675)
Defect NumberDefect PSC00241099 / OE00217061
Enhancement Number
Cause
When refreshing a State-Reset AppServer, the GLOBAL SHARED TEMP-TABLE is not being cleaned up.  
The sequence (40) error is classified as a fatal system error that causes the (Agent) process to exit (as a protective measure) when the Application code exceeds the 10.2B+ physical limit for the number of temp-table (db) indexes.
Resolution
Upgrade to OpenEdge 10.2B06 Service Pack or later, OpenEdge 11.1.0 or later.
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:32 AM
Powered by