Kbase P24328: Error occurs when loading a .df file into an AS/400 database using the Progress/400 Data Dictionary
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
Error occurs when loading a .df file into an AS/400 database using the Progress/400 Data Dictionary
The following DBA command error message was received:
Wrong File Format, cannot modify
CAUSE:
Previously, a load of a .df was done but the session died or was killed. As the transaction could not be undone, the temporary files created remained in the library. When starting the load again, all temporary files have a file type of "PF" even if they are logical files ("LF"). Thus when the load continues, the process will check to make sure there are no files with the same name but a different type. When the logical file is checked, the process finds a physical file with the same name. Thus the wrong file format error is issued.
FIX:
Delete the temporary AS/400 files created from the failed load before starting the load process again.
In order to make sure you have deleted the proper files, check the .df file for any "ADD TABLE" or "ADD INDEX" statements. These statements are what causes the load process to create a temporary file of that name in the object library.