on 02-02-2014 8:03 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Could you post the content of the log file so we can take a look at it.
Thanks
Frederik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.