Performance Center gets error on Threshold profiles after Upgrade

Products

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

Issue/Introduction

Threshold profiles gets Query Failed message:ScreenHunter_1043 Jul. 24 17.15.jpg

 

<Please see attached file for image>

Environment

CA PM 3.x

Resolution

Repair the Table items on CAPC Server:

Logon on CAPC box

Stop EM service: /etc/init.d/caperfcenter_eventmanager stop

Execute this commands with Root user:

mysql

mysql use em

mysql> repair table items;

mysql> quit;

Start EM service: /etc/init.d/caperfcenter_eventmanager start