Kbase P128746: Enabling 64-Bit Sequences against schema holder crashes _dbutil
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/17/2008 |
|
Status: Verified
SYMPTOM(s):
Attempting to enable 64-Bit Sequences against a DataServer schema-holder
proutil <schema holder> -C enableseq64
_dbutil process crashes
Stack trace from _proutil reads:
drSigFatal
seqDoSetTbl
rlLogAndDoIt
Problem does not occur if the foreign datasource does not contain sequences and therefore they are not referenced in the schema holder
Affected both Oracle and MS SQL Server DataServer schema holders
FACT(s) (Environment):
OpenEdge 10.1B
MS SQL DataServer
Oracle DataServer
CAUSE:
proutil -C enableseq64 is NOT the method to enable large sequences against a dataserver schema-holder database. PROUTIL utilities make changes to the database. Since the schema holder contains schema only, the physical data configuration cannot be modified with proutil commands.
FIX:
There is no automatic, one-step method to enable 64-Bit Sequences for a DataServer schema.
To change the Oracle database sequences to 64 bit, either:
A. re-migrate the database to Oracle from OpenEdge 10.1B or greater, where we introduced the 64-bit implementation.
B. dump the sequence values, recreate them in ORACLE, repull their definitions and reload the sequence values