"Not all prerequisites are met" warning message in MySQL SQL PI dashboard (4368615)

"Not all prerequisites are met" warning message in MySQL SQL PI dashboard

In the MySQL SQL PI dashboard, "Not all prerequisites are met" warning message gets displayed even with all prerequisites set in the monitored Database

Pre-requisite data collection has been disabled or removed from the SQL PI agent

MySQL SQL PI has the following collections enabled by default,

1. MySql_Usability
2. MySql_Wait_Statistics
3. MySql_Prerequisites

Please check the status of the Pre-requisite collection, it should be enabled. Follow the below steps to check the status of the collection,

1. Navigate to "Administration" | "Agents" | "Agent Status" dashboard
2. Select the MySQL SQL PI agent and click "Edit Properties"
3. Click on "Modify the private properties for this agent." link
4. Scroll down and look for the "Collection Details"
5. Click on the "Edit" button next to the "Collection Details"
6. Double check if the "MySql_Prerequisites" collection is enabled, if disabled then click "false" under the "Collection Enable" column and select "true". 
7. Click "Close"
8. Restart the SQL PI agent.

Below are the collection parameters for "MySql_Prerequisites" collection,

Collection Name:                    MySql_Prerequisites
Display Name:                        MySql PI Prerequisites
Description:                            MySql PI Prerequisites
Offline Frequency (Sec):        7200
Online Frequency (Sec):        7200
Real-Time Frequency (Sec):  7200
Collection Enable:                   true
Query Timeout:                       180

MySql SQL PI, Prerequisites