Consultor Eletrônico

Status: Verified

SYMPTOM(s):

Sometimes the U## fields of a table are not created

u##column missing when referenced within an index

'Generate delta sql Progress to Oracle'

Issue is seen prior to Progress 9.1D07

Can not apply 9.1D07 service pack to correct problem

FACT(s) (Environment):

Progress 9.1D

CAUSE:

The exact cause is unknown at the time of this writing

FIX:

Apply the 9.1D07 service pack.
Delta .sql file created by Progress has the following information:
Prior to the CREATE UNIQUE INDEX,
there is; ALTER TABLE COMPANY ADD U##NAME VARCHAR2(20);

Alternatively, to work around:

Edit delta.sql file created by Progress
-add column to table
-add column to index

CREATE TABLE CUSTOMER (
NAME VARCHAR2(40) ,
...
);

CREATE UNIQUE INDEX CUSTOMER##CUST ON CUSTOMER(U##NAME);