on 07-08-2010 6:51 AM
Hello
after installing AbapTrial7.01 on 32bít Vista and, separately, installing MaxDb, both "Successfully" according to installation messages, I find I cannot start the Dispatcher (starting NSP in sapmmc). Always it stops after 1:15 minutes.
I have found the errror message:
calling db_connect ...
B create_con (con_name=R/3)
B Loading DB library 'C:SAPNSPSYSexe
undbsdbslib.dll' ...
M *** ERROR => DlLoadLib: LoadLibrary(C:SAPNSPSYSexe
M Error 126 = "Das angegebene Modul wurde nicht gefunden."
B *** ERROR => Couldn't load library 'C:SAPNSPSYSexe
undbsdbslib.dll'
in the file dev_w0 under C:SAPNSPDVEBMGS00work.
However, C:SAPNSPSYSexe
un does indeed contain dbsdbslib.dll.
C:usr is empty.
Looking at Jonathan Mejia's post in I wonder if the problem might be in the download from http://www.sdn.sap.com/irj/scn/nw-downloads.
He speaks of MAXDB files in the installation directory and my installation directory does not have them.
He has
<installer_directory>SAPNWABAP701SR1_TRIALMaxDB_77_SP6_Build07_RDBMSDATA_UNITSMAXDB_WINDOWS_I386
and I have no MaxDB files in my downloaded
SAPNW7.01ABAPTrial
.
The download was difficult: dozens of times it broke off with scnsorry and only after writing to sdn@sap.com was I able to download. Now, again, I cannot download even after writing to sdn.
Are the download files complete?
(New post replacing since neiterh edit nor reply to old post are permitted).
Message Server connection:
If I say in dbmcli "db_state" I get ONLINE, and if I then say "stop" I see OK and then if I start NSP in sapmmc the Dispatcher goes to state
Running, Message Server connection OK
with green icon until 1:10 minutes and then stops at 1:15.
Edit: when I run
c:sap
spsysexe
un
3trans -d
I get a popup saying that I need
libSQLDBC76.dll
but this is nowhere in the files I downloaded from sdn (SAPNW7.01ABAPTrial from http://www.sdn.sap.com/irj/scn/nw-downloads).
Where do I get this file?
Edit
it seems that Jonathan Mejias installation and my simple AbapTrial download are different animals.
I was able to find the file he mentioned in another download.
I put it into C:SAPNSPSYSexe
un.
I ran r3trans -d again and in the trans log I see
4 ETW000 create_con (con_name=R/3) 0 0.000000
4 ETW000 Loading DB library 'dbsdbslib.dll' ... 0 0.000000
4 ETW000 load shared library (dbsdbslib.dll), hdl 0, addr 10DB0000
4 ETW000 8795 0.008795
4 ETW000 using "C:SAPNSPSYSexe
undbsdbslib.dll"
4 ETW000 60 0.008855
4 ETW000 Library 'dbsdbslib.dll' loaded 33 0.008888
4 ETW000 function DbSlExpFuns loaded from library dbsdbslib.dll
4
and so the file was found and loaded this time.
Even dev_wo seems happy;
B create_con (con_name=R/3)
B Loading DB library 'C:SAPNSPSYSexe
undbsdbslib.dll' ...
B Library 'C:SAPNSPSYSexe
undbsdbslib.dll' loaded
B Version of 'C:SAPNSPSYSexe
undbsdbslib.dll' is "700.08", patchlevel (0.7)
B New connection 0 created
M sysno 00
M sid NSP
However the Dispatcher stops as before.
Can anyone help?
I continue via a reply to myself because edit is getting too difficult (unwanted scrolling).
I seek errors.
dev_disp says:
WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5529]
and, further down,
my types changed after wp death/restart 0x90 --> 0x80
DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
dev_w0 says
C *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)
[dbsdbsql.cpp 137]
B ***LOG BY2=> sql error -4008 performing CON [dbsh#1 @ 1204] [dbsh 1204 ]
B ***LOG BY0=> POS(1) Unknown user name/password combination [dbsh#1 @ 1204] [dbsh 1204 ]
B ***LOG BY2=> sql error -4008 performing CON [dblink#1 @ 431] [dblink 0431 ]
B ***LOG BY0=> POS(1) Unknown user name/password combination [dblink#1 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1440]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10557]
c:\sapdb\programs\bin\xuser list says
-
XUSER Entry 1
-
Key :DEFAULT
Username :SAPNSP
UsernameUCS2:S.A.P.N.S.P. . . .
Password :?????????
PasswordUCS2:?????????
Dbname :NSP
Nodename :lawn-medion
Sqlmode :SAPR3
Cachelimit :-1
Timeout
Isolation :-1
Charset :<unspecified>
-
XUSER Entry 2
-
Key :w
Username :SUPERDBA
UsernameUCS2:S.U.P.E.R.D.B.A. .
Password :?????????
PasswordUCS2:?????????
Dbname :NSP
Nodename :lawn-medion
Sqlmode :<unspecified>
Cachelimit :-1
Timeout :-1
Isolation :-1
Charset :<unspecified>
-
XUSER Entry 3
-
Key :c
Username :CONTROL
UsernameUCS2:C.O.N.T.R.O.L. . .
Password :?????????
PasswordUCS2:?????????
Dbname :NSP
Nodename :lawn-medion
Sqlmode :<unspecified>
Cachelimit :-1
Timeout :-1
Isolation :-1
Charset :<unspecified>
The passwords are all the same for all users including control.
(again unwanted scrolling - must use reply instead of edit)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
trans says
4 ETW000 [dev trc ,00000] -> connect() 42 0.019032
4 ETW000 [dev trc ,00000] INFO : SQLOPT= -I 0 -t 0 -S SAPR3 80 0.019112
4 ETW000 [dev trc ,00000] Try to connect (DEFAULT) on connection 0 ... 128 0.019240
4 ETW000 [dev trc ,00000] Thu Jul 08 16:00:57 2010 1293753 1.312993
4 ETW000 [dbsdbsql ,00000] *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)
4 ETW000 96 1.313089
4 ETW000 [dev trc ,00000] -> SetSapdbCA(errcode=-4008) 36 1.313125
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.