TDM upgrade from 4.9 to 4.10 throwing ORA-01418: specified index does not exist

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 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

Environment

Release : 4.10.x

Cause

N/A

Resolution

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.