Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
on
04-27-2020
12:14 PM
- edited on
06-05-2020
01:13 PM
by
Claudia.Landiva
As of the 4.5 EUM Server in production, the EUM MySQL database has been moved from the Controller host machine to the EUM Server host machine.
As a result, when upgrading to EUM Server version 4.5 from a version lower than 4.4, t you may see this intermittent error after the database has been imported and during the schema update:
cd <eum_server_home>/eum-processor/bin/
bash ./eum-schema update
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Unexpected error running Liquibase: Validation Failed:
1 change sets check sum
liquibaseChangelog.xml::21::AppDynamics is now: 7:834d03b3da7773ee8b2d5c0b9dd3aa96
To resolve this error, log in to the EUM database and run this SQL query:
update DATABASECHANGELOG set MD5SUM='7:834d03b3da7773ee8b2d5c0b9dd3aa96' where id=21;
Then, run the eum-schema command again, using the root user:
./eum-schema --username=root --password=XXXX update
For alternate solution, execute these commands:
bash ./eum-schema clearCheckSums
bash ./eum_schema update
Sometimes the below SQL query fails with ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'synthetic-tag'
update DATABASECHANGELOG set MD5SUM='7:834d03b3da7773ee8b2d5c0b9dd3aa96' where id=21;
In that case, try addressing the checksum issue using below command
bash ./eum-schema clearCheckSums
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form