Kbase P36888: Commit fails when loading .df file in Progress/400
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/01/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
Commit fails when loading .df file in Progress/400
The error on the client during commit phase:
"The following DBA command error message was received: Wrong File Format, cannot modify"
The PROSERVER joblog indicates that the file (table) could not be generated due to errors in the DDS description.
DDS compilation log (spool file) shows the error CPD7402
CPD7402: "Value of 0 not valid for indicated field"
CAUSE:
The reason for this issue is related to the fact that the definition file was manually modified with incorrect information. The Progress/400 product has it's own keywords contained in the definition file which are different than other DataServers. An example of this is Progress/400 lists the native data type as AS400-TYPE where the other DataServer's have a keyword of FOREIGN-TYPE.
FIX:
Create a regular Progress definition file and load via the Progress/400 Data Dictionary. The correct data types will be created.