Kbase P76759: Attempting to delete all records from PUB.SYSIDXSTAT table and getting error -219901
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/02/2009 |
|
Status: Verified
SYMPTOM(s):
Attempting to delete all records from PUB.SYSIDXSTAT table
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-219901
[JDBC Progress Driver]:Internal error -1214 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmKeyDelete called from ix_delete on PUB._Sysidxstat for PUB._Idxsysidxstat. Save log for Progress technical support.
FACT(s) (Environment):
Progress 9.1D
All Supported Operating Systems
CAUSE:
The database has index corruption
FIX:
Run proutil YourDataBaseNameGoesHere -C idxfix and repair the index _Idxsysidxstat of table (PUB.)_sysidxstat