1. Common Core Services Installation Guide
  2. Known Issues - Resolutions

7 Known Issues - Resolutions

This topic describes the known issues encountered while using the application and its resolutions.

cmc-ml-indb-services

Troubleshooting deployment failure in cmc-ml-indb-services.war

Deployment Error –
  1. org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for migration version 101.32.5.0.0.4.101032004.1.1 -> Applied to database : 589007451 -> Resolved locally : -692687536 :org.flywaydb.core.api.FlywayException:Validate failed: Migration checksum mismatch for migration version 101.32.5.0.0.4.101032004.1.1 -> Applied to database : 589007451 -> Resolved locally : -692687536
  2. org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for migration version 101.32.5.0.0.4.101032004.1.1 -> Applied to database : -692687536-> Resolved locally : 589007451:org.flywaydb.core.api.FlywayException:Validate failed: Migration checksum mismatch for migration version 101.32.5.0.0.4.101032004.1.1 -> Applied to database : -> -692687536 Resolved locally : 589007451
Resolution –
  1. Error 1 should get resolved after applying the war from latest patchset.
  2. Error 2 results in case there are manual modifications made in table flyway_schema_history. That is, checksum of script/file V101_32_5.0.0_4_101032004_1_1__CMC_TM_ML_ALGO_REPO.sql has been manually changed/updated to -692687536 in flyway table. If so please delete all the entries in flyway_schema_history table for script V101_32_5.0.0_4_101032004_1_1__CMC_TM_ML_ALGO_REPO.sql then redeploy/re-run the latest cmc-ml-indb-services.war.

cmc-branch-service

Troubleshooting steps for failed cmc-branch-service-6.0.0

For branch service, the below steps needs to be executed for deploying the service over the March patchset.

  1. Run the following scripts on the SMS schema:

    delete from "flyway_schema_history" where "version" in ('101.4.5.11.0.1.00051001006.10.1');

    delete from SMS_TM_FUNC_ACTIVITY_DETAIL where ID in ('CMC_FA_BRANCH_WORKHR_GETALL','CMC_BRANCH_WORKHR_GETID','CMC_BRANCH_WORKHR_SAVE','CMC_FA_BRANCH_TIME_GETALL','CMC_BRANCH_WORKHR_AUTHQRY','CMC_BRANCH_WORKHR_AUTH','CMC_BRANCH_WORKHR_CLOSERECRD','CMC_BRANCH_WORKHR_DELETE','CMC_BRANCH_WORKHR_GETHISTRY', 'CMC_BRANCH_WORKHR_MODRECRD','CMC_BRANCH_WORKHR_ROPNRECRD');

    commit;

  2. Start the cmc-branch-service-6.0.0 application in the Weblogic.