Kbase P175717: select distinct on large table fails with Internal error -20033 on internal temp table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/15/2010 |
|
Status: Unverified
SYMPTOM(s):
select distinct on large table fails with Internal error -20033 on internal temp table
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -20033 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmRecordGet called from sts_srtt_t:::scan_cursor on .SRTT_Temp_1 for .
select distinct("test_column") from testTable;
FACT(s) (Environment):
The SELECT count(*) on this table runs fine
There are about 3 million records in this table
Linux
OpenEdge 10.2A
CAUSE:
Went out of sorting space. In SQL sorting is used for the DISTINCT operation as well.
FIX:
Increase -SQLTempBuff parameter accordingly