3.9 Troubleshooting Projection Schema Failure

You can troubleshoot the failure of the projection service by updating the flyway scripts in the database.

The projection service war may fail while deployment with the following error message:

org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for migration version 507.108.5.1.0.14.507108014.1.0 -> Applied to database : 107501546 ->
Resolved locally : -643401112 Detected failed migration to version 101.32.7.3.0.1.00101001001.3.1 (ERTB MSGS)
:org.flywaydb.core.api.FlywayException:Validate failed: Migration checksum mismatch for migration version 507.108.5.1.0.14.507108014.1.0 -> Applied to database : 107501546 -> Resolved locally : -643401112 Detected failed migration to version 101.32.7.3.0.1.00101001001.3.1 (ERTB MSGS)

To resolve this error:

1. Connect to the projection schema in the database.
2. Run the following script in the projection schema:

   update "flyway_schema_history" set "checksum" = '-643401112' where "script" = 'V507_108_5.1.0_14_507108014_1_0__ERTB_MSGS.sql'; delete from "flyway_schema_history" where "success" = 0; ALTER TABLE ERTB_MSGS MODIFY ERR_CODE VARCHAR2(15);

   Note:

   The value of the checksum in this script should match the value in the error message.