Kbase P101005: Error 3166 when dumping database definition in Progress/400 Data Dictionary
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/02/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress/400 DataServer
IBM AS/400 (RISC)
SYMPTOM(s):
Error 3166 when dumping database definition in Progress/400 Data Dictionary
Problem appears before getting the list of tables to be dumped
More than one P__FILE records found by a unique FIND (3166)
**P__FILE record not on file (138)
Unable to open file:. Errno=2 (98)
CAUSE:
There are records with duplicate FILENAME field in the P__FILE. The uniqueness of this field is achieved via code and not an index. Both dictionary code and CHGPRODCT utility prevent such situations from occurring. The server schema must have been modified outside of Progress (DFU, SQL/400, etc)
FIX:
Remove duplicate entries using RMVSCHE utility on the AS/400 and synchronize the schema holder.