We are Upgrading TDM to latest 4.10 version on a new Windows2022 Server and then connecting to Oracle 19c
But we running into the below error:
Message : ORA-01418: specified index does not exist
Location : db/migration/gtrep/oracle/V4.10.0.08__widen_tsc_id_columns.sql (C:\Program Files\CA\CA Test Data Manager Portal\schema-management\file:\C:\Program Files\CA\CA Test Data Manager Portal\schema-management\lib\TDMGtrepSchema-4.10.227.0.jar!\db\migration\gtrep\oracle\V4.10.0.08__widen_tsc_id_columns.sql)
Line : 4
Statement : DROP INDEX "GTREP_DATADISC_ENT_ATTR_DEF_PK"
at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:345)
at org.flywaydb.core.internal.command.DbMigrate.access$900(DbMigrate.java:53)
at org.flywaydb.core.internal.command.DbMigrate$4.call(DbMigrate.java:276)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:75)
at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:273)
at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:53)
at org.flywaydb.core.internal.command.DbMigra
Release : 4.10.x
N/A
As mentioned in the ERROR, We need to Create an index with this name : GTREP_DATADISC_ENT_ATTR_DEF_PK
for eg: create index <index_name> on <table_name> ( <column1>, <column2>, … );
Its the index for the ATTRIBUTE_ID column And, DBA should be able to execute this for you.
Also, we need to update the Schema version for GTREP otherwise we might run into the error message : Wrapped by: com.ca.tdm.schema.ProcessingException: Migration failed: 'FlywayException: Validate failed: Detected failed migration to version 4.10.0.08
Run the below SQL query:
UPDATE schema_version SET success=1
Clear the logs and Restart the TDM Portal once these changes are made.