Consultor Eletrônico



Kbase P166186: Adding a new field to unique active index GPFs
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   17/05/2010
Status: Unverified

SYMPTOM(s):

Adding a new field to unique active index GPFs

Cannot add a newly created field to a unique active index

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

FACT(s) (Environment):

New index contains multiple fields ensuring uniqueness
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.1x
OpenEdge 10.2x
Windows

CAUSE:

Bug# OE00197618

CAUSE:

This is a valid schema change action on unique index, the transaction should commit without error not GPF

FIX:

Commit the newfield changes first before adding the new unique active index.