- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- HP SIM 5.3 - No events after database move
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
тАО09-18-2009 04:19 AM
тАО09-18-2009 04:19 AM
HP SIM 5.3 - No events after database move
ftp://ftp.compaq.com/pub/products/servers/management/hpsim/SQL2005_Move_HPSIM52.pdf
The DB move was successful however there have been no events in SIM since the software started using the new DB. Events recorded before the DB move are still visible.
Can anyone help determine why SIM has stopped recording events?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2010 03:47 AM
тАО01-06-2010 03:47 AM
Re: HP SIM 5.3 - No events after database move
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2010 04:23 AM
тАО01-06-2010 04:23 AM
Re: HP SIM 5.3 - No events after database move
I went through the process of raising this issue with the HP SIM Support team. After many weeks of sending logs and information to them they were unable to resolve the issue. In the end I took it upon myself to remove and then re-install SIM. During installation you are asked to enter the SQL server and instance name thus allowing the SIM installation process to create the SQL DB on the remote SQL server. This creates the DB with the correct permissions and settings. This fresh re-install meant that we had lost all of our historical SIM events but as we were not particularly concerned about this information the workaround was good for us.
Hope this helps.
Stephen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2010 04:35 AM
тАО01-06-2010 04:35 AM
Re: HP SIM 5.3 - No events after database move
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2013 07:54 AM - edited тАО09-30-2013 07:56 AM
тАО09-30-2013 07:54 AM - edited тАО09-30-2013 07:56 AM
Re: HP SIM 5.3 - No events after database move
Hi all,
I have the same issue, I move from mssql 2008 R2SP2 Enterprise to 2008 R2SP2 Standard, following the official document.
HPSIM start successful but no new events is registered :(
I clear all the events table, but no change.
Some interesting logs :
Caused by: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'NoticePriority', table 'Insight_v50_0_144657998.dbo.notices'; column does not allow nulls.
Best regards,
DC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2013 12:38 PM - edited тАО10-01-2013 12:38 PM
тАО10-01-2013 12:38 PM - edited тАО10-01-2013 12:38 PM
Re: HP SIM 5.3 - No events after database move
Had the same issue and just ended up doing a clean install. Wasn't very difficult to readd the devices as I exported the host list before hand.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2013 07:09 AM
тАО10-02-2013 07:09 AM
Re: HP SIM 5.3 - No events after database move
Did you do a scan for the old servername? The database name is stored at least 3 or 4 times in several files in the config directory.
Kind regards,
Andrew
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2013 01:55 PM - edited тАО10-04-2013 01:56 PM
тАО10-04-2013 01:55 PM - edited тАО10-04-2013 01:56 PM
Re: HP SIM 5.3 - No events after database move
Did you do a scan for the old servername
Yep, i search for the dns name on all file, and i change it everywhere.
I make a rollback, and run on my old database server.
I wait for the 7.2.2 and prepare myself to install from scratch the soft again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2013 11:33 AM
тАО10-07-2013 11:33 AM
Re: HP SIM 5.3 - No events after database move
Just a small tip, export your objects by typing mxnode -ln > c:\nodes.txt. Certificate exports and import is not an option when upgrading from 7.1 to 7.2 due to the security update that creates new certificates.
A better option is to use a new server and use the old server to repair/ replicate the new certificate.
Good luck.
Andrew
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-04-2013 01:30 AM
тАО11-04-2013 01:30 AM
Re: HP SIM 5.3 - No events after database move
Update 7.2.2
Migration of the database still doesnt show new events.