Kbase P13887: Commit failed after loading the database structure in Progress/400.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
IBM AS/400 (RISC)
Progress/400 DataServer
Progress 9.x
SYMPTOM(s):
Commit failed after loading the database structure.
The following DBA command error message was received: Commit Failed.
Error message in the PROSERVER joblog: "A matching apostrophe/parenthesis not found".
PRO3034: "Attempt to generate new version of file <TableName> in dictionary <DictLib> failed".
CAUSE:
The issue is caused by the long Description of a table (or field), which includes apostrophes (e.g. they are part of a native language like French). Is related to problems in generating proper DDS syntax for the new physical file. The Description field is always truncated to 50 characters. During the load appropriate notification in the .e file is placed. Then the matching apostrophes or parenthesis may not be found. AS/400 is being confused when the description ends.
FIX:
Do not use apostrophes in the table/field description when the Description is longer than 50 characters.