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

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

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

All supported DevTest releases with MySQL.

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.