sap hana on BW

[Former Member]

Dear Experts,

I have upgraded Hana database revision 100 (SPS10) from SPS8 recently  and installation successfully completed on BW on HANA and Database is running but when i start the sap system i got the error "

Database is not available via R3trans

-

---

Database db must be started first"

And also when i checked from the application system using "R3trans -d" I got the error "

This is R3trans version 6.24 (release 742 - 11.08.14 - 17:21:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = HDB                              ---  SERVER = '' PORT = ''"

R3trans finished (0012).

Please also find the error log of trans.log "

4 ETW000    Database release is HDB 1.00.102.02.1446663129                            25  0.022760

4 ETW000    *** ERROR => Using non supported HANA version: 1.00.102.02.1446663129

4 ETW000                                                                                27  0.022787

4 ETW000    *** ERROR => Min. version for this release must be 1.00.62                10  0.022797

4 ETW000     -> SetSdbDbslCA(errcode=0)                                               15  0.022812

4 ETW000     -> disconnect(con_hdl=0)                                                  8  0.022820

4 ETW000    Disconnecting from connection 0 ...                                        8  0.022828

4 ETW000    Now I'm disconnected from HDB                                            395  0.023223

4 ETW000     -> freeConnection(con_hdl=0)                                             16  0.023239

4 ETW000       close all opened locators of connection 0                               9  0.023248

4 ETW000    } DbSlHDBConnect(rc=19)                                                   23  0.023271

4 ETW000    { DbSlHDBControl(con_hdl=0,command=41,arg_p=d7c498)                       22  0.023293

4 ETW000    } DbSlHDBControl(rc=0)                                                    12  0.023305

4 ETW000    { DbSlHDBControl(con_hdl=0,command=14,arg_p=7fffdb845490)                  8  0.023313

4 ETW000    } DbSlHDBControl(rc=0)                                                     7  0.023320

4 ETW000    { DbSlHDBControl(con_hdl=0,command=50,arg_p=7fffdb8454a8)                  9  0.023329

4 ETW000    } DbSlHDBControl(rc=0)                                                     9  0.023338

4 ETW000    { DbSlHDBControl(con_hdl=0,command=13,arg_p=7fffdb845400)                  8  0.023346

4 ETW000    } DbSlHDBControl(rc=0)                                                     7  0.023353

4 ETW000    { DbSlHDBControl(con_hdl=0,command=52,arg_p=7fffdb845450)                  7  0.023360

4 ETW000    } DbSlHDBControl(rc=0)                                                     8  0.023368

2EETW169 no connect possible: "DBMS = HDB                              ---  SERVER = '' PORT = ''"

4 ETW000    release memory of the SIBU buffers                                       155  0.023523

4 ETW000    release memory of the STATEMENT CACHE                                     13  0.023536

Is BW on HANA not supported the SPS10 revision. Please advice.

-Warm regards,

Yonten Tshering

[Shubham1]

Hello

Please refer to SAP Note - 2193110.

If you are using SAP BW on HANA , please check ABAP related notes which are mentioned in the above note.

Regards

Shubham

[Former Member]

Hi Yonten,

Please check below sap notes

2250144 - Unable to connect ERP application server to HANA Database

1828028 - DBCON connection to remote HANA database cannot be established

Check for logs in /var/log/messages for any suspicious entries regarding user authentication.

Regards,

Prithviraj.

[Former Member]

Dear experts,

Still I'm not able to resolve the issue after upgrading the kernel also. It works first but again it is not working. Please find my trans.log file as given below:

4 ETW000 R3trans version 6.25 (release 742 - 07.10.15 - 17:42:42).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 20.04.2016 - 09:34:10

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000  [     dev trc,00000]  Wed Apr 20 09:34:10 2016

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

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

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

4 ETW000  [     dev trc,00000]  DBHDBSLIB : version 742.06, patch 0.300 (Make PL 0.300)

4 ETW000  [     dev trc,00000]  HDB shared library (dbhdbslib) patchlevels (last 10)

4 ETW000  [     dev trc,00000]    (0.300) SAP Support Package Stack Kernel 7.42 Patch Level 300 (note 2237353)

4 ETW000  [     dev trc,00000]    (0.222) Describe on a decimal datatype with a large scale value (note 2220646)

4 ETW000  [     dev trc,00000]    (0.217) Use connection variables instead of table M_CONNECTIONS (note 2207349)

4 ETW000  [     dev trc,00000]    (0.211) Check session information before each SQL call (note 2191987)

4 ETW000  [     dev trc,00000]    (0.210) Cancel FDA SQL statement (note 2177669)

4 ETW000  [     dev trc,00000]    (0.114) Netweaver for HANA on linuxppc64 (note 2150817)

