Thursday, December 5, 2019

Get server node failed on connection 0 : rc=437

4 ETW000 R3trans version 6.26 (release 753 - 04.12.17 - 20:17:05).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 06.12.2019 - 10:22:49

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]  Fri Dec  6 10:22:49 2019

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

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

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

4 ETW000  [     dev trc,00000]  switch DBSL TRACE LEVEL from 3 to 1

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

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

4 ETW000  [     dev trc,00000]    (0.100) SAP Support Package Stack Kernel 7.53 Patch Level 100 (note 2608318)

4 ETW000  [     dev trc,00000]    (0.090) DB4: SQL-913 Locks on SQL Packages in the 749 Kernel (note 2581617)

4 ETW000  [     dev trc,00000]    (0.026) Invalid column index at abap itab callback fixed (note 2548665)

4 ETW000  [     dev trc,00000]    (0.019) Avoid SQL in signal handler (note 2525673)

4 ETW000  [     dev trc,00000]    (0.018) Avoid trunction on numeric datatypes (note 2346984)

4 ETW000  [     dev trc,00000]    (0.011) Row count calculation changed (note 2501455)

4 ETW000  [     dev trc,00000]    (0.011) ReadFda with SQLDBC_SUCCESS_WITH_INFO (note 2502106)

4 ETW000  [     dev trc,00000]    (0.009) HANA tenant connection (note 2493371)

4 ETW000  [     dev trc,00000]    (0.007) Column names mist be quoted in the ITAB description (note 2478632)

4 ETW000  [     dev trc,00000]    (0.005) Row not found is traced as an error (note 2478632)

4 ETW000  [     dev trc,00000]

4 ETW000  [     dev trc,00000]  Loading SQLDBC client runtime (pid=32612)...

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

4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB 2.02.023.1499440855

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

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

4 ETW000  [     dev trc,00000]  Attach to HDB : 2.00.033.00.1535711040 (fa/hana2sp03)

4 ETW000  [     dev trc,00000]  fa/hana2sp03 : build_weekstone=0000.00.0

4 ETW000  [     dev trc,00000]  fa/hana2sp03 : build_time=2018-08-31 12:31:44

4 ETW000  [     dev trc,00000]  Database release is HDB 2.00.033.00.1535711040

4 ETW000  [dbsdbsql.cpp,00000]  *** ERROR =>   execute(), rc=1, rcSQL=437

4 ETW000  [dbhdbsql.cpp,00000]  *** ERROR => Get server node failed on connection 0 : rc=437

4 ETW000  [     dev trc,00000]  SQLCODE    : 437

4 ETW000  [     dev trc,00000]  SQLERRTEXT : only commands for license handling are allowed in current state

4 ETW000  [     dev trc,00000]  SQL COMMAND: SELECT TOP 1 D.DATABASE_NAME || '/' || H.VALUE, L.HOST FROM M_DATABASE D, SYS.M_HOST_INFORMATION H, \

4 ETW000  [     dev trc,00000]               SYS.M_LANDSCAPE_HOST_CONFIGURATION L WHERE H.KEY = 'sapsystem' AND L.INDEXSERVER_ACTUAL_ROLE = 'MAST\

4 ETW000  [     dev trc,00000]               ER' ;

4 ETW000  [     dev trc,00000]  Disconnecting from connection 0 ...

4 ETW000  [     dev trc,00000]  Now I'm disconnected from HDB

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

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>only commands for license handling are allowed in current state

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

Please Refer note  no 2670267  (Error: Get server node failed on connection 0 :rc=437)

Solution : This error come when Your SAP Database server License expire .  Install SAP HANA  S/4 Database  License. 

Step :1
First login the SAP market  https://support.sap.com/en/index.html  palace with user id and password .

Then SAP HANA Dashboard is open then click on Request Keys  then register the SAP system on market palace .

Step 2:
Add your SAP database system in Hana studio with SYSTEM user id and password .

Right click on Register HANA System  go to Properties  click on License-

There is 2 Option system license and all licenses

click on System license 
                                        Install license Key ..


Thank You