Kbase P151609: SQL: Internal error -20152 (unknown key services error) executing a simple DELETE statement.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/31/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL: Internal error -20152 (unknown key services error) executing a simple DELETE statement.
Executing the query under ODBC generates the error:
ERROR[HY000][DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Internal error -20152 (unknown key services error) in SQL from subsystem KEY SERVICES function data_to_str called from stub_ix_hdl_t::maint_word_index on PUB.icsc for k-keyindex. Save log for Progress technical support.
Executing the query under ODBC generates the error:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-219901
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -20152 (unknown key services error) in SQL from subsystem KEY SERVICES function data_to_str called from stub_ix_hdl_t::maint_word_index on PUB.icsc for k-keyindex. Save log for Progress technical support.
The above errors were generated executing queries similar to to the following:
DELETE FROM PUB.SomeTableName WHERE SomeFieldName = '0'.
FACT(s) (Environment):
Windows
OpenEdge 10.1C03 Service Pack
CAUSE:
The data in some of the fields in the table referenced in the query is larger than its defined SQL WIDTH.
FIX:
Run Dbtool to identify and fix the offending SQL WIDTH columns. In other words, ensure that no columns in the referenced tables had data longer or wider than its SQL WIDTH.