This error can be few things
- The hub licenses had expired and the data engine is not able to connect to the database.
- wasp data engine address are case sensitive
- wrong address on any probe that is listed under ump_common on wasp portal probe (maintenance_mode, ems, nas, ace, automated_deploy_engine, discovery_server, mpse, sla_engine and udm_manager).
- my.cnf file has the entry "ONLY_FULL_GROUP_BY"
Resolutions:
Item 1 put the new licenses on the primary hub, restart the hub, on the portal wasp open the raw configure, remove the value for connection and restart the wasp probe.
Item 2 after you configure the right data_engine address on the wasp, go to raw configure, remove the value for connection and restart the wasp probe.
Item 3 after you configure the right address for the probes (maintenance_mode, ems, nas, ace, automated_deploy_engine, discovery_server, mpse, sla_engine and udm_manager), go to raw configure, remove the value for connection and restart the wasp probe
Item 4 check the my.cnf to make sure this is not set in the defaults. You might see something like this in the my.cnf:
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
if you see "ONLY_FULL_GROUP_BY" on this list, remove it