Enterprise Dashboard MySQL Error - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dbenterprisesqt.METRIC' doesn't exist

Document ID : KB000125589
Last Modified Date : 31/01/2019
Show Technical Document Details
Issue:
Pulling Audit reports and getting error.

Seeing this error in the Enterprise Dashboard log:
2019-01-09 17:57:23,225Z (15:57) [qtp1151964959-30] ERROR com.ca.dradis.controller.LicensingController - Failed to process request:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dbenterprisesqt.METRIC' doesn't exist
Environment:
MySQL with DevTest.
Cause:
Configuration issue with MySQL.
Resolution:
Please add the following syntax in his MySQL configuration file. 

lower_case_table_names=1 

Steps to add this flag. 

1: open terminal 
2: vi /etc/my.cnf 
3: get into insert mode in editor by pressing i button. 
4: add in the section of [mysqld] lower_case_table_names=1 
5: press esc button 
6: press :wq! 
7: restart mysql server. 

Resolved issue.