on 08-28-2009 3:02 PM
Hi
i am trying to applying the patcc in solution mnaager system.
it is throwing error like tp unable to connect the db.
then i have checked the tp check-->transport tool from stms transaction.
ther it is passing all the tests but from tp call these two are failed
*1.DB Connect Link to database failed *
*2.Offline Call Connect Failed *
if i clicked either one of error symbol i am getting the below log information.
i have checked dbms_type=mss and DIR_LIBRARY path to .../sys/exe/run/uc/../nti386
still i am getting error: my db is mssql kernel patch level at 185 SP level 16.
tp connect SID pf=D:///usr///tp_domain.sid.pfl is CONNECTED.
The log:
This is tp version 372.04.65 (release 700, unicode enabled)
Warning: Parameter DBLIBPATH is no longer used.
ERROR: Connect to SM1 failed (20090827185006, probably wrong environment).
TRACE-INFO: 1: [dev trc ,00000] Thu Aug 27 18:50:06 2009
TRACE-INFO: 2: [dev trc ,00000] load shared library (D:\usr\sap\SM1\SYS\exe\uc\NTI3
TRACE-INFO: 3: [dev trc ,00000] using "D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmsssl
TRACE-INFO: 4: [dev trc ,00000] Thread ID:2952
TRACE-INFO: 5: [dev trc ,00000] Thank You for using the SLOLEDB-interface
TRACE-INFO: 6: [dev trc ,00000] Using dynamic link library 'D:\usr\sap\SM1\SYS\exe\
TRACE-INFO: 7: [dev trc ,00000] dbmssslib.dll patch info
TRACE-INFO: 8: [dev trc ,00000] patchlevel 0
TRACE-INFO: 9: [dev trc ,00000] patchno 182
TRACE-INFO: 10: [dev trc ,00000] patchcomment MSSQL: COPYTOSHADOW, R3
TRACE-INFO: 11: [dev trc ,00000] np:(local) connection used on SAPSOLMA
TRACE-INFO: 12: [dev trc ,00000] CopyLocalParameters: dbuser is 'dbo'
TRACE-INFO: 13: [dev trc ,00000] Using Provider SQLNCLI
TRACE-INFO: 14: [dev trc ,00000] OpenOledbConnection: MARS property was
TRACE-INFO: 15: [dev trc ,00000] Provider Release:9.00.4035.00
TRACE-INFO: 16: [dev trc ,00000] Using Provider SQLNCLI
TRACE-INFO: 17: [dev trc ,00000] OpenOledbConnection: MARS property was
TRACE-INFO: 18: [dev trc ,00000] i'm dbo but there exists 1 users <> db
TRACE-INFO: 19:
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0232
standard output from tp and from tools called by tp:
kindly suggest ....even i copied sapmssslib.dll and pdb new verion also.
Regards
Balaji
Hi,
I believe you have to update Tp to latest Patch.
Also could you whether Tp process exist in the task manager
Regards
Sid
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
BRO... you saved my day too...!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
not answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Balaji,
Check that the environment variables of <sid>adm are also found from Registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\SAP\<SID>\Environment
I had a similar tp problem, and found those missing (as a result of registry corruption during HW maintenance). Adding them solved the issue in my case.
cheers,
Kevin
Hi,
Problem could e simple.R3trans -d workd perfectly since you run it from sidadm where env is set perfetly.But here your service SAPSID_<> runs with SAPServiceSID user for which the environment is not set
Either set the environment for SAPServiceSID user or change the service user to sidadm which will solve the issue for sure
Thanks & Regards,
Ravindran D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Please see below link
http://www.sap-img.com/basis/sap-message-tp-cannot-connect-system.htm
or try below steps
Configure the TMS in this R/3 System again.
You need to:
1. logon to the transport domain controller with admin user in client 000.
2. Run STMS
3. System overview
4. select QAS
5. Menu line option "SAP system" --> "Approve"
6. Distribute configuration
When you are logged on the transport domain server and run STMS --> System Overview. Is QAS listed? If so, select it and perform the checks under "SAP Systems" in menu line.
If they are not successful you might want to try the following to configure the TMS on QAS from scratch.
First delete QAS from system overview on the domain server.
Then do the following steps...
In your QAS system in client 000.
Run tcode SE06 --> Database copy or Database migration --> Perform post-installation actions.
Then confirm that you want to delete all old CTS/TMS config and type in QAS as source system for the database copy.
Then run STMS again and type in the correct data for the transport domain controller.
Logon to the transport domain controller in client 000. Run STMS. Open system overview.
Choose the SID of the QAS system and click on "SAP System" in the menu and choose Approve.
This will add the QAS system to your TMS config again.
Perform the checks from menu line "SAP Systems" again.
It seems like a lot maybe, but it only takes a couple of minutes to perform.
cheers,
Sudhakar
Hi Balaji,
did you updated the library and DDL file.
Can you share the envoriment which is present for user SIDADM.
Thanks
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I have updated only kernel ,with sapexe.sar and sapexedb.sar.
Environment for SIDADM is
C:\Documents and Settings\sm1adm>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\sm1adm\Application Data
CLIENTNAME=INHYDJHBPO-535
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SAPSOLMAN
ComSpec=C:\WINDOWS\system32\cmd.exe
DBMS_TYPE=mss
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\sm1adm
lib=C:\Program Files\SQLXML 4.0\bin\
LOGONSERVER=
SERVER-38
MSSQL_DBNAME=SM1
MSSQL_SCHEMA=sm1
MSSQL_SERVER=SAPSOLMAN
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Mi
crosoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools
\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Micro
soft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;D:\usr\sap\SM1\SYS\exe\uc\NTI
386
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 4 Stepping 3, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0403
ProgramFiles=C:\Program Files
PROMPT=$P$G
SAPEXE=D:\usr\sap\SM1\SYS\exe\uc\NTI386
SAPLOCALHOST=SAPSOLMAN
SAPSYSTEMNAME=SM1
SESSIONNAME=RDP-Tcp#1
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\WINDOWS\TEMP\1
TMP=C:\WINDOWS\TEMP\1
USERDNSDOMAIN=APOLLO.LOCAL
USERDOMAIN=APOLLO
USERNAME=sm1adm
USERPROFILE=C:\Documents and Settings\sm1adm
windir=C:\WINDOWS
C:\Documents and Settings\sm1adm>
Regards
Balaji
Check your kernel version and is it 32bit or 64bit exact compatibility to your system. Stop and start the system.
All the Best!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Balaji,
You have three sets of errors:
ERROR: No connect due to DbSl Load Lib Failure
ERROR: environment variable dbms_type is not set.
ERROR: Connect to SM1 failed (20090908184602).
ERROR: No connect due to DbSl Load Lib Failure
Client of SQL might not be correct path, check out
ERROR: environment variable dbms_type is not set.
In the environment variable of SIDADM user variable enter DBMS_TYPE = MSS
Restart the application server.
This should resolve upto certain extent.
Keep us posted.
Hi Mike
Regarding:
ERROR: No connect due to DbSl Load Lib Failure
Client of SQL might not be correct path, check out
I am not sure where to check this path, And dev_wX trace logs are showing that DbSl Load Lib successfully loaded.)
and tp connect and r3trans -d return code is 000.
kindly let me know where to check this path exactly
Regarding:
ERROR: environment variable dbms_type is not set.
In the environment variable of SIDADM user variable enter DBMS_TYPE = MSS
This has been already set for SIDADM and for testing purpose i put it for system variable also.
Regards
Balaji
Hi,
Please reconfigure the STMS in solution manager system.
Thanks & Regards,
Vidyadhar K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
While applying the patch this is the log:
Import phase 'CHECK_REQUIREMENTS' (08.09.2009, 18:46:02)
Error during executing the tp command 'tp CONNECT SM1 ...'
tp return code: '0249' , tp message: 'connect failed due to DbSL load lib failure' , tp output:
This is tp version 372.04.70 (release 700, unicode enabled)
ERROR: No connect due to DbSl Load Lib Failure
ERROR: environment variable dbms_type is not set.
ERROR: Connect to SM1 failed (20090908184602).
INFO: no trace information stored
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0249
standard output from tp and from tools called by tp:
.
but at os level for sidadm user the environment variable is set DBMS_TYPE=mss.
when i execute the same ('tp CONNECT SM1 ...) comand at os level it is working fine.
Any idea?
Regards
Balaji nampally
can you try to check with r3trans -d and see the log.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
R3trans -d return code is 0000
and translog
4 ETW000 r3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).
4 ETW000 unicode enabled version
4 ETW000 date&time : 31.08.2009 - 17:46:10
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] Mon Aug 31 17:46:13 2009 19793 0.019793
4 ETW000 [dev trc ,00000] db_con_init called 53 0.019846
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 59 0.019905
4 ETW000 [dev trc ,00000] Loading DB library 'D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll' ...
4 ETW000 73 0.019978
4 ETW000 [dev trc ,00000] load shared library (D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll), hdl 0
4 ETW000 17950 0.037928
4 ETW000 [dev trc ,00000] using "D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll" 34 0.037962
4 ETW000 [dev trc ,00000] Library 'D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll' loaded 37 0.037999
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll
4 ETW000 55 0.038054
4 ETW000 [dev trc ,00000] Version of 'D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll' is "700.08", patchlevel (0.216)
4 ETW000 5930 0.043984
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll
4 ETW000 62 0.044046
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll
4 ETW000 57 0.044103
4 ETW000 [dev trc ,00000] New connection 0 created 48 0.044151
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 67 0.044218
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 38 0.044256
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 30 0.044286
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 66 0.044352
4 ETW000 [dev trc ,00000] Thread ID:2964 2202 0.046554
4 ETW000 [dev trc ,00000] Thank You for using the SLOLEDB-interface 39 0.046593
4 ETW000 [dev trc ,00000] Using dynamic link library 'D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll'
4 ETW000 63 0.046656
4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 64 0.046720
4 ETW000 [dev trc ,00000] patchlevel 0 33 0.046753
4 ETW000 [dev trc ,00000] patchno 216 32 0.046785
4 ETW000 [dev trc ,00000] patchcomment Wrong table name in ST05 trace (1364307) 104 0.046889
4 ETW000 [dev trc ,00000] np:(local) connection used on SAPSOLMAN 133 0.047022
4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'sm1' 38 0.047060
4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 10186 0.057246
4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 225 0.057471
4 ETW000 [dev trc ,00000] Provider Release:9.00.4035.00 161464 0.218935
4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 33466 0.252401
4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 214 0.252615
4 ETW000 [dev trc ,00000] Cache sizes: header 68 bytes, 100 names (158400 bytes), 100 dynamic statements (569600 bytes), total 728068 bytes
4 ETW000 32083 0.284698
4 ETW000 [dev trc ,00000] Initializing private procedure name cache. 37 0.284735
4 ETW000 [dev trc ,00000] procedure cache created/attached 41 0.284776
4 ETW000 [dev trc ,00000] Connected to db server : [SAPSOLMAN] server_used : [np:(local)], dbname: SM1, dbuser: sm1
4 ETW000 59 0.284835
4 ETW000 [dev trc ,00000] pn_id:SAPSOLMAN_SM1SM1_SM1 32 0.284867
4 ETW000 [dev trc ,00000] Using MARS (on sql 9.0) 164 0.285031
4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 47 0.285078
4 ETW000 [dev trc ,00000] The IRow interface is supported by this OLEDB provider 59574 0.344652
4 ETW000 [dev trc ,00000] NTAB: Structure of NTAB on DB is VERS_B 156958 0.501610
4 ETW000 [dev trc ,00000] NTAB: UNICODELG(SVERS) = 2, SAP_UC_LN = 2 60 0.501670
4 ETW000 [dev trc ,00000] NTAB: standalone processing 4653 0.506323
4 ETW000 [dev trc ,00000] NTAB: read profile 35 0.506358
4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y4SAPSOLMAsm100000028760000000003174613 127 0.509411
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:717}
4 ETW000 63 0.566698
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 ) 45151 0.611849
4 ETW000 Connected to DBMS = MSSQL --- SERVER = 'SAPSOLMAN' DBNAME = 'SM1' --- SYSTEM = 'SM1'.
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1320}
4 ETW000 130504 0.742353
4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y4SAPSOLMAsm100000028760000000003174613 29755 0.772108
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 77996 0.850104
4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)
4 ETW000 3679 0.853783
4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SAPSOLMAsm100000028760000000007174613 128 0.853911
4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=1,#output=8) 31188 0.885099
4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=1) 156 0.885255
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1424}
4 ETW000 110 0.885365
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 430 0.885795
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1432}
4 ETW000 84 0.885879
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 3540 0.889419
4 ETW690 COMMIT "0" "0"
4 ETW000 [dev trc ,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0) 124 0.889543
4 ETW000 trace to file pointer closed
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000
4 ETW000 ================== STEP 1 =====================
4 ETW000 date&time : 31.08.2009 - 17:46:14
4 ETW000 function : CONNECT
4 ETW000 buffersync : YES
4 ETW000 clients : default
4 ETW000 l.s.m. : VECTOR
4 ETW000 commit : 100000
4 ETW000 table cache : dynamic
4 ETW000
[dev trc ,00000] Mon Aug 31 17:46:14 2009 9045 0.009045
[dev trc ,00000] Disconnecting from ALL connections: 28 0.009073
[dev trc ,00000] Disconnected from connection 0 2056 0.011129
[dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1) 72 0.011201
[dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 36 0.011237
Disconnected from database.
End of Transport (0000).
date&time: 31.08.2009 - 17:46:14
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.