- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: since Database migration, nothing is saved
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
06-30-2015 02:09 AM
06-30-2015 02:09 AM
since Database migration, nothing is saved
Hi
i've a very strange behavior
I've migrate Systems Insight Manager 7.4.0 database from a local 2008R2 database to a 2012 remote SQL database
Everything was running fine, i follow the procedure
http://h20565.www2.hp.com/hpsc/doc/public/display?docId=emr_na-c03225518
I've added new clients and other things but yesterday after server restart, all my new servers/settings have disappear as if it did not save my change , or somewhare an update is not working
(i v removed the local SQL server. If i stop the remote SQL server, HP SIM connexion is not working so the right database is used)
if i do a netstat i can see established connexion on remote server and port
there something i did not understand .. :)
thanks for your help
regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2015 09:02 AM
07-01-2015 09:02 AM
Re: since Database migration, nothing is saved
i don't know HP SIM SQL tables but if i select le 1000Top row in IM_ComputerSystem i can't see the new servers i've added ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-05-2015 02:24 AM
07-05-2015 02:24 AM
Re: since Database migration, nothing is saved
Create a backup of the hpsim-ds.xml file located in the <installation directory>\HP\Systems Insight Manager\jboss\server\hpsim\deploy
directory. Do not place the backup file in this directory.
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2015 01:07 AM - edited 07-06-2015 01:08 AM
07-06-2015 01:07 AM - edited 07-06-2015 01:08 AM
Re: since Database migration, nothing is saved
Hi
yes, hpsim-ds.xml file have been modified and it"s the only file, no copy/no backup
FYI i did not find how to run the command
Automated re-registration of a database by executing the mxreconfig command
mxreconfig -m sqlredirect -s dbserver -b dbname -a dbuserDomain\dbuser -p dbport
>mxreconfig -m sqlredirect -s SRV\Instance -b I
nsight_v50_0_165528150 -a DOMAIN\USer -p 1434
This command will update Insight Management to use a new MS SQL database. Before
continuing, be sure you have performed the following steps:
1) Stop the Insight Management services with the command 'partnerservice
-stop all'
2) Be sure the new database is up and running, and that you have adminis
trative access to it.
Continue? (Y/N): Y
Enter the password for the database account "DOMAIN\USer":
Error from MxReconfig: Incorrect DB User ID or Password. Modifying DB credential
s in sqlRedirect mode is not supported. Please provide the current DB credential
s of the Product and try again.
regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2015 01:13 AM
07-06-2015 01:13 AM
Re: since Database migration, nothing is saved
if i launch mxgetdbinfo
everything is fine and point to the new DB