Kernel Error for SAP NetWeaver 7.4 on Windows Server 2012 and SAP HANA DB

[Former Member]

Hi Experts,

I am trying to update SAP Kernel. I have done it before without problems but now SAP instance do not go up. I installed SAP NetWeaver 7.4 on Windows Server 2012 and SAP HANA Database on SUSE. Kernel patch level installation is on 28.... I want to update it to level 200. The error written on dev_w0 is:

Wed Jul 08 17:40:58 2015

M  calling db_connect ...

B  Loading DB library 'C:\usr\sap\N74\DVEBMGS00\exe\dbhdbslib.dll' ...

B  Library 'C:\usr\sap\N74\DVEBMGS00\exe\dbhdbslib.dll' loaded

B  Version of 'C:\usr\sap\N74\DVEBMGS00\exe\dbhdbslib.dll' is "742.06", patchlevel (0.114)

C  Callback functions for dynamic profile parameter registered

B  read_con_info_ssfs(): DBSL supports extended connect protocol

B   ==> connect info for default DB will be read from ssfs

B  *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : SSFS-4218: Record with key "DB_CONNECT/DEFAULT_DB_USER" not found in secure storage <-- SSFS-4215: Data file "C:\usr\sap\N74\SYS\global\security\rsecssfs\data\SSFS_N74.DAT" exists, but does not contain the requested entry

[dbcon.c      5925]

B  *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

[dbcon.c      4953]

M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 79]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2407]

at first I thought was something wrong with my HANA DB user and I checked it but I did not find anything wrong with credential. So I checked connection with "R3load -testconnect" and I got the error:

C:\Users\n74adm>R3load -testconnect

R3load=>sapparam(1c): No Profile used.

R3load=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

R3load: START OF LOG: 20150709103214

R3load: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

R3load: version R7.42/V1.8 [UNICODE] Compiled Nov 26 2014 19:43:53

R3load -testconnect

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.023) R3load: Memory overwrite when converting cluster tables (note 2074445)

DBSL patchinfo (patches.h): (0.114) Netweaver for HANA on linuxppc64 (note 2150817)

--------------------- End of patch information -------------------------

process id 1352

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 28

R3load: job finished with 1 error(s)

R3load: END OF LOG: 20150709103215

I also checked "R3trans -d" and it shows me the next error:

C:\Users\n74adm>R3trans -d

This is R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09).

unicode enabled version

2EETW000 Internal implementation error: function sql_info() in twsql.c not complete for DBMS

2EETW169 no connect possible: "unknown DBMS                                  - not supported by R3trans"

R3trans finished (0012).

Then I tested with Kernel 101 and I got the same result. The strangest thing is when I test it with Kernel level 28 everything is working OK and SAP instance go up. The path where I downloaded SAP Kernel:

Support Packages and Patches - K " --> SAP KERNEL 64-BIT UNICODE" --> SAP KERNEL 7.42 64-BIT UNICODE --> Windows on x64 64bit

Here I download:

#Database independent level 200 and SAP HANA Database level 200.

It appears that SAP Kernel for Windows & HANA Database SP09 works OK with Kernel patch level 28. All my parameters and variables seems to be OK, otherwise SAP would not go up. Hope you can help me. Best Regards my friends.

David Cortes

[former_member230159 · Accepted solution]

Hi David,

Can you please share trans.log here

Regards,

[Former Member · Accepted solution]

Hi Manjunath,

Thank you for all your help. The error log:

C:\Users\n74adm>R3trans -d

This is R3trans version 6.25 (release 742 - 06.05.15 - 20:15:05).

unicode enabled version

2EETW000 Internal implementation error: function sql_info() in twsql.c not compl

ete for DBMS

2EETW169 no connect possible: "unknown DBMS                                  - n

ot supported by R3trans"

R3trans finished (0012).

Another log that I found using SUM, which was the main reason I am trying to upgrade kernel is giving me the next error:

4 ETW000 C:\SUM\abap\exe\R3trans.EXE version 6.25 (release 742 - 03.06.15 - 20:15:06).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 14.07.2015 - 17:26:08

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: C:\SUM\abap\exe\R3trans.EXE -d -w C:\SUM\abap\log\DBCONNCHK.LOG

4 ETW000  trace at level 1 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Tue Jul 14 17:26:09 2015

4 ETW000  [     dev trc,00000]  Loading DB library 'dbhdbslib.dll' ...

4 ETW000  [     dev trc,00000]  Library 'dbhdbslib.dll' loaded

