ECC system not able to connect with HANA database

[Former Member]

Hi Gurus,

We have ECC6.0 EHP7 system with HANA database installed. And recently our HANA db server USALVLHANADB was moved to another data center. Since then ECC system is not able to connect with hana db.

SAP HANA databse is up but not able to connect with SAP Server ECC6.0 EHP7

R3trans -d is failing with error.

Below trans.log

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

4 ETW000 [ dev trc,00000] SQLDBC Module : C:\usr\sap\E74\hdbclient\libSQLDBCHDB.dll 1631 0.010889

4 ETW000 [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 1.00.81.00 Build 0392776-1510 80 0.010969

4 ETW000 [ dev trc,00000] SQLDBC client runtime is 1.00.81.00.0392776 48 0.011017

4 ETW000 [ dev trc,00000] -> getNewConnection() 34 0.011051

4 ETW000 [ dev trc,00000] <- getNewConnection(con_hdl=0) 107 0.011158

4 ETW000 [ dev trc,00000] -> checkEnvironment(con_hdl=0) 57 0.011215

4 ETW000 [ dev trc,00000] -> connect(con_info_p=0000000000000000) 48 0.011263

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

4 ETW000 [ dev trc,00000] Mon Aug 31 05:00:47 2015 21018328 21.029663

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

4 ETW000 [ dev trc,00000] SQLCODE : -10709 41 21.029760

4 ETW000 [ dev trc,00000] SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=10060:A connection attempt failed be\

4 ETW000 53 21.029813

4 ETW000 [ dev trc,00000] cause the connected party did not properly respond after a period of time, or established connection\

4 ETW000 47 21.029860

4 ETW000 [ dev trc,00000] failed because connected host has failed to respond) 28 21.029888

4 ETW000 [ dev trc,00000] -> SetSdbDbslCA(errcode=-10709) 33 21.029921

4 ETW000 [ dev trc,00000] -> freeConnection(con_hdl=0) 60 21.029981

4 ETW000 [ dev trc,00000] close all opened locators of connection 0 38 21.030019

4 ETW000 [ dev trc,00000] } DbSlHDBConnect(rc=99) 72 21.030091

4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -10709 performing CON 61 21.030152

4 ETW000 [ dblink ,00000] ***LOG BY0=>Connection failed (RTE:[89006] System call 'connect' failed, rc=10060:A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond)

4 ETW000 63 21.030215

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=41,arg_p=0000000140022E58) 82 21.030297

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 40 21.030337

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=14,arg_p=0000000002065D28) 31 21.030368

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 27 21.030395

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=50,arg_p=0000000002065D20) 30 21.030425

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 36 21.030461

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=13,arg_p=0000000002065D40) 31 21.030492

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 25 21.030517

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=52,arg_p=0000000002065D90) 29 21.030546

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 27 21.030573

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

DEV_W0 logs:

Loading SQLDBC client runtime ...

C SQLDBC Module : C:\usr\sap\E74\hdbclient\libSQLDBCHDB.dll

C SQLDBC Runtime : libSQLDBCHDB 1.00.81.00 Build 0392776-1510

C SQLDBC client runtime is 1.00.81.00.0392776

C

C Try to connect via secure store (DEFAULT) on connection 0 ...

C

C Mon Aug 31 05:37:33 2015

C *** ERROR => Connect to database failed, rc=1, rcSQL=-10709

[dbhdbsql.cpp 347]

C SQLCODE : -10709

C SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=10060:A connection attempt failed be\

C cause the connected party did not properly respond after a period of time, or established connection\

C failed because connected host has failed to respond)

B ***LOG BV3=> severe db error -10709; work process is stopped [dbsh 1247]

B ***LOG BY2=> sql error -10709 performing CON [dblink 573]

B ***LOG BY0=> Connection failed (RTE:[89006] System call 'connect' failed, rc=10060:A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond) [dblink 573]

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 2392]

M

M Info for wp 0

M

M pid = 4832

M severity = 0

M status = 0

M stat = WP_NEW

M waiting_for = NO_WAITING

M workerType = DP_WORKER_DIAWP

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M report = > <

M action = 0

M tab_name = > <

M

