Having an issue where MySQL for Linux is not working properly with DevTest 10.2 on Linux.
When starting either the Enterprise Dashboard or Registry when configured for MySQL on Linux, you will get and error similar to the one below:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dashboard_10_2.METRIC' doesn't exist
and
Failed to execute: select COMP_UUID,METRIC_TM,METRIC_VALUE from METRIC where METRIC_TM > ? and METRIC_TM < ? and METRIC_CLASS = ? order by METRIC_TM because: Table 'dashboard_10_2.METRIC' doesn't exist
When inspecting the Database, there is a table named "metric" in all lowercase.
The query is failing because table names in MySQL on Linux are case sensitive.
This will be fixed in the next release of DevTest, but for now the workaround is:
In the /etc/my.cnf file can you add the below lines and restart MySQL.
lower_case_table_names = 1
If the workaround is not acceptable until fixed in a future release, please feel free to open a new Support case and we will provide a patch.