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: