New install of HP SIM 7.3

[Brett_Ozforex]

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

[Tushar Bajpai]

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

[Brett_Ozforex]

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

[MrFreeze]

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)

[shocko]

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.

[shocko]

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. 

[Tushar Bajpai]

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

[Tushar Bajpai]

Can you check the Audit logs on the SQL Server.

[DeKu]

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].

[gw_1966]

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.