Automated deployment engine not working after primary hub server restarted. As a workaround deleted the automated_deployment_engine_mv and automated_deployment_engine_trace files
now its ADE probe is up. Need to know what has happened.
Release: DX UIM 23.4
Component: ADE probe version - 23.4.3
H2 database is corrupted. As per the below H2 database article:
https://github.com/h2database/
If the database runs long enough and changes enough data, then the maximum chunk id can be reached and then it will roll-over and restart with 0. But 0 is a invalid chunk ID in the H2 database version 2.2.224 which is currently being used in the UIM probes. H2 database is a third party jar and this issue appears to be fixed in a later version of the H2 database 2.2.230.
Current H2 database version in UIM doesn't support this and only workaround is to delete the existing corrupt database and replace it with last working database backup.
It will be an enhancement to use the latest H2 database version 2.2.230 as it requires a lot of code changes in the probe.