Unable to start TDM Portal after the migration to a newer version

book

Article ID: 144089

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Starting TDM Portal after migrating to newer versions throws the below errors in startup.log and in TDMSchemaManagementStartup.log

startup.log:

SEVERE: Schema migration failed with exit code '4'.
INFO|12408/5|20-01-29 08:53:20|com.ca.tdm.tomcat.ProcessingException: Schema migration failed with exit code '4'.

TDMSchemaManagementStartup.log

2020-01-29 13:53:08.424 UTC [ERROR] ---                               c.ca.tdm.schema.Main:  Migration failed: 'FlywayException: Validate failed: Migration checksum mismatch for migration 4.8.0.7
-> Applied to database : 1424945929
-> Resolved locally    : -364185949'
org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for migration 4.8.0.7
-> Applied to database : 1424945929
-> Resolved locally    : -364185949
 at org.flywaydb.core.Flyway.doValidate(Flyway.java:1065)
 at org.flywaydb.core.Flyway.access$100(Flyway.java:72)
 at org.flywaydb.core.Flyway$1.execute(Flyway.java:975)
 at org.flywaydb.core.Flyway$1.execute(Flyway.java:971)
 at org.flywaydb.core.Flyway.execute(Flyway.java:1464)
 at org.flywaydb.core.Flyway.migrate(Flyway.java:971)
 at com.ca.tdm.schema.SchemaMigrator.migrate(SchemaMigrator.java:92)
 ... 2 common frames omitted
Wrapped by: com.ca.tdm.schema.ProcessingException: Migration failed: 'FlywayException: Validate failed: Migration checksum mismatch for migration 4.8.0.7
-> Applied to database : 1424945929
-> Resolved locally    : -364185949'
 at com.ca.tdm.schema.SchemaMigrator.migrate(SchemaMigrator.java:100)
 at com.ca.tdm.schema.Main.run(Main.java:92)
 at com.ca.tdm.schema.Main.main(Main.java:55)

Cause

 Incremental patches policy caused the issue.

Environment

Release : 4.8.155.0

Component : CA Test Data Manager

Resolution

The "checksum" need to be updated in schema_version table. The DBA can validate the information in the schema_version table in repository database first and can run the following query or can update it using SQL Developer.
 
 
UPDATE schema_version SET checksum = -364185949 WHERE checksum = 1424945929 AND version = '4.8.0.7';

Additional Information

Checksum values -364185949, 1424945929 and version 4.8.0.7 might vary.