ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 125589

calendar_today

Updated On:

Products

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

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

Cause

Configuration issue with MySQL.

Environment

MySQL with DevTest.

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.