Get error: Failed to generate the Usage Audit Report - 500 Server Error

Products

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

Issue/Introduction

Trying to download the usage audit data from enterprise dashboard but getting the following error.

Get error: Failed to generate the Usage Audit Report - 500 Server Error 

Cause

MySQL instance not case insensitive

Environment

Release: All supported releases of DevTest with MySQL
Component: ITKOTF

 

Resolution

The workaround:

In the /etc/my.cnf file can you add the below lines and restart MySQL.

lower_case_table_names = 1

This will make the table names case-insensitive.

Then restart the Enterprise Dashboard and pull the report again.

Resolved issue.