Kbase P114630: Internal error -1 when executing SQL-92 view composed of several tables joined
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/20/2009 |
|
Status: Verified
SYMPTOM(s):
Internal error -1 when executing view
Internal error -1 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmRecordGet called from sts_srtt_t:::scan_cursor on .SRTT_Temp_1 for . Save log for Progress technical support.
No protrace file is generated.
The view contains multiple joins and 21 tables in the FROM clause.
The SQL client is not disconnected
No error in the database .lg file
Depending on the value in the WHERE clause, the query fails.
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
The size of temp table buffers in main memory (cache) is not high enough.
FIX:
The size of temp table buffers in main memory has to be increased.
This is done by increasing the -SQLTempBuff startup parameter. The default value is 1000 (K bytes).
For example:
proserve <database name> -S <port number> -SQLTempBuff 5000
The -SQLTempBuff default value is 1000 (KB). The maximum value is 200000 (200MB).
For the case increasing -SQLTempBuff to 5000 is not sufficient than you may need to increase it's value further depending on the amount of data you work with.