8 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
- 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
- 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
- Error 1 should get resolved after applying the war from latest patchset.
- 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.
- 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;
- Start the cmc-branch-service-6.0.0 application in the Weblogic.