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






  







3 comments:

  1. SAP HANA is an in-memory data platform that is designed to handle large amounts of data and perform real-time analytics. If you're interested in learning how to use this powerful platform, then the SAP HANA Course in Gurgaon offered by ERP Training Gurgaon might be the right choice for you.

    ReplyDelete
  2. APTRON’s esteemed Android Training Institute in Noida. With a commitment to excellence and a proven track record, APTRON Noida stands as the perfect launchpad for your career aspirations.

    ReplyDelete