- Community Home
- >
- Networking
- >
- Legacy
- >
- PCM
- >
- Re: PCM+ 3.20. Problem to see Event and SQL error
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
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
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-24-2011 09:11 AM
10-24-2011 09:11 AM
PCM+ 3.20. Problem to see Event and SQL error
Hi
Since yesterday, I can't see events in PCM + and I have a SQL error (see attachment). I can not also do the backup with the "policy manager" of PCM.
How can I fix this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2011 05:39 AM - edited 10-27-2011 05:42 AM
10-27-2011 05:39 AM - edited 10-27-2011 05:42 AM
Re: PCM+ 3.20. Problem to see Event and SQL error
Hi I got the same error.
it not antivirus or MySQL
any idea ???
"
10/27/2011 14:35:24 - ProCurve Manager is unable to correctly process received events or traps.
Received SNMP traps/events are failing to be recorded in the ProCurve Manager database. The received events are retained in temporary text files until such time as the database condition can be repaired.
The ProCurve Manager database condition MUST be resolved to allow for correct processing of SNMP traps/events.
This problem is most likely caused by:
+ ProCurve Manager and Security Software (Anti-Virus/Anti-Malware) attempting to access the MySQL database files at the same time.
+ External backup tools / operations locking the MySQL database files while ProCurve Manager is attempting to write to them.
To fix this problem, follow these steps:
+ Verify that the Security Software is configured to NOT actively monitor the MySQL database files.
+ Ensure external backup tools are configured to not backup the MySQL database files.
+ MySQL database files location: PNM/server/mysql/data/netmgmt
Resolution Steps:
+ Close the ProCurve Manager Client
+ Stop the HP ProCurve Network Manager Server service
+ Stop the HP ProCurve Datastore service
+ Reconfigure the Security Software / Backup Software to ignore the MySQL database directory
+ Start the HP ProCurve Datastore service
+ Start the HP ProCurve Network Manager Server service
Temporary event/trap data files will accumulate while the ProCurve Manager database is unable to process the received events. There could exist a large number of these files within the PNM/server/data/events/CommonArchive directory. Upon resolution of the ProCurve Manager database condition, ProCurve Manager will process these files, and retain the data in the database.
If this error condition persists, please contact HP Network Support
SQL Exception
Table '.\netmgmt\networkevent' is marked as crashed and last (automatic?) repair failed
"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2011 11:18 AM
10-28-2011 11:18 AM
Re: PCM+ 3.20. Problem to see Event and SQL error
Greetings,
You have a corrupted table in the PCM+ database. You should contact HP Support - they have a utility that can be run on the database to correct this issue. I have heard from other customers that they have opened a call and had PCM+ up and running in the span of a few hours.
Regards,
SVB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2011 11:33 AM
10-28-2011 11:33 AM
Re: PCM+ 3.20. Problem to see Event and SQL error
Before you contact the support,the following data is also required.
Stop all PCM services And zip/collect the following 2 folders
* “Program Files\PNM\server\MYSQL”
* “Program Files\PNM\server\confi
And then contact the support, the files in those folders will be repaired.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2011 02:54 AM - last edited on 10-31-2011 12:16 PM by Warren_Admin
10-31-2011 02:54 AM - last edited on 10-31-2011 12:16 PM by Warren_Admin
Re: PCM+ 3.20. Problem to see Event and SQL error
Hi, I resolved my problem