If working on Oracle and using either SQL*Plus or SQL Developer you need to run
SQL> set define off;
before you run the script to avoid an issue with a label containing the & character. see here for an explanation.
this process was also used to solve the below error in the MCS logs:
Mar 18 11:08:51:698 [main, mon_config_service] com.microsoft.sqlserver.jdbc.SQLServerException: The statistics 'poller' is dependent on column 'poller'.
Mar 18 11:08:52:205  Controller: Max. restarts reached for probe
Also, for UIM 9.01EA, due to an issue with the V9_0_0_00__Add_SSRV2PolicyProfileBlob_Table.sql migration script added in (.01 EA, after executing the SSRV2_drop_all_tables.sql make sure you also drop the following before executing the Create_SSRV2_tables.sql script:
Note regarding MySQL (Upgrade from UIM 8.5.1 to 9.0.2 with MySQL v5.7)
- If the reset of MCS does not resolve the issues being see with mon_config_service, e.g., not starting, please also check this article:
MCS (mon_config_service) monitoring stopped working after upgrading UIM from 8.5.1 to version 9.0.2