topic Re: New install of HP SIM 7.3 in Server Management - Systems Insight Manager

New install of HP SIM 7.3

Brett_Ozforex — Mon, 13 Jan 2014 05:51:40 GMT

Hi There

I've just installed done a brand new install of HP SIM 7.3 however fails to install the DB see below for error message

Configuring Server Components (14):
1. Node Security File ..Done
2. Server Property File ..Done
3. Server Authentication Keys ..Done
4. SSH Keys ..Done
5. Status Property File ..Done
6. Task Results Output Cleanup ..Done
7. Database Configuration ..13 Jan 2014 16:37:38,892 INFO [HPSIM_DEBUG] Maximum retry delay to database server : 5000
13 Jan 2014 16:37:38,892 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:37:38,892 INFO [HPSIM_DEBUG] Trying connection to database retry = 0
13 Jan 2014 16:37:44,126 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:37:44,126 INFO [HPSIM_DEBUG] Trying connection to database retry = 1
13 Jan 2014 16:37:49,157 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:37:49,157 INFO [HPSIM_DEBUG] Trying connection to database retry = 2
13 Jan 2014 16:37:54,187 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:37:54,187 INFO [HPSIM_DEBUG] Trying connection to database retry = 3
13 Jan 2014 16:37:59,218 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:37:59,218 INFO [HPSIM_DEBUG] Trying connection to database retry = 4
13 Jan 2014 16:38:04,248 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:38:04,248 INFO [HPSIM_DEBUG] Trying connection to database retry = 5
.13 Jan 2014 16:38:09,278 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:38:09,278 INFO [HPSIM_DEBUG] Trying connection to database retry = 6
13 Jan 2014 16:38:14,309 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:38:14,309 INFO [HPSIM_DEBUG] Trying connection to database retry = 7
13 Jan 2014 16:38:19,339 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:38:19,339 INFO [HPSIM_DEBUG] Trying connection to database retry = 8
13 Jan 2014 16:38:24,369 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
13 Jan 2014 16:38:24,369 INFO [HPSIM_DEBUG] Trying connection to database retry = 9
Failed
Completed with error.

Details can be found in the log files at: C:\Program Files\HP\Systems Insight Manager\logs
Configuration failed to complete due to the following exception:
Connection to the repository server failed.

I've checked database.props config file and this look all correct to me

Anyone have any idea's on how to resloves this?

Cheers,

Brett

Re: New install of HP SIM 7.3

Tushar Bajpai — Mon, 13 Jan 2014 09:35:36 GMT

Is this on MS SQL, if yes check for DB config for Dynamic Ports. It should be 1433.

Re: New install of HP SIM 7.3

Brett_Ozforex — Mon, 13 Jan 2014 20:48:06 GMT

SQL is configured on port 1433 with named Pipes and TCP enabled.

Re: New install of HP SIM 7.3

MrFreeze — Mon, 13 Jan 2014 22:48:11 GMT

Had the same problems with working upgrade from 7.2 to 7.3. Clean install or upgrade fails. I had to move back to 7.2 so I could research more.

Based on what I have had time to diagnose it appears to be possible issue with jtds version 1.3.0 used in HP SIM 7.3.

During SIM 7.3 the install will connect to SQL successfully and will even create a DB, but when the SIM Service starts it will not connect so the the rest of the install / upgrade fails because I believe it is using differnt JDBC modules.

My thought is the installer is using JTDS v1.2 modules still and then service is using v1.3.0 modules based on trying to grap the install temp directory contents that are created C:\InstallTemp

Part of the hpsim.log showing 1.2 module usage during HP SIM 7.3 installation/upgrade

md /c cd C:\InstallTemp & set JAVA_HOME=.\jre & set PATH=.\ & .\jre\bin\java -cp ".;.\jtds-1.2.jar"

I tried updating module to jtds 1.3.1 as well due to release bug fixes included to address sql connectivity to see if I could get service to start but still fails.

Tried all the articles on using useNTLMv2=TRUE in config files.

Tried copying dlls up to the root install folder to replace versions as called out in other forums / kb articles.

HP documentation is not the greatest for calling out Debug logging settings.

My configuration

Single Server Deployment - Windows Server 2008 R2

HP SIM 7.2 Update 2

SQL 2008 R2 (not express)

Re: New install of HP SIM 7.3

shocko — Tue, 14 Jan 2014 15:30:38 GMT

Same problem. I think the driver has changed between the releases and now the useNTLMv2=TRUE is required but where to added it is the issue. I have tired various places in the database.props file to no avail. This could be a bug issue for HP. I have a call open with support now and will post pack any info I get.

Re: New install of HP SIM 7.3

shocko — Thu, 16 Jan 2014 12:51:20 GMT

I reverted to SIM 7.2.2. Tested a clean install of 7.3 in my lab and the same issue with the new JTDS driver. HP support have been on trying everything else even though I have indicated to them that it looks like an issue with the JDTS driver and the fact that we need ot add the useNTLMv2=true param somewhere.

