Kbase P92035: SQL-92: "Internal error -1214" when updating a non-LOB indexed field together with a BLOB / CLOB fie
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/10/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0x
SYMPTOM(s):
"Internal error -1214" when updating an indexed field in SQL-92.
[JDBC OpenEdge Driver]:Internal error -1214 (see dsmret.h) in SQL from
subsystem DSM SERVICES function dsmKeyDelete called from ix_delete on
<table> for <index>. Save log for Progress technical support.
Also updating a BLOB / CLOB field in the same UPDATE statement.
CAUSE:
A bug with BLOB / CLOB update when any non-LOB type indexed field is updated in the SET clause of an UPDATE statement.
FIX:
Upgrade to OpenEdge 10.0B01 or above.
- OR -
Update the BLOB / CLOB fields independently or separately from any indexed field.