4 ETW000  [     dev trc,00000]    (0.114) SSFS connect with shadow user (note 2154936)

4 ETW000  [     dev trc,00000]    (0.111) R3szchk uses LAST_ESTIMATED_MEMORY_SIZE with HANA rev. 91 (note 1952609)

4 ETW000  [     dev trc,00000]    (0.111) R3load with deferred lob writing (note 2147622)

4 ETW000  [     dev trc,00000]    (0.110) FDA in a non unicode system disabled (note 2130541)

4 ETW000  [     dev trc,00000]

4 ETW000  [     dev trc,00000]  Loading SQLDBC client runtime ...

4 ETW000  [     dev trc,00000]  SQLDBC Module  : /usr/sap/BPD/hdbclient/libSQLDBCHDB.so

4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB 1.00.102.02 Build 1446663129-1530

4 ETW000  [     dev trc,00000]  SQLDBC client runtime is 1.00.102.02.1446663129

4 ETW000  [     dev trc,00000]  Try to connect via secure store (DEFAULT) on connection 0 ...

4 ETW000  [dbhdbsql.cpp,00000]  *** ERROR => Connect to database failed, rc=1, rcSQL=10

4 ETW000  [     dev trc,00000]  SQLCODE    : 10

4 ETW000  [     dev trc,00000]  SQLERRTEXT : authentication failed

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 10     performing CON

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>authentication failed

2EETW169 no connect possible: "DBMS = HDB                              ---  SERVER = '' PORT = ''"

Kindly help on this to resolve the issue.

-warm regards,

Yonten Tshering

[Former Member]

Hi Yonten,

The error log clearly says this is an authentication error. Have you changed any of the SSFS or DB user password ? If so, you need to update the password in application layer by following command.

hdbuserstore set default <dbhost>:<dbport> <dbuser> <dbpassword>

Then run following command to check

hdbuserstore list

Let me know if it worked.

[Former Member]

Hello,

We have changed the Default SSFS master keys on HANA. Do we have to change the key again after upgrades.

please help!

-warm regards,

Yonten

[Former Member]

Are you sure that you are running rev. 100? By looking at the R3trans output I would assume that you are on rev 102, most likely maintenance rev. 02:

"Database release is HDB 1.00.102.02.1446663129"

Is it possible that your R3trans version is out of date?

This message puzzles me:

"Min. version for this release must be 1.00.62 ". 1.00.102 is indeed a higher version than 1.00.62, so it might be a bug in R3trans (or somewhere around in the startup scripts) which is caused by the 3 digit version.

Regards

Thorsten

[Former Member]

Dear Nitsch,

  Yes, your right, it is sps10 revision 102. I forgot to upgrade HANA client on application side after upgrading on HANA Server. May be this could be the reason.

Is this the caused of issue?

-warm regards,

Yonten Tshering

[Former Member]

Hi Yonten,

You are advised to upgrade to patch 110 rather than 102 as there is a performance bug in 102 which can cause very slow response times (in certain situations).  This won't fix the R3trans error, but if you are upgrading, then go to the latest version.

http://service.sap.com/sap/support/notes/2296807

Regards,

Graham

[Former Member]

I'm not sure if the older HANA client version is causing this error, but you should upgrade the client version anyway. (see eg. SAP note 2275609: "If you upgrade from a lower SAP HANA SPS, it is recommended to update ALL other components (Studio, ..., DB Clients, ...) to at least the minimal version of SAP HANA SPS 10")

Regards,

Thorsten

[Former Member]

Dear Thorsten,

Just to inform you that i have upgraded the HANA_DB Client as well but the results are same.

It was connecting fine before upgrading time but after restarting the database then it started not working. But my other servers are working fine.

please help!

-warm regards,

Yonten Tshering

[Former Member]

What about the R3trans version?

Have you checked if there is a newer version available?

If so, I would give it a try.

BTW: Which OS are you using for the NetWeaver part? (just curious :-))

Regards,

Thorsten

[Former Member]

Hi Yonten,

This is a known error from SPS 09 onwards where the revision indicator has changed to 3 places (1.XX.XXX). Its a clear indication from trans.log that you are using old DBSL version. Please make sure your patch level is latest for 742 release. Upgrade your kernel on application server and that will fix the issue.

Thanks

[Former Member]

Dear Dash,

   I have upgraded the kernel on application server to latest and could solved the issue of " R3trans -d" but when i start the sap system it still gives Database is not available via R3trans.

Kindly help on this.

-warm regards,

Yonten Tshering

[Former Member]

Dear Nitsch,

We are using SuSE linux 11 sp2 and our Hana database is in sp3.

Is this because of different SP?

-warm regards,

Yonten Tshering

[Former Member]

No, that should make no difference.