cancel
Showing results for 
Search instead for 
Did you mean: 

Facing issue while trying to connect to HANA Database

SandipJain
Explorer
0 Kudos

Hello guys ,

I was performing a enhancement pack upgrade using SUM tool on HANA DB ,where I got error in the phase

MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE!

The system stopped  responding ,It was not allowing to login through GUI ,so I stopped the System and when try to start it again it is not starting .

The database connection is failing 

When I did a r3trans it gave the following output

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

This is the log of the Retrans file

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

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

4 ETW000  [     dev trc,00000]  SQLCODE    : 591                                                         145  0.792920

4 ETW000  [     dev trc,00000]  SQLERRTEXT : internal error:                                              50  0.792970

Kindly help in identifying why I am not able to connect to the database

In the dev_w* file I got the following error there

ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2158]

Kindly let me know if anyone has faced such issue .

Any help is appreciable.

Thanks and regards

Sandip Jain

Accepted Solutions (1)

Accepted Solutions (1)

SandipJain
Explorer
0 Kudos

Hello  guys,

The issue got resolved after the HANA DB was restarted ,but can  you let me know  the cause of the issue .

If you need the log files do let me know .

Regards

Sandip Jain

Former Member
0 Kudos

HI,

As I told you we faced the same issue during the installation process.

The restart of the database will make the database load its settings from the last successfull savepoint. It is possible that one of your services had already to many failed attemps and then the only way to restart them is to restart your HANA DB. I am glad the issue is solved for you.

Also please markt this question as answered. Thanks in advance.

Regards,

Frederik.

former_member203760
Participant
0 Kudos

Hello Frederik,

I have restated my HANA DB,but still i am getting same issue. Please help me.

Thanks

Jana

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Sandip,

Faced similar issue,  Adapting the Secure Key store Solved this issue.

As per your R3Trans File Log, i think the same should solve the  .

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

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

4 ETW000  [     dev trc,00000]  SQLCODE    : 591                                                         145  0.792920

4 ETW000  [     dev trc,00000]  SQLERRTEXT : internal error:                                              50  0.792970

Regards,

Monica Bhaskar

ugandhar_nandam1
Explorer
0 Kudos

This message was moderated.

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi,

Could you post the content of the log file so we can take a look at it.

Thanks

Frederik    

sunny_pahuja2
Active Contributor
0 Kudos

Hello,

Please check following things:

1) Is your HANA db up? If not, please check index server trace files.

2) Could you please paste complete trans.log?

Thanks,

Sunny

SandipJain
Explorer
0 Kudos

following is  the complete log  of the trans file

ETW000 r3trans version 6.24 (release 740 - 26.09.13 - 20:13:07 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 02.02.2014 - 00:56:56

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

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

4 ETW000  [     dev trc,00000]  Sun Feb 02 00:56:57 2014                                               45084  0.045084

4 ETW000  [     dev trc,00000]  db_con_init called                                                       172  0.045256

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000                                                                                                 231  0.045487

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  57  0.045544

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 35  0.045579

4 ETW000  [     dev trc,00000]  Loading DB library 'dbhdbslib.dll' ...                                   105  0.045684

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbhdbslib.dll"), hdl 0, count 1, addr 000007FEEAE10000

4 ETW000                                                                                               44344  0.090028

4 ETW000  [     dev trc,00000]      using "D:\usr\sap\SHE\DVEBMGS00\exe\dbhdbslib.dll"                    52  0.090080

4 ETW000  [     dev trc,00000]  Library 'dbhdbslib.dll' loaded                                            52  0.090132

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbhdbslib.dll                   125  0.090257

4 ETW000  [     dev trc,00000]  Version of 'dbhdbslib.dll' is "740.10", patchlevel (0.36)                265  0.090522

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbhdbslib.dll                 1449  0.091971

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbhdbslib.dll                 143  0.092114

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                   174  0.092288

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=-1,command=39,arg_p=0000000000000000)            73  0.092361

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    39  0.092400

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=-1,command=10,arg_p=000000000219F1C0)            50  0.092450

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    38  0.092488

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  37  0.092525

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                 315  0.092840

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=-1,command=10,arg_p=0000000141F2B430)           111  0.092951

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    57  0.093008

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             53  0.093061

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  54  0.093115

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          37  0.093152

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                 280  0.093432

