on 03-27-2013 8:54 AM
Hello,
I have got a problem to start up my NW 7.3 (Windows/maxdb). The only process which appears in process list is strdbs.cmd and it remains yellow (now for two hours or more). When I right-click the process and choose Developer Trace, nothing happens - syslog is also empty. The system was running fine until last week.
Does anybody know this issue or are there another checks I can perform?
Thanks in advance!
Václav
Hello,
my problem was solved in this thread: http://scn.sap.com/message/13953450
I renamed the files NWD.dbm.shi and NWD.dbm.shm in MaxDB workdir, after that the Netweaver is actually running
Thanks a lot for your help guys!
Regards,
Václav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi guys,
thanks for your fast replies! I restarted the server, but without success. I'm not aware of any updates or patches, kernel version should be unchanged since installation (one year ago).
I performed "r3trans -d" with following result in trans.log:
4 ETW000 r3trans version 6.19 (release 720 - 24.08.10 - 14:38:42).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 27.03.2013 - 12:38:07
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] Wed Mar 27 12:38:07 2013 17616 0.017616
4 ETW000 [dev trc ,00000] db_con_init called 543 0.018159
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 545 0.018704
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 33 0.018737
4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library
4 ETW000 531 0.019268
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
But I get the same result when I perform "r3trans -d" on another Netweaver (7.0), which is actually running.
Which additional checks can I perform?
Thanks,
Václav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vaclav,
1) please check using dbmgui whether your database is online
2) Check the results from R3trans -d are positive. In case the result is same as mentioned above
login with sid<adm>
open the command prompt perform following
set dbms/type=ADA
and then again run R3trans -d
This should work, then you have set the same variable in users profile. My computer > properties> advanced --> environment variable.
3) If step (1) and (2) are positive then , open the start profile
Comment the line where it executes start database. This is not required as in step 1 you have ensured your database is already online.
4) Take restart of SAP. Check the results again.
Hope this helps.
Regards,
Deepak Kori
Hi Atul,
I restarted the system and looked for dev_w* and dev_disp, but both were not updated. dev_ms odes not exist in "DVEBMGS00\work". Here is the content of stderr4:
D:\usr\sap\HP3\DVEBMGS00\work>set DBNAME=NWD
D:\usr\sap\HP3\DVEBMGS00\work>set DBNAME=NWD
D:\usr\sap\HP3\DVEBMGS00\work>if "" == "" (set DB_USERKEY="c" ) else (set DB_USERKEY="c_J2EE" )
D:\usr\sap\HP3\DVEBMGS00\work>dbmcli -U "c" db_state 1>adatmp
Unfortunatelly there is not so much info in stderr*, but I hope it helps a little bit.
Thanks a lot!
Václav
Hi,
so I checked if I can connect with maxdb studio to the database, but without success. The studio is stuck during "Getting state of database", I can't even close it.
Then I tried r3trans -d (before that I used the set command, logged on as sidadm). Now I get a more info in trans.log:
4 ETW000 r3trans version 6.19 (release 720 - 24.08.10 - 14:38:42).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 28.03.2013 - 09:53:54
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] Thu Mar 28 09:53:54 2013 0 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 129 0.000129
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 32 0.000161
4 ETW000 [dev trc ,00000] Loading DB library 'dbsdbslib.dll' ... 121 0.000282
4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dbsdbslib.dll"), hdl 0, addr 000007FEEA870000
4 ETW000 10366 0.010648
4 ETW000 [dev trc ,00000] using "D:\usr\sap\HP3\SYS\exe\uc\NTAMD64\dbsdbslib.dll" 29 0.010677
4 ETW000 [dev trc ,00000] Library 'dbsdbslib.dll' loaded 26 0.010703
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbsdbslib.dll 117 0.010820
4 ETW000 [dev trc ,00000] Version of 'dbsdbslib.dll' is "720.00", patchlevel (0.65) 266 0.011086
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbsdbslib.dll 25 0.011111
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbsdbslib.dll 125 0.011236
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 102 0.011338
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=39,arg_p=0000000000000000) 32 0.011370
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 78 0.011448
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000000202F860) 47 0.011495
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 23 0.011518
4 ETW000 [dev trc ,00000] New connection 0 created 21 0.011539
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 57 0.011596
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000014254F468) 61 0.011657
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 23 0.011680
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 20 0.011700
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 30 0.011730
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection: 21 0.011751
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 40 0.011791
4 ETW000 [dev trc ,00000] { DbSlSdbConnect(con_info_p=0000000000000000) 226 0.012017
4 ETW000 [dev trc ,00000] DBSDBSLIB : version 720.00, patch 0.065 (Make PL 0.68) 65 0.012082
4 ETW000 [dev trc ,00000] MAXDB shared library (dbsdbslib) patchlevels (last 10) 25 0.012107
4 ETW000 [dev trc ,00000] (0.065) Send wp type to the database (note 1340617) 38 0.012145
4 ETW000 [dev trc ,00000] (0.062) Row counter limit set to 65535 (note 1340617) 126 0.012271
4 ETW000 [dev trc ,00000] (0.054) ABAP: Return technical database PPMS information (note 1419552)
4 ETW000 46 0.012317
4 ETW000 [dev trc ,00000] (0.053) ABAP: Return technical database PPMS information (note 1419552)
4 ETW000 32 0.012349
4 ETW000 [dev trc ,00000] (0.047) Connection table corrected (note 1466271) 32 0.012381
4 ETW000 [dev trc ,00000] (0.045) Unknown primary key (note 1459400) 33 0.012414
4 ETW000 [dev trc ,00000] (0.039) Define your own command buffersize (note 1340617) 34 0.012448
4 ETW000 [dev trc ,00000] (0.031) Dbm commands support added (note 1420733) 33 0.012481
4 ETW000 [dev trc ,00000] (0.027) Count of records for bulk insert optimized (note 1340617) 34 0.012515
4 ETW000 [dev trc ,00000] (0.021) Connect with special xuser key (note 1390464) 34 0.012549
4 ETW000 [dev trc ,00000] 18 0.012567
4 ETW000 [dev trc ,00000] -> init() 52 0.012619
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=10) : 00000000023DB5C0 (26 bytes allocated) 64 0.012683
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=16) : 00000000023DB5F0 (58 bytes allocated) 120 0.012803
4 ETW000 [dev trc ,00000] STATEMENT_CACHE_SIZE = 1000 131 0.012934
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=152000) : 0000000003B3CF90 (152074 bytes allocated)
4 ETW000 212 0.013146
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=2088000) : 0000000008AA0040 (2240090 bytes allocated)
4 ETW000 87 0.013233
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=288000) : 0000000003B62170 (2528106 bytes allocated)
4 ETW000 250 0.013483
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=16144) : 0000000003BA8690 (2544266 bytes allocated)
4 ETW000 84 0.013567
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=32048) : 0000000003BAC5C0 (2576330 bytes allocated)
4 ETW000 94 0.013661
4 ETW000 [dev trc ,00000] -> loadClientRuntime() 12104 0.025765
4 ETW000 [dev trc ,00000] Loading SQLDBC client runtime ... 49 0.025814
4 ETW000 [dev trc ,00000] Thu Mar 28 09:53:55 2013 435101 0.460915
4 ETW000 [dev trc ,00000] SQLDBC Module : D:\sapdb\clients\HP3\pgm\libSQLDBC77.dll 41 0.460956
4 ETW000 [dev trc ,00000] SQLDBC SDK : SQLDBC.H 7.7.4 BUILD 009-123-173-450 179 0.461135
4 ETW000 [dev trc ,00000] SQLDBC Runtime : libSQLDBC 7.8.2 BUILD 023-121-242-871 70 0.461205
4 ETW000 [dev trc ,00000] SQLDBC client runtime is MaxDB 7.8.2.023 CL 242871 63 0.461268
4 ETW000 [dev trc ,00000] SQLDBC supports new DECIMAL interface : 1 39 0.461307
4 ETW000 [dev trc ,00000] SQLDBC supports VARIABLE INPUT data : 1 23 0.461330
4 ETW000 [dev trc ,00000] SQLDBC supports VARIABLE OUTPUT data : 1 23 0.461353
4 ETW000 [dev trc ,00000] SQLDBC supports Multiple Streams : 1 23 0.461376
4 ETW000 [dev trc ,00000] SQLDBC supports LOB LOCATOR KEEPALIVE : 1 22 0.461398
4 ETW000 [dev trc ,00000] SQLDBC supports LOB LOCATOR COPY : 1 23 0.461421
4 ETW000 [dev trc ,00000] SQLDBC supports BULK SELECT with LOBS : 1 111 0.461532
4 ETW000 [dev trc ,00000] -> getNewConnection() 35 0.461567
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=2160) : 0000000003BB9570 (2578506 bytes allocated)
4 ETW000 35 0.461602
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=1168) : 0000000003BB9E00 (2579690 bytes allocated)
4 ETW000 161 0.461763
4 ETW000 [dev trc ,00000] <- getNewConnection(con_hdl=0) 221 0.461984
4 ETW000 [dev trc ,00000] -> checkEnvironment(con_hdl=0) 53 0.462037
4 ETW000 [dev trc ,00000] -> connect() 43 0.462080
4 ETW000 [dev trc ,00000] INFO : SQLOPT= -I 0 -t 0 -S SAPR3 123 0.462203
4 ETW000 [dev trc ,00000] Try to connect (DEFAULT) on connection 0 ... 189 0.462392
4 ETW000 [dbsdbsql ,00000] *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))
4 ETW000 23030 0.485422
4 ETW000 [dev trc ,00000] -> SetSapdbCA(errcode=-10709) 37 0.485459
4 ETW000 [dev trc ,00000] -> freeConnection(con_hdl=0) 31 0.485490
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003BB9E00, size=1168 (2578506 bytes allocated))
4 ETW000 141 0.485631
4 ETW000 [dev trc ,00000] close all opened locators of connection 0 84 0.485715
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003BB9570, size=2160 (2576330 bytes allocated))
4 ETW000 35 0.485750
4 ETW000 [dev trc ,00000] } DbSlSdbConnect(rc=99) 23 0.485773
4 ETW000 [dblink ,00000] ***LOG BY2=>sql error -10709 performing CON 169 0.485942
4 ETW000 [dblink ,00000] ***LOG BY0=>Connection failed (RTE:[5] database not running) 27 0.485969
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=41,arg_p=00000001405F8278) 86 0.486055
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 61 0.486116
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=14,arg_p=0000000002025E88) 26 0.486142
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 22 0.486164
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=50,arg_p=0000000002025E80) 54 0.486218
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 58 0.486276
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=13,arg_p=0000000002025EE0) 26 0.486302
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 21 0.486323
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=52,arg_p=0000000002025EA0) 26 0.486349
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 21 0.486370
2EETW169 no connect possible: "DBMS = ADABAS D --- DBNAME = ''"
4 ETW000 [dev trc ,00000] release memory of the SIBU buffers 6176 0.492546
4 ETW000 [dev trc ,00000] release memory of the STATEMENT CACHE 62 0.492608
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003BAC5C0, size=32048 (2544266 bytes allocated))
4 ETW000 61 0.492669
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003BA8690, size=16144 (2528106 bytes allocated))
4 ETW000 36 0.492705
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003B62170, size=288000 (2240090 bytes allocated))
4 ETW000 34 0.492739
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000008AA0040, size=2088000 (152074 bytes allocated))
4 ETW000 35 0.492774
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003B3CF90, size=152000 (58 bytes allocated)) 2669 0.495443
4 ETW000 [dev trc ,00000] -> sdb_free(p=00000000023DB5C0, size=10 (32 bytes allocated)) 50 0.495493
4 ETW000 [dev trc ,00000] -> sdb_free(p=00000000023DB5F0, size=16 (0 bytes allocated)) 27 0.495520
I hope this may help to find the problem.
Thanks & Regards
Václav
Hi,
I updated the xuser entries with following command:
xuser -c <domain>\SAPServiceHP3 -U DEFAULT -u SAPHP3,<password> -d NWD -n <hostname> -S SAPR3 -t 0 -I 0 set
But the process strdbs remains yellow. I also tested sqlcli, the result is "database is not running". Finally I tried r3trans with following result:
4 ETW000 r3trans version 6.19 (release 720 - 24.08.10 - 14:38:42).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 28.03.2013 - 19:32:31
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] Thu Mar 28 19:32:31 2013 0 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 10 0.000010
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 34 0.000044
4 ETW000 [dev trc ,00000] Loading DB library 'dbsdbslib.dll' ... 85 0.000129
4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dbsdbslib.dll"), hdl 0, addr 000007FEE9420000
4 ETW000 221162 0.221291
4 ETW000 [dev trc ,00000] using "D:\usr\sap\HP3\SYS\exe\uc\NTAMD64\dbsdbslib.dll" 25 0.221316
4 ETW000 [dev trc ,00000] Library 'dbsdbslib.dll' loaded 27 0.221343
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbsdbslib.dll 7617 0.228960
4 ETW000 [dev trc ,00000] Thu Mar 28 19:32:32 2013 27059 0.256019
4 ETW000 [dev trc ,00000] Version of 'dbsdbslib.dll' is "720.00", patchlevel (0.65) 32 0.256051
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbsdbslib.dll 26 0.256077
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbsdbslib.dll 10402 0.266479
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 8361 0.274840
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=39,arg_p=0000000000000000) 30 0.274870
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 1752 0.276622
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000000202F860) 102 0.276724
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 50 0.276774
4 ETW000 [dev trc ,00000] New connection 0 created 22 0.276796
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 11028 0.287824
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000014254F468) 78 0.287902
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 23 0.287925
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 21 0.287946
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 30 0.287976
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection: 21 0.287997
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 165 0.288162
4 ETW000 [dev trc ,00000] { DbSlSdbConnect(con_info_p=0000000000000000) 72 0.288234
4 ETW000 [dev trc ,00000] DBSDBSLIB : version 720.00, patch 0.065 (Make PL 0.68) 926 0.289160
4 ETW000 [dev trc ,00000] MAXDB shared library (dbsdbslib) patchlevels (last 10) 27 0.289187
4 ETW000 [dev trc ,00000] (0.065) Send wp type to the database (note 1340617) 37 0.289224
4 ETW000 [dev trc ,00000] (0.062) Row counter limit set to 65535 (note 1340617) 137 0.289361
4 ETW000 [dev trc ,00000] (0.054) ABAP: Return technical database PPMS information (note 1419552)
4 ETW000 2787 0.292148
4 ETW000 [dev trc ,00000] (0.053) ABAP: Return technical database PPMS information (note 1419552)
4 ETW000 33 0.292181
4 ETW000 [dev trc ,00000] (0.047) Connection table corrected (note 1466271) 35 0.292216
4 ETW000 [dev trc ,00000] (0.045) Unknown primary key (note 1459400) 34 0.292250
4 ETW000 [dev trc ,00000] (0.039) Define your own command buffersize (note 1340617) 1831 0.294081
4 ETW000 [dev trc ,00000] (0.031) Dbm commands support added (note 1420733) 173 0.294254
4 ETW000 [dev trc ,00000] (0.027) Count of records for bulk insert optimized (note 1340617) 770 0.295024
4 ETW000 [dev trc ,00000] (0.021) Connect with special xuser key (note 1390464) 37 0.295061
4 ETW000 [dev trc ,00000] 19 0.295080
4 ETW000 [dev trc ,00000] -> init() 2310 0.297390
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=10) : 0000000003C2C470 (26 bytes allocated) 88 0.297478
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=16) : 0000000003C2C4A0 (58 bytes allocated) 121 0.297599
4 ETW000 [dev trc ,00000] STATEMENT_CACHE_SIZE = 1000 1523 0.299122
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=152000) : 0000000003AACFB0 (152074 bytes allocated)
4 ETW000 3167 0.302289
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=2088000) : 00000000089A0040 (2240090 bytes allocated)
4 ETW000 77 0.302366
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=288000) : 0000000003AD2190 (2528106 bytes allocated)
4 ETW000 237 0.302603
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=16144) : 0000000003B186B0 (2544266 bytes allocated)
4 ETW000 87 0.302690
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=32048) : 0000000003B1C5E0 (2576330 bytes allocated)
4 ETW000 97 0.302787
4 ETW000 [dev trc ,00000] -> loadClientRuntime() 13037 0.315824
4 ETW000 [dev trc ,00000] Loading SQLDBC client runtime ... 50 0.315874
4 ETW000 [dev trc ,00000] SQLDBC Module : D:\sapdb\clients\HP3\pgm\libSQLDBC77.dll 563371 0.879245
4 ETW000 [dev trc ,00000] SQLDBC SDK : SQLDBC.H 7.7.4 BUILD 009-123-173-450 27099 0.906344
4 ETW000 [dev trc ,00000] SQLDBC Runtime : libSQLDBC 7.8.2 BUILD 023-121-242-871 79 0.906423
4 ETW000 [dev trc ,00000] SQLDBC client runtime is MaxDB 7.8.2.023 CL 242871 62 0.906485
4 ETW000 [dev trc ,00000] SQLDBC supports new DECIMAL interface : 1 39 0.906524
4 ETW000 [dev trc ,00000] SQLDBC supports VARIABLE INPUT data : 1 23 0.906547
4 ETW000 [dev trc ,00000] SQLDBC supports VARIABLE OUTPUT data : 1 23 0.906570
4 ETW000 [dev trc ,00000] SQLDBC supports Multiple Streams : 1 23 0.906593
4 ETW000 [dev trc ,00000] SQLDBC supports LOB LOCATOR KEEPALIVE : 1 23 0.906616
4 ETW000 [dev trc ,00000] SQLDBC supports LOB LOCATOR COPY : 1 23 0.906639
4 ETW000 [dev trc ,00000] SQLDBC supports BULK SELECT with LOBS : 1 115 0.906754
4 ETW000 [dev trc ,00000] -> getNewConnection() 34 0.906788
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=2160) : 0000000003B29520 (2578506 bytes allocated)
4 ETW000 36 0.906824
4 ETW000 [dev trc ,00000] -> sdb_malloc(size=1168) : 0000000003B29DB0 (2579690 bytes allocated)
4 ETW000 33907 0.940731
4 ETW000 [dev trc ,00000] <- getNewConnection(con_hdl=0) 15491 0.956222
4 ETW000 [dev trc ,00000] -> checkEnvironment(con_hdl=0) 56 0.956278
4 ETW000 [dev trc ,00000] -> connect() 46 0.956324
4 ETW000 [dev trc ,00000] INFO : SQLOPT= -I 0 -t 0 -S SAPR3 97 0.956421
4 ETW000 [dev trc ,00000] Try to connect (DEFAULT) on connection 0 ... 191 0.956612
4 ETW000 [dbsdbsql ,00000] *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))
4 ETW000 52965 1.009577
4 ETW000 [dev trc ,00000] -> SetSapdbCA(errcode=-10709) 38 1.009615
4 ETW000 [dev trc ,00000] -> freeConnection(con_hdl=0) 32 1.009647
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003B29DB0, size=1168 (2578506 bytes allocated))
4 ETW000 9602 1.019249
4 ETW000 [dev trc ,00000] close all opened locators of connection 0 3021 1.022270
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003B29520, size=2160 (2576330 bytes allocated))
4 ETW000 37 1.022307
4 ETW000 [dev trc ,00000] } DbSlSdbConnect(rc=99) 23 1.022330
4 ETW000 [dblink ,00000] ***LOG BY2=>sql error -10709 performing CON 20636 1.042966
4 ETW000 [dblink ,00000] ***LOG BY0=>Connection failed (RTE:[5] database not running) 31 1.042997
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=41,arg_p=00000001405F8278) 6580 1.049577
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 66 1.049643
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=14,arg_p=0000000002025E88) 27 1.049670
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 22 1.049692
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=50,arg_p=0000000002025E80) 95 1.049787
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 58 1.049845
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=13,arg_p=0000000002025EE0) 26 1.049871
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 21 1.049892
4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=52,arg_p=0000000002025EA0) 25 1.049917
4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 21 1.049938
2EETW169 no connect possible: "DBMS = ADABAS D --- DBNAME = ''"
4 ETW000 [dev trc ,00000] release memory of the SIBU buffers 4300 1.054238
4 ETW000 [dev trc ,00000] release memory of the STATEMENT CACHE 109 1.054347
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003B1C5E0, size=32048 (2544266 bytes allocated))
4 ETW000 62 1.054409
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003B186B0, size=16144 (2528106 bytes allocated))
4 ETW000 36 1.054445
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003AD2190, size=288000 (2240090 bytes allocated))
4 ETW000 34 1.054479
4 ETW000 [dev trc ,00000] -> sdb_free(p=00000000089A0040, size=2088000 (152074 bytes allocated))
4 ETW000 34 1.054513
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003AACFB0, size=152000 (58 bytes allocated)) 2662 1.057175
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003C2C470, size=10 (32 bytes allocated)) 49 1.057224
4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000003C2C4A0, size=16 (0 bytes allocated)) 26 1.057250
Thanks & Regards
Václav
Hi Vaclav
I dont have much experience with MaxDB but after reading your question I first thought of checking the MaxDB logs which might point to a possible root cause of DB not starting. E.g. knldiag.
Please check this link for a list of MaxDB log files: http://wiki.sdn.sap.com/wiki/display/MaxDB/MaxDB+log+files
DB log files will give some error message and based on that you have to trouble shoot the issue.
For e.g. --> http://scn.sap.com/thread/1713461
-Roshan
Hi Roshan,
Thank you for the link, the list of all available logfiles is very useful. But the maxdb logfiles are not up to date. Here is what I did:
Do you have an idea what I can check as next? It seems to me to be some kind of maxdb problem.
Regards & Thanks a lot
Václav
Hi Vaclav,
Please check the
http://scn.sap.com/thread/1982920
please update you maxdb version if possible.
Best Regards,
Atul
Hi Atul,
I will open a discussion in the MaxDB group, too. Maybe someone could help me there. If not, I'll try to Update the database to 7.9.
I will inform you guys on the further progress of my problem. I think the soluition may be interesting for anyone with similar problems.
Thanks & Regards
Václav
Hi,
It seems that there is some memory bottle neck.
Try to restart the server to free up the memory and try starting and check whether it come up or not.
Did you perform any kernel upgrade or any other activity like server patching...etc
Thanks and Regards,
Vimal
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 please check you db ,isit up or not.
you can check R3trans -d for connectivity between R3 and DB.
Please provide more log for info.
Best Regards,
Atul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.