cancel
Showing results for 
Search instead for 
Did you mean: 

SPAM ERROR / TP cannot_connect_system_check_requirement

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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"

HuseyinBilgen
Active Contributor
0 Kudos

can you please send me the environment values screenshot as I sent you?

Former Member
0 Kudos
HuseyinBilgen
Active Contributor
0 Kudos

Can you plz attach the trans.log again which you run with sidadm?

Former Member
0 Kudos

what about temp and tmp and path , what should i do about them ??!

HuseyinBilgen
Active Contributor
0 Kudos

You can point any existing directory for them.

Former Member
0 Kudos

Any Help Guys ???!!!!!!!!!!

Former Member
0 Kudos

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 ??

HuseyinBilgen
Active Contributor
0 Kudos

All in user variable

Former Member
0 Kudos

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.

HuseyinBilgen
Active Contributor
0 Kudos

sure

but with sidadm

ashish_vikas
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hello Ashish ,

Thank you for quick replay :

My system is :

SAP ECC 6.0 EHP 4 , Windows Server 2008 R2 , SQL Server 2008 R2.

Thanks In Advance.

HuseyinBilgen
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.

premsukh_bishnoi
Contributor
0 Kudos

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

Former Member
0 Kudos

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.

HuseyinBilgen
Active Contributor
0 Kudos

Hi RAmi,

You've to run R3trans with <sid>adm not Administrator. Can you please verify that the trans.log you shared generated when you run R3trans command with <sid>adm

We need the Environment variables of <sid>adm to verify the settings

Former Member
0 Kudos

The R3TRANS runed from <SID>ADM , but about DBMS_TYPE , I`ve put it in administrator user .

Can you tell me what is the required environment variables that I must put it ?

And how to put it please .

Regards.

premsukh_bishnoi
Contributor
0 Kudos

Hi,

Please login to windows as Sidadm and then open environment level and set it.

Regards, Premsukh

HuseyinBilgen
Active Contributor
0 Kudos

Hi RAmi,

Just please send me the Environment of sidadm and I'll let you know which ones are lacks

HuseyinBilgen
Active Contributor
0 Kudos

sidadm and SAPServiceSID must have the following env variables and values.