Kbase P30660: Internal error -1214 when trying to update a numeric / decimal field in SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/25/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Internal error -1214 is produced when updating or deleting a record in SQL-92 which contains a numeric / decimal field.
Internal error -1214 (see dsmret.h) in SQL from subsystem DSM SERVICES
function dsmKeyDelete called from ix_delete on <tablename> for <indexname>. Save log for Progress technical support.
CAUSE:
Bug# 20030710-004
CAUSE:
This is a generic SQL server bug for numeric data whose value is between -0.01 and 0.01.
FIX:
Apply 9.1D Service Pack 9 or later.
- AND -
Do an idxbuild or idxfix on the corresponding index.