Kbase P59298: Workaround: u##field not created within delta.sql prior to 9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2010 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
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
CAUSE:
The exact cause of this issue is unknown at the time of this writing
FIX:
To workaround,
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);