mon_config_service probe starting process, log shows:

Jan 25 16:57:23:972 [main, mon_config_service] SelfServiceProbe.runProbe:153:     -----STARTING -----
Jan 25
16:57:23:975 [main, mon_config_service] SelfServiceProbe.runProbe:155:    Build properties:
    Archiver-Version: Plexus
Archiver
    Build-Jdk: 1.8.0_45
    Build-Time: 2018-10-23 00:48:13.584
    Built-By: teamcity
    Created-By: Apache Maven
3.3.9
    Implementation-Title: mcs
    Implementation-Vendor: CA Unified Infrastructure Management
    Implementation-
Vendor-Id: com.ca.uim.mcs
    Implementation-Version: 9.0.2
    Manifest-Version: 1.0
    SCM-Revision: 5027
Jan 25
16:57:25:609 [main, mon_config_service] org.flywaydb.core.api.FlywayException: Schema `xxxxx` contains a failed
migration to version 8.6.0.06 !
    at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction
(DbMigrate.java:218)
    at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:173)
    at
org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
    at
org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:173)
    at org.flywaydb.core.Flyway
$1.execute(Flyway.java:959)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
    at
org.flywaydb.core.Flyway.execute(Flyway.java:1373)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
    at
com.ca.uim.mcs.db.SchemaMigrator.update(SchemaMigrator.java:89)
    at
com.nimsoft.selfservice.probe.SelfServiceProbe.runProbe(SelfServiceProbe.java:164)
    at
com.nimsoft.selfservice.probe.SelfServiceProbe.main(SelfServiceProbe.java:103)

***This was due to the failure of the DROP script to drop some MCS tables***

The SSRV2_drop_all_tables.sql script for MYSQL did not cleanup the tables completely without error. Some of the tables were not dropped.

1 - Deactivate mon_config_service

2 - Run the drop table script

Checked the SSVR2 tables - and these tables were not removed: 

[root@db01 ~]# mysql -u root -p <password> -S /var/lib/mysql/mysql.sock ca_uim -A -e "show tables" | grep -i SSRV2 

ssrv2groupwithpath 

ssrv2policyprofileblob 

ssrv2policytargetstatus 

ssrv2probetemplatespackage 

ssrv2probetemplateupgrade 

ssrv2schemamigration 

ssrv2templatefilter 

So then we dropped the SSVR2 tables/views: 

[root@db01 ~]# mysql -u root -p <password> -S /var/lib/mysql/mysql.sock ca_uim -A -e "show tables" 

mysql) drop table ssrv2groupwithpath; 

mysql) drop table ssrv2policyprofileblob; 

mysql) drop table ssrv2policytargetstatus; 

mysql) drop table ssrv2probetemplatespackage; 

ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

mysql) drop table ssrv2probetemplateupgrade; 

mysql) drop table ssrv2probetemplatespackage; 

mysql) drop table ssrv2schemamigration; 

mysql) drop table ssrv2templatefilter; 

mysql) drop view ssrv2groupwithpath; 

Dropped the view the script complained about and then we dropped the table-> ssrv2probetemplatespackage

Then followed these steps:

1. Deactivate mon_config_service
2. Delete it from the file system
3. Redeploy it from the local archive on the Primary hub
4. Redeploy the mcs_template probe packages to the Primary Hub
5. Activate mon_config_service
6. Wait around 20 minutes then check again

MySQL 5.7 version being used was the Community version, and not a commercial version of MySQL (Standard/Enterprise), and as of UIM v9.02, that is not currently tested nor supported. 

Help doc reference noting support for MySQL type.
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/9-0-2/installing/pre-installation-planning/install-and-configure-your-database-software/mysql-server.html

These are the 'commercial' editions of MySQL:

• MySQL Standard Edition
• MySQL Enterprise Edition
• MySQL Cluster Carrier Grade Edition