- Community Home
- >
- Networking
- >
- IMC
- >
- Re: HP IMC Standard new install no Performance Mon...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2021 06:51 AM - last edited on тАО10-22-2021 08:25 PM by support_s
тАО10-22-2021 06:51 AM - last edited on тАО10-22-2021 08:25 PM by support_s
We've moved our IMC install to a new Windows 2016 VM, running it on MySQL DB, and have no information in the performance monitoring systems, including the real-time data.
SNMP is definitely working, as well as SSH, ICMP, etc. to all of the switches. We have info, config backups, and can successfully connect to each device, but have no performance data.
I'm a bit of a novice at this, and I'm at a loss as to what to check next.
imcperfdm is running and each device added to the system has the standard monitors assigned.
Any ideas on buttons to press or knobs to switch? Or a troubleshooting guide?
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2021 07:37 AM
тАО10-22-2021 07:37 AM
Re: HP IMC Standard new install no Performance Monitor Data
Hello @jayburling ,
What is the IMC software version?
I believe Performance Management is under 'Resource' Tab.
Please refer user guidef from below link:
https://support.hpe.com/hpesc/public/docDisplay?docId=emr_na-c05367573
Thanks!
![Accept or Kudo](/html/assets/hpe_banner_SME_signature.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2021 07:50 AM
тАО10-22-2021 07:50 AM
Re: HP IMC Standard new install no Performance Monitor Data
We are running iMC PLAT 7.3 (E0706).
I'm familiar with where the performance data should appear because it was working on our old system.
I'll give the user guide another look to see what I can find.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2021 12:41 AM
тАО10-25-2021 12:41 AM
SolutionHello,
Are you running MySQL 8.0? There is a known issue with performance monitoring not showing when local-infile is not configured on the DB.
Error in imcperfdm log is: [ERROR (3948)] [THREAD(11156)] [CQvDBConnADP::executeSQL] Execute "LOAD DATA local INFILE 'C:/Program Files/iMC/server/bin/../../server/data/perfdm/perf_data_11156_6.dat' INTO TABLE td_2horigindata_6 FIELDS TERMINATED BY ',' " failed, errorMsg:Loading local data is disabled; this must be enabled on both the client and server sides
To fix it follow these steps:
- Stop IMC from IDMA.
- Find your MySQL my.cnf/my.ini config file and edit it.
Add the local-infile line under the mysqld and mysql designators:
[mysqld]
local-infile = 1
[mysql]
local-infile = 1
- Restart the server.
- Start IMC from IDMA.
Hope that helps.
Justin
Working @ HPE
![Accept or Kudo](/html/assets/hpe_banner_SME_signature.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2021 08:31 AM
тАО10-25-2021 08:31 AM
Re: HP IMC Standard new install no Performance Monitor Data
This is definitely the error we are getting when I pull the logs, but I am having trouble locating the correct conf/ini file to modify to fix the issue.
I found and modified to no success files in:
- %PROGRAMDATA%\MySQL
- %PROGRAMDATA%\MySQL\MySql Server 8.0\
Should I create a copy of one and drop it in my %BASEDIR% folder for MySQL?
I'm referencing this helpfile from MySQL: MySQL :: MySQL 8.0 Reference Manual :: 4.2.2.2 Using Option Files
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2021 09:14 AM
тАО10-25-2021 09:14 AM
Re: HP IMC Standard new install no Performance Monitor Data
I got it. I had to add one more thing: enabling local-infile in MySQL from the console.
Thank you for your assistance!