Re: New install of HP SIM 7.3

Tushar Bajpai — Sat, 18 Jan 2014 06:07:25 GMT

Audit Logs from the SQL Server will help in determining the root cause.

Re: New install of HP SIM 7.3

Tushar Bajpai — Fri, 17 Jan 2014 20:24:01 GMT

Can you check the Audit logs on the SQL Server.

Re: New install of HP SIM 7.3

DeKu — Tue, 21 Jan 2014 10:15:05 GMT

i have the same issue

Log from the SQL Server:

SSPI handshake failed with error code 0x80090302, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: x.x.x.x].

Re: New install of HP SIM 7.3

gw_1966 — Tue, 28 Jan 2014 02:39:17 GMT

I am also having the same issue, can someone from hp actually come back with an eta of a solution or work around rather than all of us saying we have an issue.

Grant.

Re: New install of HP SIM 7.3

shocko — Tue, 28 Jan 2014 08:44:38 GMT

I had HP support on 3 times now and making no progress. They tried to modify the IC 7.3 media to include the older JTDS driver form IC 7.2 but no joy. I'll keep you posted. I really think HP should pull the media for the time being.

Re: New install of HP SIM 7.3

Richard_K — Thu, 30 Jan 2014 10:29:19 GMT

nice, i have the same error. I have remove all Versions all SQL Databases and fresh install.. not working.

I want to go backward to 7.2. but it is not possible. It says.. a newer Version already Installed...

How can i override it ? Or what registry entry must be delete that i can reinstall 7.2 Version ?

Re: New install of HP SIM 7.3

Andrew_Haak — Thu, 30 Jan 2014 11:14:25 GMT

Hello Richard,

I would guess an uninstall is needed before installing an older version of HP SIM. Only SIm itself should be enough. WMI, SMH and VCRM can remain on the system. The only thing you need to do after installing SIm is point to the correct VCRM in SIM after installation.

Kind regards,

Andrew

Re: New install of HP SIM 7.3

Richard_K — Thu, 30 Jan 2014 11:31:26 GMT

Thank you Andrew,

but i have all uninstalled. Directory Cleaned under Programm Files/HP but if i start Setup (7.2) it says " a newer Version already installed"

I think it search any Key in Registry

Re: New install of HP SIM 7.3

SDLW721 — Thu, 30 Jan 2014 12:14:54 GMT

Same issue here ,

========== Begin Initial Configuration Record ==========
-------------- Operation = Configure
-------------- Installing Version = C.07.03.00.00
-------------- Date = donderdag 30 januari 2014 12.48 u. CET
-------------- User = s_sim
-------------- Host = hpsim.my.local
-------------- Locale = English (United States)
-------------- Operating System = Windows Server 2008 R2
-------------- Database Type = MSSQL

Configuring Server Components (14):
1. Node Security File
..Done
2. Server Property File
..Done
3. Server Authentication Keys
..Done
4. SSH Keys
..Done
5. Status Property File
..Done
6. Task Results Output Cleanup
..Done
7. Database Configuration
Connecting to database ..
ERROR - Connection to the repository server failed.
...Failed
Exception :Configuration failed to complete due to the following exception:
Connection to the repository server failed.
Completed with error.

Details can be found in the log files at: D:\Program Files\HP\Systems Insight Manager\logs
-------------- Date = donderdag 30 januari 2014 12.49 u. CET
-------------- Operation = Configure
========== End Initial Configuration Record ==========

Any news ? progress

Re: New install of HP SIM 7.3

Andrew_Haak — Thu, 30 Jan 2014 13:05:03 GMT

Hello Richard,
The tree to delete should be:
HKEY_LOCAL_MACHINE\SOFTWARE\Hewlett-Packard\Systems Insight Manager

But that is for the 7.2.0 version, check if an other installation used an other tree..

Kind regards,

Andrew

Re: New install of HP SIM 7.3

Richard_K — Tue, 04 Feb 2014 08:30:48 GMT

Hi, i have now reinstall 7.2.

Thanks for registry entry. But it was an other. It say HP Insight Managemant was newer.. not System Insight Manager... a little different.

Back to the update Problem. What i see, that 7.3. can not connect to the SQL Server

System Log says:

And we see that are user "SA" has only rights in SQL 2008 ...

Re: New install of HP SIM 7.3

CHARL13 — Wed, 05 Feb 2014 09:55:53 GMT

Exactly the same issue here. I'm glad it's not just me.

Re: New install of HP SIM 7.3

shocko — Tue, 11 Feb 2014 22:41:34 GMT

Still waiting on resolution. One methond that might work is reverting to running SIM unde a local account. I'm using a domain one.

Re: New install of HP SIM 7.3

Richard_K — Wed, 12 Feb 2014 06:06:25 GMT

Hi,

we have it use with local account, and don't work.

We have try to install our own SQL server and give all local accounts rights in SQL Servers, so thats not only the SA User are have the rights.

But same error.. SIM can not connect to database.

It does not matter whether we have performed a new installation or an update