HP Insight Manager Event ID 3

I had this issue yesterday, SQL database was dettached after a reboot, I reattached it and had to change the following config files,

—————————————————————–

File: “C:Program FilesHPSystems Insight Managerjbossserverhpsimdeployhpsim-ds.xml”

<connection-url>jdbc:jtds:sqlserver://Name_of_Server:1433/Insight_v50_0_152026671;

loginTimeout=20;domain=Your_Domain;instance=Your_SQL_Instance</connection-url>

—————————————————————–

File: C:Program FilesHPSystems Insight Managerconfigdatabase.admin
hp.Database.databaseName=Insight_v50_0_152026671
hp.Database.hostName=Your_Hostname
hp.Database.instance=Your_Instance
hp.Database.jdbcDriver=net.sourceforge.jtds.jdbc.Driver
hp.Database.jdbcUrlPrefix=jdbc:jtds:sqlserver
hp.Database.password=Your_Password
hp.Database.portNumber=1433
hp.Database.username=DOMAINYour_Account
MxVersionNumber=C.06.02.00.00

——————————————————————

File: C:Program FilesHPSystems Insight Managerconfigdatabase.props

hp.Database.adminDB=master
hp.Database.adminUser=sa
hp.Database.authType=host
hp.Database.charSet.??=UTF-8
hp.Database.charSet.en=UTF-8
hp.Database.charSet.ja=SJIS
hp.Database.databaseName=Insight_v50_0_152026671
hp.Database.dsn=Insight_v1_0
hp.Database.hostName=Your_Hostname
hp.Database.instance=Your_Instance
hp.Database.jdbcDriver=net.sourceforge.jtds.jdbc.Driver
hp.Database.jdbcUrlPrefix=jdbc:jtds:sqlserver
hp.Database.password=Your_Password
hp.Database.portNumber=1433
hp.Database.schemaFile_1=schema40.sql
hp.Database.schemaFile_10=schema60_61.sql
hp.Database.schemaFile_11=schema61_62.sql
hp.Database.schemaFile_2=DCSchema10.sql
hp.Database.schemaFile_3=schema40_41.sql
hp.Database.schemaFile_4=schema41_42.sql
hp.Database.schemaFile_5=schema42_50.sql
hp.Database.schemaFile_6=schema50_51.sql
hp.Database.schemaFile_7=schema51_52.sql
hp.Database.schemaFile_8=schema52_53.sql
hp.Database.schemaFile_9=schema53_54.sql
hp.Database.schemaFileCount=11
hp.Database.schemaFileNamePrefix=hp.Database.schemaFile_
hp.Database.schemaUpgradeFile=9
hp.Database.schemaUpgradeFile_1=schema40_41.sql
hp.Database.schemaUpgradeFile_2=schema41_42.sql
hp.Database.schemaUpgradeFile_3=schema42_50.sql
hp.Database.schemaUpgradeFile_4=schema50_51.sql
hp.Database.schemaUpgradeFile_5=schema51_52.sql
hp.Database.schemaUpgradeFile_6=schema52_53.sql
hp.Database.schemaUpgradeFile_7=schema53_54.sql
hp.Database.schemaUpgradeFile_8=schema60_61.sql
hp.Database.schemaUpgradeFile_9=schema61_62.sql
hp.Database.schemaUpgradeFilePrefix=hp.Database.schemaUpgradeFile_
hp.Database.schemaUser=sa
hp.Database.sqlSchema=
hp.Database.username=DomainYour_Account
hp.Database.vHandler=com.hp.mx.database.MsSqlVerificationHandler
MxVersionNumber=C.06.02.00.00

Once you setup the config files restart the HP Insight Manager service and look at the mxdomainmgr.0.log log file. 

Log File Location: C:Program FilesHPSystems Insight Managerlogsmxdomainmgr.0.log

 

Leave a Reply

Your email address will not be published. Required fields are marked *