hdbuserstore on MS Windows

[adrianoaugusto_prehs]

Hi Guys,

We know that all SAP services from PAS on MS Windows environment runs as "SAPService<SID>" user.

Here I have the follow enviroment, SAP HANA 2.0 running on Linux and all the PAS are running on MS Windows.

Whats the problem?

When I start the PAS services, is it created the file SSFS_HDB.LCK on folder of the hdbuser store contents (C:\ProgramData\.hdb\<hostname>\S-1-5-21-2323325441-1700720378-3008739438-9641) and all workprocess was ended, with the follow error:

SQLCODE : -10709 C SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made be\ C cause the target machine actively refused it (localhost:7878)) B ***LOG BYM=> severe DB error -10709; work process in reconnect status [dbsh 1191] B ***LOG BY4=> sql error -10709 performing INS on table DDFTX [dbtran 7837] B ***LOG BY0=> Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made because the target machine actively refused it (localhost:7878)) [dbtran 7837] B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'INS' B RSLT: {dbsl=99, tran=1} B FHDR: {tab='DDFTX', fcode=130, mode=1, bpb=0, dbcnt=0, crsr=0, B hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0, B init:p=0000000000000000, init:#=0, wa:p=0X000000FFD99EE670, wa:#=636} B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'INS' B STMT: {stmt:#=0, bndfld:#=0, prop=0, distinct=0, B fld:#=15, alias:p=0000000000000000, fupd:#=0, tab:#=0, where:#=0, B groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0} B CRSR: {tab='', id=0, hold=0, prop=0x10000, max.in@0=0, fae:blk=0, B con:id=6000004, con:vndr=7, val=2, B key:#=3, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=0X000000FFD99EE670} B *** ERROR => InsertDDFTX: db_rsql94() failed: rc = 1 [difunct.c 1679]

[adrianoaugusto_prehs · Accepted solution]

The solution was provided by SAP Note 2789621 - HANA DB Connection Fails due to Unreleased SSFS_HDB.LCK, after HANA Client update, the problem was solved !

[dennispadia]

Hello Andriano,

Can you please check SAP Note 1852017, probably correct entries are not maintained in hdbuserstore for <sid>adm and SAPService<SID>. Can you please check if you are able to perform R3trans -d?

The userstore is not maintained for the correct user. Each operating user that connects to the database uses his own, dedicated userstore. This is especially important for SAP instances running on Windows: All administrative activities are usually done with the user <sid>adm, while the instances use the SAPService<SID> to connect to the database. Therefore, maintaining the correct keys using hdbuserstore only for the <sid>adm will cause the 10061 error.

Regards,

Dennis

[adrianoaugusto_prehs]

Dennis, thanks for your reply.

On the Windows, I cant logon with SAPServiceSID user to be able create the hdbuserstore.

At the note 1852017, indicate to create the Keys, and was recreated but the error remains. In case of Windows instances, the correct keys have to be set for the SAPService<SID> user as well: hdbuserstore -u <domain>\SAPService<SID> SET DEFAULT <host1>:<port>;<host2>:<port>... <user> <pw>

I can connect to database, using R3trans -x or -d but when I started the SGEN, is created a lock file on (C:\ProgramData\.hdb\<hostname>\S-1-5-21-2323325441-1700720378-3008739438-9641 and all work processes are ended, until I remove the lock file

[dennispadia]

Hello Andriano,

Have you checked below SAP Note as it got released recently? Check the version of your HANA client if it is the impacted one.

2789621 - HANA DB Connection Fails due to Unreleased SSFS_HDB.LCK

Probably you should open message to SAP, to investigate them further.

NOTE: If possible, try to update HANA client once in order to eliminate the possibility of having issue with client.

Regards,

Dennis.