Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Oracle DataServer
Progress 9.1x
OpenEdge 10.0x

SYMPTOM(s):

Wrong delta.sql file is generated when delta.df increases the number of extents in a field

Getting the error below when running the delta.sql script:

ADD field1 VARCHAR2 (30)
*
ERROR at line 2:
ORA-00957: duplicate column name

In Progress 9.1x, the statement in the delta.sql file that generates the error is:

ALTER TABLE TABLE1
ADD field1 VARCHAR2(54)
ADD field1 VARCHAR2(54)
ADD field1 VARCHAR2(54)

In OpenEdge 10.0x, the statement in the delta.sql file that generates the error is:

ALTER TABLE TABLE1
ADD field11 VARCHAR2(54)
ADD field11 VARCHAR2(54)
ADD field11 VARCHAR2(54)
;

Using the "Generate Delta.sql Progress To ORACLE" utility in the menu DataServer of the Data Administration

The options "Include Default" and/or "Use Sql Width" have been selected

CAUSE:

This is a known issue being investigated by Development.

FIX:

Modify the delta.sql in order to allow to add the additional extents.

For example, in Progress 9.x, the statement in the file delta.sql should look similar to:
ALTER TABLE TABLE1
ADD field1##3 VARCHAR2 (30)
;

In OpenEdge 10.0x, the statement would be similar to:
ALTER TABLE TABLE1
ADD field1##1 VARCHAR2(54)
ADD field1##2 VARCHAR2(54)
ADD field1##3 VARCHAR2(54)
;