Kbase P148082: Dropping tables via Data Dictionary show errors 8005 and 8011 in the database log file.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/06/2009 |
|
Status: Unverified
SYMPTOM(s):
Dropping tables via Data Dictionary show errors 8005 and 8011 in the database log file.
(8005) bind_schema_table: fildes has no key data after scidxb!
Schema management function <routine> encountered an unexpected failure, described by <reason>.
(8011) drop_sql92_index: index stats update failed, table# = 16 (1, -1)
Schema management function <routine> encountered an unexpected failure, described by <reason> and by <reason code>, and <return code>. The schema table failing is given by <table-number>.
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
Due to an accidental binary load of data into a table which already contained the same set of records a situation was created where duplicate records existed.
The duplicate records did not have proper index entries since an index on the table was defined as unique and the load of duplicate records violated this constraint.
FIX:
Remove the duplicate records then drop the table.