We tried to update from 6.4 to 6.7 version before. We were able to successfully upgrade from version [6.4.0.10072] to version [6.6.0.9640]. But when we wanted to upgrade to version [6.7.0.81] , we got the following database error.
Yesterday we tried to download version 6_6_0_b10323 and upgrade to this version. However, when we got the same error, we had to revert to the version [6.6.0.9640] from the local application backup. Unfortunately, we do not have a chance to restore the database to date 2020-12-28.
2020-12-28 20:08:30,625 [localhost-startStop-1] ERROR (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:268) - Error calling Flyway Migrate
org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration V6.7.0.0.201906031400000__add_rc_modules_perf_indexes_-_ORACLE.sql failed
-----------------------------------------------------------------------------------
SQL State : 72000
Error Code : 1408
Message : ORA-01408: such column list already indexed
ORA-06512: at line 9
Location : C:/Program Files/CA/ReleaseAutomationServer/webapps/datamanagement/resources/db/migration/oracle/V6.7.0.0.201906031400000__add_rc_modules_perf_indexes_-_ORACLE.sql (C:\Program Files\CA\ReleaseAutomationServer\webapps\datamanagement\resources\db\migration\oracle\V6.7.0.0.201906031400000__add_rc_modules_perf_indexes_-_ORACLE.sql)
Line : 1
Statement : DECLARE L_INDEXES_COUNT INTEGER;
BEGIN
SELECT COUNT(*)
INTO L_INDEXES_COUNT
FROM USER_INDEXES
WHERE UPPER(INDEX_NAME) = UPPER('IX_RC_MODULES_JOB_ID');
IF (L_INDEXES_COUNT = 0) THEN
EXECUTE IMMEDIATE 'CREATE INDEX IX_RC_MODULES_JOB_ID ON RC_MODULES (JOB_ID)';
END IF;
END;
Release : 6.6, 6.7
Component : Analyzer Common Services