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

Products

• CA Application Test
• Service Virtualization
• CA Continuous Application Insight (PathFinder)
• CA Service Virtualization (DevTest / LISA / VSE / Application Test)

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:
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.