on 11-18-2012 12:55 PM
Dears ,
I need your help if its possible .
I need to update SPAM , but after starting the update process , the error occurred " TP cannot_connect_system_check_ requirement ".
I`ve read note "96907" but it not helped me!
-----------------
Also I`ve run the command :
D:\usr\sap\VL1\SYS\exe\uc\NTAMD64> tp connect vl1
This is tp version 376.03.38 (release 701, unicode enabled)
E-TPSETTINGS could not be opened.
EXIT
Error in TPSETTINGS: transdir not set.
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0208
tp finished with return code: 208
meaning:
error in transportprofil (param missing, unknown,...)
--------------------------
Also I`ve run the command :
D:\usr\sap\VL1\SYS\exe\uc\NTAMD64> r3trans -d
This is r3trans version 6.14 (release 701 - 03.06.11 - 17:57:00).
unicode enabled version
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
r3trans finished (0012).
------------------------------------
How can you help me guys !!
Thanks In Advance .
Regards.
Dear Huseyin ,
This is the " r3tans -d " in cmd after set the environment variables :
-------
D:\usr\sap\VL1\SYS\exe\uc\NTAMD64>r3trans -d
This is r3trans version 6.14 (release 701 - 03.06.11 - 17:57:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = MSSQL --- SERV
ER = 'SAPIDES' DBNAME = 'VL1'"
r3trans finished (0012).
-----------
Also please see the below list about the environment variables that I`ve set
[HKEY_CURRENT_USER\Environment]
"DBMS_TYPE"="MSS"
"MSSQL_DBNAME"="VL1"
"MSSQL_SCHEMA"="VL1"
"MSSQL_SERVER"="SAPIDES"
"PATH"="D:\\usr\\sap\\VL1\\SYS\\exe\\uc\\NTAMD64"
"SAPEXE"="D:\\usr\\sap\\VL1\\SYS\\exe\\uc\\NTAMD64"
"SAPLOCALHOST"="SAPIDES"
"SAPSYSTEMNAME"="VL1"
"TEMP"="D:\\usr\\sap\\VL1\\tmp"
"TMP"="D:\\usr\\sap\\VL1\\tmp"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what about temp and tmp and path , what should i do about them ??!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any Help Guys ???!!!!!!!!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Huseyin and sorry to bothering you ,
BUT where should I put them ?
In user variable section or in system variuable section and about :
SAPEXE , SAPLOCALHOST , SAPSYSTEMNAME : should I create them in user vairable or system variable section ?
also about PATH AND TEMP AND TMP : should I edit them ??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry Guys ,
But do you mean that you want a screen shot from environment variable :
that's in : Start --> computer --> properties --> advanced computer setting --> environment variables ????
Thanks In Advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please paste R3trans -d log file.
What is your SAP, OS and DB version ?
Also check Note 556232 - Environment settings for R/3/Oracle on Windows
Best Regards
ashish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rami,
You've 2 problems. One is to call TP directly and other is DB Connection.
Lets try to solve the DB connection problem first.
Did you call R3trans -d with the user <sid>adm?
If yes, please share the trans.log file generated in the directory where you called R3trans command.
If no, please try with <sid>adm user again.
Hello Hussien ,
I`ve read some notes and blugs , what I`ve understand that I need to put ( DBMS_TYPE : MSS ) in the environment variable of the server .
after that I`ve run " R3trans -d " from <SID>ADM and this is the trans.log :
-------------
4 ETW000 r3trans version 6.14 (release 701 - 03.06.11 - 17:57:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 19.11.2012 - 10:04:35
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 Nov 19 10:04:39 2012 0 0.000000
4 ETW000 [ dev trc,00000] db_con_init called 0 0.000000
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 0 0.000000
4 ETW000 [ dev trc,00000] Loading DB library 'dbmssslib.dll' ... 0 0.000000
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000187190000
4 ETW000 2720 0.002720
4 ETW000 [ dev trc,00000] using "D:\usr\sap\VL1\SYS\exe\uc\NTAMD64\dbmssslib.dll" 15 0.002735
4 ETW000 [ dev trc,00000] Library 'dbmssslib.dll' loaded 18 0.002753
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbmssslib.dll 16 0.002769
4 ETW000 [ dev trc,00000] Version of 'dbmssslib.dll' is "700.08", patchlevel (0.150) 703 0.003472
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbmssslib.dll 21 0.003493
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbmssslib.dll 15 0.003508
4 ETW000 [ dev trc,00000] New connection 0 created 31 0.003539
4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 44 0.003583
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 24 0.003607
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse: 13 0.003620
4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 35 0.003655
4 ETW000 [ dev trc,00000] Thread ID:2692 944 0.004599
4 ETW000 [ dev trc,00000] Thank You for using the SLODBC-interface 18 0.004617
4 ETW000 [ dev trc,00000] Using dynamic link library 'D:\usr\sap\VL1\SYS\exe\uc\NTAMD64\dbmssslib.dll'
4 ETW000 26 0.004643
4 ETW000 [ dev trc,00000] dbmssslib.dll patch info 28 0.004671
4 ETW000 [ dev trc,00000] SAP patchlevel 0 15 0.004686
4 ETW000 [ dev trc,00000] SAP patchno 150 13 0.004699
4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchlevel 0 33 0.004732
4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchno 150 16 0.004748
4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchcomment R3load import: Invalid field size for datatype (1603882)
4 ETW000 21 0.004769
4 ETW000 [ dev trc,00000] Network connection used from SAPIDES to (local) using tcp:(local) 492 0.005261
4 ETW000 [ dev trc,00000] Network connection used from SAPIDES to (local) using tcp:(local) 18551 0.023812
4 ETW000 [ dev trc,00000] Network connection used from SAPIDES to (local) using tcp:(local) 4165 0.027977
4 ETW000 [ dev trc,00000] Driver: sqlncli10.dll Driver release: 10.50.2500 4231 0.032208
4 ETW000 [ dev trc,00000] GetDbRelease: 10.50.2500 382 0.032590
4 ETW000 [ dev trc,00000] GetDbRelease: Got DB release numbers (10,50,2500) 21 0.032611
4 ETW000 [ dev trc,00000] i'm dbo but there exists 1 users <> dbo with tables SVERS ==> connect terminated
4 ETW000 9725 0.042336
2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'SAPIDES' DBNAME = ''"
---------------------
Best Regards.
Hi Rami,
could you please check which schema is the right one dbo or <sid>? I
suppose the schema <sid> is the right one.
If the schema <sid> is the right one please do the following:
- could you please check, if the environment variable (Windows)
MSSQL_SCHEMA is set for the operating system users <sid>adm and the
SAPService<sid>?
If the environment variable isn't set for one or both users, please
set this and restart the R/3 to activate the variable.
The TP will use the environment of the SAPService<sid>. If the
environment variable MSSQL_SCHEMA is not set for this user, as the TP
wants to connect as dbo instead of <sid>. Thats why the connect gets
terminated.
You can check which schemas exist with sp_check_sap_login (see note
#610640 for more detail information).
Regards, Premsukh
Dear Premsukh Bishnoi ,
I have already paste the trans.log for R3TRANS -D before your comment .
Also Please fined the attached below pictures of services and the environment variables .
Regards.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
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.