Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Adding a new field to unique active index GPFs

Cannot add a newly created field to a new unique active index

Stack trace from prow32.exe reads:
10327056 00000000 dbut_stlen+6

FACT(s) (Environment):

New Field and New Index added in the same transaction
Table has existing records
Can add a unique active index on a new field to a table without records
OpenEdge 10.x
Windows

CAUSE:

Bug# OE00197618

CAUSE:

This is an invalid schema change action on unique index, the transaction should gracefully exit with error not GPF

FIX:

Either populate the newfield with unique values before adding this field to the UNIQUE ACTIVE index

Or create the index as UNIQUE INACTIVE, then populate the newfield with unique values and build the new index with:
$ proutil dbname -C idxactivate TABLE.NAME (can be run online for an index which is NOT the primary index and as long as the primary index is active)
- OR -
$ proutil dbname -C idxbuild -TB 24 -TM 32 -SG 32 -B 2048