unknown DBMS - not supported by R3trans

[Former Member]

Hi

I upgrading HANA from SPS 10 tot SPS 11.  After upgrade, database starts fine, but SAP start fails, kindly advise:

devhostname:devadm 54> 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 complete for DBMS

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

R3trans finished (0012).

devhostname:devadm 56> tail -f trans.log

4 ETW000  [     dev trc,00000]  Sat Jul 23 11:52:34 2016

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/DH1/SYS/exe/run/dbhdbslib.so' ...

4 ETW000  [     dev trc,00000]  Library '/usr/sap/DH1/SYS/exe/run/dbhdbslib.so' loaded

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/DH1/SYS/exe/run/dbhdbslib.so' is "742.06", patchlevel (0.114)

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 "/usr/sap/DH1/SYS/global/security/rsecssfs/data/SSFS_DH1.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"

[rajesh_ramanlalbohra · Accepted solution]

Please set the hdbuserstore again with correct username and passowrd and server details and port.

[rajesh_ramanlalbohra · Accepted solution]

Also copy the libraries from hdbclient 2 files *.so in the kernel.

[Former Member · Accepted solution]

Hi Rajesh

Thank you, I tested the entry in the hdbuserstore, and it still works:

devhostname:devadm  61> hdbuserstore list
DATA FILE       : /home/devadm/.hdb/devhostname/SSFS_HDB.DAT

KEY DEFAULT
  ENV : devhostname:30115
  USER: SAPBWT

devhostname:devadm 62> hdbsql -U DEFAULT

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands
       \q to quit

hdbsql=> select * from schemas
88 rows selected (overall time 151.767 msec; server time 141.782 msec)

I also copied the .so files from the client to the kernel:

devhostname:/sapmnt/shared/HD1/hdbclient # cp libodbcHDB.so  libSQLDBCHDB.so  pyhdbcli.so /sapmnt/DH1/exe/uc/linuxx86_64
devhostname:/sapmnt/shared/HD1/hdbclient # cp libodbcHDB.so  libSQLDBCHDB.so  pyhdbcli.so /usr/sap/DH1/DVEBMGS11/exe

I unfortunately still get the same issue:

devhostname:devadm 58> R3trans -d

This is R3trans version 6.25 (release 742 - 15.03.16 - 20:16:01).

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

trans.log:

4 ETW000  [     dev trc,00000]  Sat Jul 23 15:12:17 2016
4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/DH1/SYS/exe/run/dbhdbslib.so' ...
4 ETW000  [     dev trc,00000]  Library '/usr/sap/DH1/SYS/exe/run/dbhdbslib.so' loaded
4 ETW000  [     dev trc,00000]  Version of '/usr/sap/DH1/SYS/exe/run/dbhdbslib.so' is "742.06", patchlevel (0.401)
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 "/usr/sap/DH1/SYS/global/security/rsecssfs/data/SSFS_DH1.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"

Kindly advise again.

[former_member182967 · Accepted solution]

Hi Willem,

Please also update HANA client and dbsl in kernel directory in application server.

Not sure. If needed, set DB_CONNECT/DEFAULT_DB_USER and DEFAULT_DB_PASSWORD using rsecssfx according to note 2154997 - Migration of hdbuserstore entries to ABAP SSFS

Regards,

Ning

[Former Member · Accepted solution]

Hi

I implemented the steps in note 2154997 to Migrate hdbuserstore entries to ABAP SSFS, for some reason it did not work:

ENTERED DATA IN SECURE STORAGE:

    rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPBWT -plain
    rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD Password
    rsecssfx put DB_CONNECT/DEFAULT_DB_CON_ENV devhostname:30015 -plain

tail trans.log

4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB 1.00.112.00 Build 1457525470-1530
4 ETW000  [     dev trc,00000]  SQLDBC client runtime is 1.00.112.00.1457525470
4 ETW000  [     dev trc,00000]  Try to connect (DEFAULT) as SAPBWT/<pwd>@devhostname:30015 on connection 0 ...
4 ETW000  [dbhdbsql.cpp,00000]  *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
4 ETW000  [     dev trc,00000]  SQLCODE    : -10709
4 ETW000  [     dev trc,00000]  SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (devhostname\
4 ETW000  [     dev trc,00000]               1:30015))
4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error -10709 performing CON
4 ETW000  [    dblink  ,00000]  ***LOG BY0=>Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (devhostname:30015))
2EETW169 no connect possible: "DBMS = HDB                              ---  SERVER = '' PORT = ''"

I changed the parameter rsdb_ssfs_connect to 0, for it to use the hdbuserstore, this worked R3trans connected, and SAP was able to start:

devhostname:devadm 62>  setenv rsdb_ssfs_connect 0

devhostname:devadm 63> R3trans -d
This is R3trans version 6.25 (release 742 - 15.03.16 - 20:16:01).
unicode enabled version
R3trans finished (0000).

[Former Member · Accepted solution]

Thanks for the response!

For more info, Is there a note on how to update HANA client and dbsl in kernel directory in application server?

It is not covered in the upgrade guide. SAP is running on the same host as the database, so the hana client would have been upgraded as part of the upgrade process, but not the files in the kernel directory.

Also, is it best practice to continue to use the hdbuserstore, or should I get the rsecssfx entries working?  Not sure yet why they fail.

[former_member182967 · Accepted solution]

Hi Willem,

Even SAP application and HANA are located on the same host, the client during HANA installation is installed in directory /hana/shared/<SID>/hdbclient. However, the client during SAP installation is located in directory /usr/sap/<SID>/hdbclient for local or system directory $DIR_CT_RUN for central.

To update HANA client using by application server, you can firstly uninstall it and then install the new version one. For more information, please refer to Uninstall on UNIX or Linux in Interactive Mode - SAP HANA Client Installation and Update Guide - SAP....

For HANA DBSL update, download the latest patch level for your kernel version. Use SAPCAR to extract it into SAP kernel directory.

Hdbuserstore is the default option during installation, no further action is needed (The picture below is from SAP Installation guide using SWPM).

Regards,

Ning

[Former Member · Accepted solution]

Big thanks for the response and explanation