4 ETW000  [     dev trc,00000]  { DbSlHDBConnect(con_info_p=0000000000000000)                           2578  0.096010

4 ETW000  [     dev trc,00000]  DBHDBSLIB : version 740.10, patch 0.036 (Make PL 0.37)                   197  0.096207

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

4 ETW000  [     dev trc,00000]    (0.036) Use connect option CURRENTSCHEMA on 2nd db connection (note 1913960)

4 ETW000                                                                                                  72  0.096329

4 ETW000  [     dev trc,00000]    (0.032) Error Handling for Supplier Callbacks of DBSL (note 1903475)

4 ETW000                                                                                                 245  0.096574

4 ETW000  [     dev trc,00000]    (0.030) INT1 swap problem fixed (note 1881003)                          54  0.096628

4 ETW000  [     dev trc,00000]    (0.025) INT1 output parameter overflow (note 1881003)                   44  0.096672

4 ETW000  [     dev trc,00000]    (0.022) Smaller corrections in release 7.40 (th, dp, vmc, dpmon) (note 1821404)

4 ETW000                                                                                                  66  0.096738

4 ETW000  [     dev trc,00000]    (0.015) Omit trace entry on SQL object unknown or already exists (note 1849107)

4 ETW000                                                                                                  68  0.096806

4 ETW000  [     dev trc,00000]    (0.007) Sybase ASE: enable forced committed read (note 1826505)         51  0.096857

4 ETW000  [     dev trc,00000]    (0.006) Exception during startup with higher dbsl tracelevel (note 1600066)

4 ETW000                                                                                                  59  0.096916

4 ETW000  [     dev trc,00000]    (0.002) Invaild returncode by INSERT-SELECT fixed (note 1600066)        46  0.096962

4 ETW000  [     dev trc,00000]    (0.002) Bulk size of lobs optimized (note 1600066)                      41  0.097003

4 ETW000  [     dev trc,00000]                                                                            27  0.097030

4 ETW000  [     dev trc,00000]   -> init()                                                                92  0.097122

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=8) : 0000000003B6EBA0 (24 bytes allocated)            95  0.097217

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=28) : 0000000003F5A440 (68 bytes allocated)           79  0.097296

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=20) : 0000000003B786E0 (104 bytes allocated)          69  0.097365

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=10) : 0000000003B78710 (130 bytes allocated)          58  0.097423

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=14) : 0000000003B78740 (160 bytes allocated)          57  0.097480

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=16) : 0000000003B78770 (192 bytes allocated)          57  0.097537

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=16) : 0000000003B787A0 (224 bytes allocated)         115  0.097652

4 ETW000  [     dev trc,00000]    STATEMENT_CACHE_SIZE = 1000                                            216  0.097868

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=152000) : 0000000003B82480 (152240 bytes allocated)

4 ETW000                                                                                                 171  0.098039

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=2216000) : 000000000ABE0040 (2368256 bytes allocated)

4 ETW000                                                                                                 152  0.098191

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=288000) : 0000000003BA7660 (2656272 bytes allocated)

4 ETW000                                                                                                 173  0.098364

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=16144) : 0000000003BEDB80 (2672432 bytes allocated)

4 ETW000                                                                                                 154  0.098518

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=32048) : 0000000003BF1AB0 (2704496 bytes allocated)

4 ETW000                                                                                                 112  0.098630

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=16) : 0000000003B787D0 (2704528 bytes allocated)

4 ETW000                                                                                               18023  0.116653

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=16) : 0000000003B78800 (2704560 bytes allocated)

4 ETW000                                                                                                  93  0.116746

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=16) : 0000000003B78830 (2704592 bytes allocated)

4 ETW000                                                                                                  67  0.116813

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=16) : 0000000003B78860 (2704624 bytes allocated)

4 ETW000                                                                                                  64  0.116877

4 ETW000  [     dev trc,00000]   -> init()                                                                39  0.116916

4 ETW000  [     dev trc,00000]   -> loadClientRuntime()                                                   50  0.116966

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

