Not getting any data for the 'Site' category. Data for other metric categories is showing up.
We found the entry below in the in ecrit log:
ecdbpushd: (3) execute failed: LOAD DATA CONCURRENT INFILE "/home/agent/db/sqldb/Site/Site.Site.ecdbpushd.load"
Software Bug. This problem is being tracked as CR0233565. There is a period of time once a day (in the evening) when a database rotation/change is done. FxM was not doing a database lock when its database rotation (ageing) process ran. That resulted in the corrupted database. The Database fix utility in command line Console Program should automatically handle missing partitions
Download and apply hotfix fxm_5-3-1-5m_modi64.pkg from the URL below:
Perform a manual sqlfix and let the system run a few hours. The file sqlfix.txt is attached to this Solution. Instructions:
1. scp the attached file to the appliance using the support account
2. ssh into the appliance using the support account
3. su setup
4. Enter 6,z,shell in the console menu
5. cd /home/support
7. ecprocctrl -c start -p mysqld
8. sqlconfig --execute -f sqlfix.txt
Issue resolved in hotfix 5-3-1-5m.