Kbase 21483: Error 2669 When Inserting Records from SQL-92 Client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/08/2006 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
SQL-92 ODBC driver
SQL-92 JDBC driver
Error when inserting a record from a SQL-92 ODBC or JDBC Client.
Error From JDBC client:
SYSTEM ERROR: Invalid size of an index key - <key-size> (2669)
Internal error -4 (buffer too small for generated key) in SQL
from subsystem KEY SERVICES function keyBuild called from
ix_bld_key on <Field> for <index>.
Save log for Progress technical support.
Error from ODBC SQL-92 client:
[MERANT][ODBC PROGRESS driver][PROGRESS]Column values too big to make key. Table <table> ; index <index> (-210014)
CAUSE:
KEY size limit reached.
FIX:
There is a KEY size limit from the rocket database engine for the index. The limit is 188 for the sum of the lengths of all fields in the index.