Kbase 22122: Possible reasons for error: MM- Insertion error (7718)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/12/2002 |
|
SUMMARY:
Possible reasons for getting:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-16021
[JDBC Progress Driver]:MM- Insertion error (7718)
EXPLANATION:
The Progress SQL-92 engine had a failure inserting data into a temp table created while executing a query against a Progress RDBMS. This error occurs on the machine where the Progress SQL-92 server is running.
Possible reasons for this error message to be raised are:
- Permission problems in the temp table "working directory"
- not enough disk space available
- Other
The temp table "working directory" is determined by $WRKDIR on UNIX, or WRKDIR in MS Windows registry system.
If the environment variable or registry setting "WRKDIR" does not exist, then the working directory used by the Progress SQL-92 server is the directory where the server was originally started from. In other words, the working directory could be
- the home directory of the user who first started the
Progress broker under UNIX
- the directory containing the database if the command was
issued from there.
- The short cut Start in value if you have created one to
start your Database server under MS windows
- etc.
SOLUTION:
Check the possible causes listed above. If none of them helped to fix the error message 7718, please contact Progress technical Support.
References to Written Documentation: