Kbase P8915: Internal errors -1220, 0, -2, are returned when inserting records from an ODBC Client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/10/2002 |
|
Status: Verified
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Using SQL-92 engine
Errors are returned when inserting records from an ODBC Client
Internal error -1220 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmCursorFind called from ix_scan_fetch on <user>.<table> for <user>.<index>. Save log for Progress technical support.
Internal error 0 (unknown sql92 error) in SQL from subsystem SQL92 function tpl_fetch called from stub_tpl_scan_t::tpl_scan_fetch on <user>.<table> for 151519574. Save log for Progress technical support.
Internal error -2 (a column with the specified column id does not exist in the row) in SQL from subsystem RECORD SERVICES function rec_to_data called from stub_tpl_hdl_t::tpl_fetch on <USER>.<table> for <index>. Save log for Progress technical support.
ODBC Client does not crash
ODBC connection remains open
CAUSE:
The indexes are corrupted.
FIX:
Rebuild the indexes.