Hi Community,
I'm trying to upgrade a server but I'm doing it in two phases. The first phase is upgrade the server to the last version from Claroty that uses the same JDK, otherwise, from 15.1 to 15.5. The second phase is the upgrade from 15.5 to 15.8 with the JDK 11.
Right now I can migrate the server from 15.1 to 15.3 without any problem, the issue is moving from 15.3 to 15.4; when the upgrade process starts it stops with the following error:
" SQL Text:
ALTER TABLE ODF_CUSTOM_ATTRIBUTES ADD IS_DW_TREND_ENABLED NUMBER DEFAULT 0 NOT NULL
ALTER TABLE ODF_CUSTOM_ATTRIBUTES ADD CONSTRAINT ODF_CUSTOM_ATTRIBUTES_PK PRIMARY KEY ( OBJECT_NAME, INTERNAL_NAME ) USING INDEX TABLESPACE INDX_SMALL
CREATE UNIQUE INDEX ODF_CUSTOM_ATTRIBUTES_U1 ON ODF_CUSTOM_ATTRIBUTES ( OBJECT_NAME, COLUMN_NAME ) TABLESPACE INDX_SMALL
/opt/ppm15.3/.setup/scripts/db.xml:2348: The following error occurred while executing this line:
/opt/ppm15.3/.setup/scripts/db.xml:2485: The following error occurred while executing this line:
/opt/ppm15.3/.setup/scripts/db.xml:624: The following error occurred while executing this line:
/opt/ppm15.3/.setup/scripts/db.macros.xml:56: Java returned: 1 "
So, taking a deep look into the db I found that scrip can't create the constraint ODF_CUSTOM_ATTRIBUTES_PK into the table ODF_CUSTOM_ATTRIBUTES this is because there are dupplicated data into the columns "OBJECT_NAME" and "COLUMN_NAME".
Does somebody has any idea/suggestion to try to fix this? By the way the table ODF_CUSTOM_ATTRIBUTES has more than 1600 records.
I'll wait your comments,
Regards,
Daniel