Consultor Eletrônico



Kbase P122840: SQL: Error (219901) Internal error -1 executing a query.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   11/16/2009
Status: Verified

SYMPTOM(s):

SQL: Error (219901) Internal error -1 executing a query.

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-219901
[DataDirect][OpenEdge JDBC Driver][OpenEdge] 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.

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.1A
OpenEdge 10.1B

CAUSE:

Bug# OE00136184

CAUSE:

The total size of the maximum record length was based on the aggregate column sizes and exceeding 32K. This limit was not being detected and handled properly and SQL was attempting to read rows larger than 32K.

FIX:

Upgrade to OpenEdge 10.1B01 or later