4 ETW000  [     dev trc,00000]  Version of 'dbhdbslib.dll' is "742.06", patchlevel (0.210)

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): DBSL supports extended connect protocol

4 ETW000                         ==> connect info for default DB will be read from ssfs

4 ETW000  [dbcon.c     ,00000]  *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : SSFS-4218: Record with key "DB_CONNECT/DEFAULT_DB_USER" not found in secure storage <-- SSFS-4215: Data file "\\VSDATSAPNW74\sapmnt\N74\SYS\global\security\rsecssfs\data\SSFS_N74.DAT" exists, but does not contain the requested entry

4 ETW000  [dbcon.c     ,00000]  *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

2EETW000 Internal implementation error: function sql_info() in twsql.c not complete for DBMS                                

2EETW169 no connect possible: "unknown DBMS                                  - not supported by R3trans"

Hope you can help me.

Best Regards my friend.

David Cortes

[former_member189797 · Accepted solution]

HI David,

Error seems related to SSFS.
Did you setup the SSFS on your system ?

Please check the Note

1639578 - SSFS as password store for primary database connect

BR,
Gaurav

[Former Member · Accepted solution]

Hello David,

Please check SAP note :-

1643080 - SYB: Database connect information for Sybase ASE

1639578 - SSFS as password store for primary database connect

If you still get error,

Let me know

Regards

Anand

[Former Member · Accepted solution]

Hi Gaurav,

You were right!!! after applying note: 1639578 - SSFS as password store for primary database connect I only have to set the three parameters:

rsecssfx put DB_CONNECT/DEFAULT_DB_USER <userdb:SAPABAP1> -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <password>

rsecssfx put DB_CONNECT/DEFAULT_DB_CON_ENV <hostnamehanadb:3XX15> -plain

and change the parameter in the profile:

rsdb/ssfs_connect = 1

and everything went good....

Thank you so much for everything my friends.

Best Regards

David Cortes

[Former Member · Accepted solution]

Hi Anand,

Thank you so much for all. As you said, after applying note 1639578 - SSFS as password store for primary database connect everything goes perfect.

Regards my friend

David Cortes

[Former Member · Accepted solution]

Thanks David for those encouraging words...would continue to help.

Regards

Anand

[Former Member · Accepted solution]

Hi David,

I'm getting same error need help to put below entry

I have window 2012 server while open command prompt went to security folder and putting

rsecssfx put DB_CONNECT/DEFAULT_DB_USER <name> -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <pwd>

then getting rsecssfx not recognised.

Please help to provide procedure how to add above entry.

Regards,

Santosh

[Former Member · Accepted solution]

Hi my friend,

Please enter with the user SIDadm and open a cmd command prompt in order to set the user and password:

Application server on Windows
----------------------------------------------------------------------
If your application server runs on Windows, proceed as follows:

• Determine the value <dir_global> for DIR_GLOBAL on the relevant application server (for example, using transaction AL11).
  
  Note that the specification for SAPGLOBALHOST occurs as a local path with disk drive letters, whereas the specification for other application servers is a UNC path (for example, \\$(SAPGLOBALHOST)\sapmnt\<sid>\SYS\global).
• If you have installed your SAP system in a domain, log on to the operating system as the <domain>/<sid>adm user. Otherwise, log on with the local user <sid>adm.
• Open a command box and execute the following commands:
  • setx RSEC_SSFS_DATAPATH <dir_global>\security\rsecssfs\data
  • setx RSEC_SSFS_KEYPATH <dir_global>\security\rsecssfs\key

Follow also steps 5, 5.1 and 5.2 in order to verify you have proper environment variable set.

Best Regards

David Cortes

[Former Member]

Hello David,

Have you included DBSL Patches in kernel upgrade.

If not update DBSL along with kernel. Then you can check.

Regards

Anand

[Former Member]

Hi Anand,

Thank you so much for your help. I downloaded Database Library "lib_dbsl_210-20012234.sar" which is DBSL libraries. I copied the two archive inside Kernel but I am still having the same error. R3trans is not compatible. I downloaded from:

SAP NetWeaver and complementary products" —> SAP NetWeaver" —> SAP NETWEAVER 7.4" —> Entry by Component" —> Application Server ABAP —> SAP KERNEL 7.42 64-BIT UNICODE —> Windows on x64 64bit —>  SAP HANA database

The problem as you said, is related with these libraries, if I copied the two archive from Kernel 28, which is the one that is working OK, the instance go up with no further problems.

Regards my friend. Hope can give me more hints.