Usage Data is showing "No Data"

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• CA Performance Management - Data Polling

Issue/Introduction

After upgrading CAPM, the Usage Data section of System Status is showing NULL

Cause

When upgrading CAPM, SSH connection to the server was lost and MySql never finished upgrading:

/opt/CA/MySql/mysql_upgrade_results.txt contained the following error:

mysql_upgrade: [Warning] Using a password on the command line interface can be insecure. mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/production/1zl/ca/MySql/data/mysql.sock' (2) while connecting to the MySQL server Upgrade process encountered error and will not continue.

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

Rerunning the CAPC installer to finish upgrading MySql resolved the problem.