Kbase P3444: Loading the incremental df file corrupts the sequences
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
OS/400 V4R5
Progress/400 DataServer
SYMPTOM(s):
Loading the incremental df file corrupts the sequences
Progress/400 8.0C60
The incremental df file is generated incorrectly as far as "UPDATE SEQUENCE" is concerned. It results in the sequence corruption.
The minimum value SEQMIN is changed to the value of SEQMAX.
CAUSE:
In the case of:
The df of the new database has the statement:
ADD SEQUENCE "seq_name"
INITIAL 1
INCREMENT 1
CYCLE-ON-LIMIT yes
And the df of the current database has:
ADD SEQUENCE "seq_name"
INITIAL 1
INCREMENT 1
CYCLE-ON-LIMIT no
MIN-VAL 0
The incremental will include the statement:
UPDATE SEQUENCE "seq_name"
CYCLE-ON-LIMIT yes
MIN-VAL ?
The MIN-VAL for the sequence is set to the unknown value (2,147,483,647)which is the same as the MAX-VALUE.
CAUSE:
The issue does not occur in the Progress/400 DataServer version 9.1C due to major changes in the incremental load mechanism.
FIX:
Upgrade the DataServer product to 9.1C