4 ETW000  [     dev trc,00000]  SQLDBC Module  : D:\usr\sap\SHE\hdbclient\libSQLDBCHDB.dll             79796  0.196804

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=8) : 0000000003B6EBC0 (2704648 bytes allocated)       92  0.196896

4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB 1.00.60 Build 0379371-1510                 138  0.197034

4 ETW000  [     dev trc,00000]  SQLDBC client runtime is 1.00.60.0379371                                  90  0.197124

4 ETW000  [     dev trc,00000]   -> getNewConnection()                                                    48  0.197172

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=104) : 0000000003BF9C10 (2704768 bytes allocated)

4 ETW000                                                                                                  66  0.197238

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=18168) : 0000000003BFDE00 (2722952 bytes allocated)

4 ETW000                                                                                                 145  0.197383

4 ETW000  [     dev trc,00000]   -> sdb_malloc(size=72) : 0000000003C03A00 (2723040 bytes allocated)

4 ETW000                                                                                                 298  0.197681

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

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

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

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

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

4 ETW000  [     dev trc,00000]  SQLCODE    : 591                                                         145  0.792920

4 ETW000  [     dev trc,00000]  SQLERRTEXT : internal error:                                              50  0.792970

4 ETW000  [     dev trc,00000]   -> SetSdbDbslCA(errcode=591)                                            107  0.793077

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

4 ETW000  [     dev trc,00000]     close all opened locators of connection 0                              79  0.793305

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003C03A00, size=72 (2722952 bytes allocated))       59  0.793364

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003BFDE00, size=18168 (2704768 bytes allocated))

4 ETW000                                                                                                 188  0.793552

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003BF9C10, size=104 (2704648 bytes allocated))

4 ETW000                                                                                                  70  0.793622

4 ETW000  [     dev trc,00000]  } DbSlHDBConnect(rc=99)                                                   44  0.793666

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

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>internal error:                                               84  0.799330

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=41,arg_p=0000000140478E88)          14856  0.814186

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                   217  0.814403

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=14,arg_p=00000000021958D8)             72  0.814475

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

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=50,arg_p=00000000021958D0)             88  0.814603

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    67  0.814670

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=13,arg_p=00000000021958F0)             51  0.814721

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    37  0.814758

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=52,arg_p=0000000002195940)             48  0.814806

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    37  0.814843

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

4 ETW000  [     dev trc,00000]  release memory of the SIBU buffers                                      8190  0.823033

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B787D0, size=16 (2704616 bytes allocated))      105  0.823138

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B78800, size=16 (2704584 bytes allocated))       56  0.823194

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B78830, size=16 (2704552 bytes allocated))       82  0.823276

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B78860, size=16 (2704520 bytes allocated))       50  0.823326

4 ETW000  [     dev trc,00000]  release memory of the STATEMENT CACHE                                     41  0.823367

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003BF1AB0, size=32048 (2672456 bytes allocated))

4 ETW000                                                                                                 106  0.823473

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003BEDB80, size=16144 (2656296 bytes allocated))

4 ETW000                                                                                                  70  0.823543

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003BA7660, size=288000 (2368280 bytes allocated))

4 ETW000                                                                                                  67  0.823610

4 ETW000  [     dev trc,00000]   -> sdb_free(p=000000000ABE0040, size=2216000 (152264 bytes allocated))

4 ETW000                                                                                                  71  0.823681

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B82480, size=152000 (248 bytes allocated))      989  0.824670

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B6EBC0, size=8 (224 bytes allocated))           164  0.824834

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B6EBA0, size=8 (200 bytes allocated))            52  0.824886

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003F5A440, size=28 (156 bytes allocated))           48  0.824934

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B787A0, size=16 (124 bytes allocated))           48  0.824982

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B786E0, size=20 (88 bytes allocated))            52  0.825034

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B78710, size=10 (62 bytes allocated))            46  0.825080

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B78740, size=14 (32 bytes allocated))            49  0.825129

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0000000003B78770, size=16 (0 bytes allocated))             46  0.825175

Also the HANA DB is up

Regards

Sandip

Former Member
0 Kudos

Can you try to restart your database first (HDB STOP/START ). We also faced an issue like this during the installation of our HANA client.  If this does not help please post the log files of sapstart.