M ThIErrHandle: no current incoming request

HDBUSERSTORE info

hd1adm@usalvlhanadb.infor:/usr/sap/HD1/HDB00> hdbuserstore list

DATA FILE : /usr/sap/HD1/home/.hdb/usalvlhanadb.infor.com/SSFS_HDB.DAT

KEY DEFAULT

  ENV : USALVLHANADB:30015

  USER: SAPHD1

hd1adm@usalvlhanadb.infor:/usr/sap/HD1/HDB00>

Please find the attached log file zipped. And provide the solution.

Thanks for your help in advance.

Regards,

Krishna

Logs.txt.zip

[nicholas_chang · Accepted solution]

Please ensure ping is sucessful from SAP CI aka PAS to HDB, and ensure the hostname is correctly maintained in SAP CI hdbuserstore.

You can try to connect issue below command in SAP CI as sidadm.

hdbsql -n <HDB_server>:5**15 -u SYSTEM -p <password>

Hope it helps,

Thanks,

Nicholas Chagn

[Former Member · Accepted solution]

Hi Nicholas,

I have executed your command and i am getting below error.

*-10709 connection failed <RTE: [89006] system call 'connect' failed RC=10061: No connection could be made because the target system actively refused it>

Thanks,

Krishna

[Mofizur · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Hi Rahman,

It is giving a blank screen when i try > telnet Hostname Portno

Thanks,

krishna

[Mofizur · Accepted solution]

Hi Krishna,

That means there is no port/firwall issue between your apps and HANA DB.

You can try Pavan's suggestion with the user SAPABAP1 and see.

hdbuserstore SET DEFAULT <new DC hostname><port> ; SAPABAP1 <PASSWORD>

Thanks,

Mofizur

[nicholas_chang · Accepted solution]

sorry, typo, it should be:

hdbsql -n <HDB_server>:3**15 -u SYSTEM -p <password>

If you are on Windows platform, you should use below command to create hdbuserstore on your SAP CI on windows:

hdbuserstore -u SAPService<SID> SET DEFAULT host.example.com:3**15 SAP<SID> password

** is your hana system number.

Refer to

[Former Member]

This message was moderated.

[srinivaas]

Thanks for you help Mr. Michael Healy.

Finally I solved the issue.

Resolution - Run the below command

Since in the default profile we have hdb/schema = SAPABAP1

After executing the above command, its up and running.

BR

Srini T.

[Former Member]

This message was moderated.

[srinivaas]

This message was moderated.

[Former Member]

This message was moderated.

[davidebruno]

can you send us the content of

R3trand -d -w out.txt

cat out.txt

thanks

[srinivaas]

Hi Bruno,

Please find the R3trans -d ourput

4 ETW000 R3trans version 6.25 (release 742 - 06.05.15 - 20:15:05).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 24.11.2015 - 11:57:18

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d -w out.txt

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

4 ETW000  [     dev trc,00000]  Tue Nov 24 11:57:18 2015

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

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

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

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

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

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]    (0.038) Close all result sets (note 2124493)

4 ETW000  [     dev trc,00000]    (0.038) Initialization of deferred LOB writing for ZDO changed (note 2106186)

4 ETW000  [     dev trc,00000]    (0.032) DBSL supports deferred lob writing with HANA SP9 (note 2106186)

4 ETW000  [     dev trc,00000]    (0.031) Read last SQL message after the connection is closed (note 2104804)

4 ETW000  [     dev trc,00000]    (0.031) Check Enable_Select_Into_Scalar_UDF before the ALTER call (note 2105480)

4 ETW000  [     dev trc,00000] 

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

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

4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB 1.00.091.00 Build 1418659308-1530

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

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 : invalid username or password

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

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>invalid username or password

2EETW169 no connect possible: "DBMS = HDB    

Let us know how to move forward.

Regards,

Srini T

[davidebruno]

4 ETW000  [     dev trc,00000]  SQLERRTEXT : invalid username or password

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

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>invalid username or password

you have to configure the hdbuserstore key

are you sure that the user/password you inserted in DEFAULT key are correct?

[srinivaas]

Hi Bruno,

We have configured the hdbuserstore key.

Also the he user/password inserted in DEFAULT key are correct.

But still the issue exists.

Regards,

Srini T

[former_member183326]

Hello,

Please make sure you are editing these through transaction DBCO. Please also see 1828028 - DBCON connection to remote HANA database cannot be established BR Michael

[srinivaas]

Hi Experts,

ERP system, not able to connect to HDB database after restart the machine. Both machines OS are Linux but different systems.

Log :

sapeh7:eh7adm 65> R3trans -d                                                           This is R3trans version 6.25 (release 742 - 06.05.15 - 20:15:05).

unicode enabled version

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

R3trans finished (0012).

sapeh7:eh7adm 66> startsap

Checking db Database

Database is not available via R3trans

-------------------------------------------

Database db must be started first

Log on to remote server and start database

sapeh7:eh7adm 67>

ECC sid : EH7 (192.168.12)

HANA  sid : HD1 (192.168.14)

I tried to fix the issue by the 1852017 note but no luck.

CMD : hdbuserstore set DEFAULT 192.168.1.12:30015 SAPHD1 xxxxxx

                                                       HANA IP  30IN15 Hana system user  pw   

Could you please help me out from this issue.

Thanks

Srini T.

[former_member183326]

Hello Srini,

Have you tried looking at the troubleshooting guide at: http://wiki.scn.sap.com/wiki/display/TechTSG/SAP+HANA+System+Down%2C+HANA+not+starting

Best Regards,

Michael

[srinivaas]

Hi Michael,

Thanks for your quick response.

I checked the above link, run the ps -ef| grep hdb command also.

Log :

hana1:/usr/sap/HD1/HDB00> ps -ef| grep hdb

hd1adm    4655  4647  2 06:50 ?        00:05:57 /usr/sap/HD1/HDB00/hana1/trace/hdb.sapHD1_HDB00 -d -nw -f /usr/sap/HD1/HDB00/hana1/daemon.ini pf=/usr/sap/HD1/SYS/profile/HD1_HDB00_hana1

hd1adm    4669  4655  4 06:51 ?        00:09:39 hdbnameserver

hd1adm    4735  4655  6 06:51 ?        00:13:39 hdbpreprocessor

hd1adm    4738  4655  2 06:51 ?        00:06:03 hdbcompileserver

hd1adm    4756  4655 99 06:51 ?        06:11:41 hdbindexserver

hd1adm    4759  4655 12 06:51 ?        00:24:55 hdbstatisticsserver

hd1adm    4762  4655  5 06:51 ?        00:10:14 hdbxsengine

hd1adm    5108  4655  3 07:02 ?        00:06:19 hdbwebdispatcher

hd1adm    9285  8447  0 10:13 pts/1    00:00:00 grep hdb

but still unable to up the ECC system, please let me know if I missed anything.

Thanks

Srini T.

[former_member183326]

Hello Srini,

Can you see anything in the nameserver file or indexserver files?

Also, the hdbuserstore key is set to DEFAULT. This one is used by the NetWeaver work processes to connect to the database, in your case this is HANA. So the also make sure this is SAP<SID>.

BR

Michael

[Former Member]

Check your hdbuserstore entry. SAP connects using the HDBUSERSTORE entry named 'default'.

On your ECC server:

$ hdbuserstore list

This should show DEFAULT pointing to the old DB server

$ hdbuserstore delete DEFAULT

$ hdbuserstore set DEFAULT <host>:<SQL port> <User> <password>

For example,

hdbuserstore set DEFAULT host.example.com:30015 SAP<SID> password

The SQL port is 3nn15, where nn is the instance number of the HANA system. After this is done, run 'R3trans -d' or hdbsql to verify the connection works.

You mentioned the HANA client is installed in 'C:/...'. Is your SAP instance running on Windows? Did you do a telnet check to see if the 30015 port is accessible from the SAP application server?

[Former Member]

Hi Chakraborty,

I already tried the steps you mentioned. But still same issue. yes,SAP application is on Windows environment.

thanks

[Former Member]

HI Krishna,

on the application server.. Could you please perform the folowing

>hdbuserstore DELETE DEFAULT

> hdbuserstore SET DEFAULT <new DC hostname><port> ; <SAPSID> <PASSWORD>

and see if the above resolves the issue

In general after moving diffrent DC, hdbuserstore will not get updates. So, you need to manually update the userstore using above commands.

Regards,

Pavan Gunda

[Former Member]

Hi Pavan,

In database instance also we have secure store file location like " /usr/sap/HD1/home/.hdb/usalvlhanadb.infor.com/SSFS_HDB.DAT "

>hdbuserstore list

hd1adm@usalvlhanadb.infor:/usr/sap/HD1/HDB00> hdbuserstore list

DATA FILE       : /usr/sap/HD1/home/.hdb/usalvlhanadb.infor.com/SSFS_HDB.DAT

hd1adm@usalvlhanadb.infor:/usr/sap/HD1/HDB00>

there is nothing showing in SSFS_HDB.DAT file at database location.

Another one is at SAP application side "C:\ProgramData\.hdb\usalvwsec74ud\S-1-5-21-436979835-4093535384-2957063447-1004\SSFS_HDB.DAT"

do i need to set DEFAULT value at application side or Database side? Please confirm.

here user sapsid means SAPABAP1 or SAPHD1? HD1 is my Database SID.

Thanks,

Krishna

[Former Member]

Hi Krishna,

You need to set on Application side.

>hdbuserstore DELETE DEFAULT

> hdbuserstore SET DEFAULT <new DC hostname><port> ; <SAPHD1> <PASSWORD>

Regards,

Pavn Gunda

[Former Member]

Hi Pavan,

i tried what you suggested on Application side, but still getting same issue.

KEY DEFAULT

     ENV : 10.39.170.179:30015

     USER : SAPHD1

Thanks,

Krishna

[Former Member]

Strange !! When you say, you have moved to difrent DC... Have you changed the paramater (RZ10) -> Default profile -> "SAPDBHOST" to new Hostname ??

[Former Member]

Hello Krishna,

Please check following SAP note:-

1828028 - DBCON connection to remote HANA database cannot be established

Regards

Anand

[Former Member]

Hi Anand,

I have checked the note. all the dbsl library files are installed as per the note.

hdbclient location is C:/usr/sap/SID/hdbclient

And also i have place libSQLDBCHDB.dll file in  DVEBMGS00/exe folder and sys/exe also.

i have also set the environment variable PATH = C:/usr/sap/SID/hdbclient

but still same issue with database connection. is there anythhing else i am missing here.

in trans.log below is the error message i am getting..

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

4 ETW000  [     dev trc,00000]  SQLCODE    : -10709                                                       86  21.046133

4 ETW000  [     dev trc,00000]  SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=10060:A connection attempt failed be\

4 ETW000                                                                                                 102  21.046235

4 ETW000  [     dev trc,00000]               cause the connected party did not properly respond after a period of time, or established connection\

4 ETW000                                                                                                  63  21.046298

4 ETW000  [     dev trc,00000]                failed because connected host has failed to respond)        41  21.046339

4 ETW000  [     dev trc,00000]   -> SetSdbDbslCA(errcode=-10709)                                          74  21.046413

4 ETW000  [     dev trc,00000]   -> freeConnection(con_hdl=0)                                            143  21.046556

4 ETW000  [     dev trc,00000]     close all opened locators of connection 0                             101  21.046657

4 ETW000  [     dev trc,00000]  } DbSlHDBConnect(rc=99)                                                  148  21.046805

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error -10709 performing CON                              172  21.046977

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>Connection failed (RTE:[89006] System call 'connect' failed, rc=10060:A connection

attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected

host has failed to respond)

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=14,arg_p=00000000020A59F8)             42  21.047273

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    34  21.047307

4 ETW000 

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

Thanks,

Krishna

[Mofizur]

Hi Krishna,

Can you please add your new DB server host information in your SAP application hosts file and check.

Thanks,

Mofizur

[Former Member]

Hi Rahman,

I have added DB host name in SAP application host file also. but no help.

Thanks,

Krishna

[Former Member]

Hi Krishna

Has your Basis Team done all of the required set-up ensuring firewalls / proxies etc permit the connection of these 2 systems at source and destination.

Regards

Arden