Kbase P16896: Why the MM- Insertion error (7718) while resolving an SQL-92 query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/02/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
MM- Insertion error (7718) while resolving an SQL-92 query.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-16021
[JDBC Progress Driver]:MM- Insertion error (7718)
CAUSE:
This error occurs on the machine where the Progress SQL-92 server is running and is caused by the SQL-92 engine failure to insert records into the temp table created to resolve the query. The most likely reasons for this failure are:
1) Inefficient query that cause the system to exceed default resource limits.
2) Lack of necessary write permissions to the temp table's "working directory".
3) Lack of sufficient disk space available in that "working directory".
4) Exceeding the default limit of some resource related environment variable.
FIX:
1) Optimize the query as much as possible.
2) Grant the user(s) all necessary disk write permissions.
3) Ensure the working directory has sufficient disk space to resolve the query.
4) If the error persists, set one or more of the following SQL-92 Server System Environment variables higher than the default values listed below:
Name Description Default Value
TPE_MM_BLOCKSIZE MM data blocks size 7 KB
TPE_MM_CACHESIZE MM memory buffer page size 1000 KB
TPE_MM_SWAPSIZE MM on disk backing store size 500000 KB In 9.1D06 some new startup parameters were added which equate to these environment variables.
Please see solution P23229, "What are the new SQL-92 Startup parameters for Progress 9.1D?"