Both 3244 and 9287 errors indicate
the maximum number of 32767 temp-tables in the session is being exceeded.
The 3244 error is raised when a temp-table that goes over the limit is a
static temp-table:
"Unable to create schema information for temp-table <table>. (3244)"
The 9287 error is raised when a temp-table that goes over the limit is a
dynamic temp-table:
"Unable to assign file number to temp-table <name>. Number of active temp-tables reached limit of 32767. (9287)"
Seeing these errors is rare, as they only show up if there are many
temp-tables that do no have indexes. It's more common to see the error
"SYSTEM ERROR: Attempt to define too many indexes for area 6 database DBI*. (40) (14675)" instead.
The root cause for these errors is the same:
There are too many temp-tables active, usually because the ABL code is leaking temp-tables somewhere.For further information on how to troubleshoot this type of issue, refer to Article:
