Kbase P141068: Recompiling the application after adding a new sequence in Dataserver for MS SQL Server causes error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/11/2010 |
|
Status: Unverified
SYMPTOM(s):
Recompiling the application after adding a new sequence in Dataserver for MS SQL Server causes error (4505)
Sequence <name> has unknown value in _Seq-misc[<number>]. (4505)
FACT(s) (Environment):
Using the delta.sql OpenEdge to MSS utility and applied the 2 files to the respective Databases.
The .df used contains a new sequence
Windows
OpenEdge 10.1B
OpenEdge 10.2A
MS SQL Server
CAUSE:
Bug# OE00180842
CAUSE:
The line SEQ-MISC3 is missing to the .df with the correct procedure name for the sequence.
FIX:
Upgrade to OpenEdge 10.2B or later
One can workaround this issue by doing an update/add schema on the sequence(s) and should not need to delete it and repull/adjust it.