Kbase P121259: Load of sequence current values fails with error 3132
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/12/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
SYMPTOM(s):
load of sequence current values fails with error 3132
Cannot set sequence <sequence-name> beyond its max/min values. (3132)
sequence is defined with no MIN-VAL
sequence is incremented in negative values
the sequence current value is not -1
CAUSE:
Since the sequence is defined without a MIN-VAL - in other words the Lower Limit is ? in the data dictionary, only the MAX-VAL is set. This MAX-VAL is then ambiguous in the case of negative decremented sequences, so the sequence current value fails to load.
FIX:
Workaround by forcing the CURRENT-VALUE of the sequence
1.) Find the Sequence value in the _seqvals.d that was previously dumped
2.) run the following 4GL to set the current value of the sequence:
DO TRANSACTION ON ERROR UNDO, RETRY:
CURRENT-VALUE(<sequence_name>) = <sequence_value>.
END.
3.) Check the current-value:
DISPLAY CURRENT-VALUE(<sequence_name>).