After system kopi TP call fails in DB connnect

[Former Member]

Hi

After system kopi and all the post config. Including reconfig of TMS i still get an error when I do a check of the transport tool.

STMS -> IMPORT OVERVIEW -> IMPORT QUEUE -> CHECK -> TRANSPORT TOOL.

Link to DB fails.

ERROR: Connect to SID failed (20080915155432, probably wrong environment).

Hope anyone has a brilliant answer.

Best regards

Mads Hammer

TP command works fine when I do it manually.

C:\>tp connect EH3 pf=e:\usr\sap\trans\bin\tp_domain_eh3.pfl

This is tp version 372.04.36 (release 700, unicode enabled)

Connection to Database of EH3 was successful.

This is R3trans.exe version 6.14 (release 700 - 28.07.08 - 15:52:00).

unicode enabled version

R3trans.exe finished (0000).

tp finished with return code: 0

meaning:

Everything OK

C:\>

Edited by: Mads Hammer Su00F8rensen on Sep 17, 2008 11:21 AM

[Former Member]

Hi again

I have been checking every environment parametre twice!!!!

But i still get this error in the SLOG:

ERROR: Connect to EH3 failed (20080915155432, probably wrong environment).

But the check tool generates this log:

1 ETP199X######################################

1 ETP186 R3TRANS CONNECT

1 ETP101 transport order : "ALL"

1 ETP102 system : "EH3"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.36" "700"

1 ETP198

4 ETW000 R3trans.exe version 6.14 (release 700 - 28.07.08 - 15:52:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 17.09.2008 - 11:17:50

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans.exe -w
SESBSAPEH3\sapmnt\trans\tmp\C080917.EH3 -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Sep 17 11:17:50 2008 3062 0.003062

4 ETW000 [dev trc ,00000] db_con_init called 163 0.003225

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 541 0.003766

4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 200 0.003966

4 ETW000 [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 56841 0.060807

4 ETW000 [dev trc ,00000] using "E:\usr\sap\EH3\SYS\exe\uc\NTI386\dbmssslib.dll"

4 ETW000 139 0.060946

4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 61 0.061007

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll

4 ETW000 78 0.061085

4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "700.08", patchlevel (0.158)

4 ETW000 9144 0.070229

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll

4 ETW000 61 0.070290

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll

4 ETW000 77 0.070367

4 ETW000 [dev trc ,00000] New connection 0 created 166 0.070533

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 64 0.070597

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 232 0.070829

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 73 0.070902

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 60 0.070962

4 ETW000 [dev trc ,00000] Thread ID:4256 8194 0.079156

4 ETW000 [dev trc ,00000] Thank You for using the SLOLEDB-interface 48 0.079204

4 ETW000 [dev trc ,00000] Using dynamic link library 'E:\usr\sap\EH3\SYS\exe\uc\NTI386\dbmssslib.dll'

4 ETW000 59 0.079263

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 71 0.079334

4 ETW000 [dev trc ,00000] patchlevel 0 29 0.079363

4 ETW000 [dev trc ,00000] patchno 158 29 0.079392

4 ETW000 [dev trc ,00000] patchcomment Corrections of odbc-based dbsl: dsql: optype, DSN (1135165)

4 ETW000 53 0.079445

4 ETW000 [dev trc ,00000] np:(local) connection used on SESBSAPEH3 157 0.079602

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'eh3' 34 0.079636

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 33138 0.112774

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 740 0.113514

4 ETW000 [dev trc ,00000] Provider Release:9.00.3042.00 171893 0.285407

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 3663 0.289070

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 2229 0.291299

4 ETW000 [dev trc ,00000] Cache sizes: header 68 bytes, 100 names (158400 bytes), 100 dynamic statements (569600 bytes), total 728068 bytes

4 ETW000 19130 0.310429

4 ETW000 [dev trc ,00000] Initializing private procedure name cache. 56 0.310485

4 ETW000 [dev trc ,00000] procedure cache created/attached 804 0.311289

4 ETW000 [dev trc ,00000] Connected to db server : [SESBSAPEH3] server_used : [np:(local)], dbname: EH3, dbuser: eh3

4 ETW000 64 0.311353

4 ETW000 [dev trc ,00000] pn_id:SESBSAPEH3_EH3EH3_EH3 30 0.311383

4 ETW000 [dev trc ,00000] Using MARS (on sql 9.0) 55 0.311438

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 132 0.311570

4 ETW000 [dev trc ,00000] The IRow interface is supported by this OLEDB provider

4 ETW000 31044 0.342614

4 ETW000 [dev trc ,00000] NTAB: Structure of NTAB on DB is VERS_B 18371 0.360985

4 ETW000 [dev trc ,00000] NTAB: UNICODELG(SVERS) = 2, SAP_UC_LN = 2 102 0.361087

4 ETW000 [dev trc ,00000] NTAB: standalone processing 719 0.361806

4 ETW000 [dev trc ,00000] NTAB: read profile 56 0.361862

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 31 0.361893

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 30 0.361923

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 29 0.361952

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 29 0.361981

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 858 0.362839

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 54 0.362893

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 29 0.362922

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 30 0.362952

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 28 0.362980

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 29 0.363009

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 44. 29 0.363038

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 36. 29 0.363067

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 29 0.363096

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 28 0.363124

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 29 0.363153

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 29 0.363182

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 44. 29 0.363211

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 36. 33 0.363244

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 29 0.363273

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 28 0.363301

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 464 0.363765

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 33 0.363798

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 44. 29 0.363827

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 36. 29 0.363856

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 28 0.363884

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 29 0.363913

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 29 0.363942

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 29 0.363971

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 148. 29 0.364000

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 24. 31 0.364031

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 29 0.364060

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 256 29 0.364089

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 29 0.364118

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 256000. 29 0.364147

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 4115480, hh_len 44 11714 0.375861

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 4253450, aa_len 8012 125 0.375986

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 42553a8, ia_len 36000 32 0.376018

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 53e0048, dat_len 512000 31 0.376049

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 411d870, hh_len 44 30 0.376079

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 545d050, aa_len 8012 30 0.376109

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 425e050, ia_len 9000 34 0.376143

4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 4260380, dat_len 102400 30 0.376173

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 545efa8, hh_len 44 30 0.376203

4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 4279388, aa_len 8012 29 0.376232

4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 427b2e0, ia_len 9000 51 0.376283

4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 427d610, dat_len 102400 31 0.376314

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 4114a70, hh_len 148 30 0.376344

4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 4296618, aa_len 8012 30 0.376374

4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 4298570, ia_len 24000 29 0.376403

4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 545efe0, dat_len 256000 31 0.376434

4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 4114a70, ntab_mp_p 4114a70, ntab_proc_id 0

4 ETW000 81 0.376515

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 4115480, ha_list 4253450, hi_list 42553a8, buffer 53e0048

4 ETW000 162 0.376677

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 411d870, ha_list 545d050, hi_list 425e050, buffer 4260380

4 ETW000 56 0.376733

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 545efa8, ha_list 4279388, hi_list 427b2e0, buffer 427d610

4 ETW000 54 0.376787

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 4114ad8, ha_list 4296618, hi_list 4298570, buffer 545efe0

4 ETW000 55 0.376842

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000 244 0.377086

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1

4 ETW000 386 0.377472

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000 455 0.377927

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000 309 0.378236

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y4SESBSAPEeh300000033200000000003111750

4 ETW000 1137 0.379373

4 ETW000 [twdydbacc.c ,00568] i:0 4472 0.383845

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: PGMID 87 0.383932

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 1 49 0.383981

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 0 28 0.384009

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 4 27 0.384036

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:4 28 0.384064

4 ETW000 [twdydbacc.c ,00568] i:1 45 0.384109

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: OBJECT 28 0.384137

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 1 27 0.384164

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 4 30 0.384194

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 4 27 0.384221

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:4 27 0.384248

4 ETW000 [twdydbacc.c ,00568] i:2 29 0.384277

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: OBJ_NAME 28 0.384305

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 1 27 0.384332

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 8 27 0.384359

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 40 27 0.384386

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:40 27 0.384413

4 ETW000 [twdydbacc.c ,00568] i:3 29 0.384442

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: KORRNUM 27 0.384469

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 28 0.384497

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 48 27 0.384524

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 10 27 0.384551

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:10 27 0.384578

4 ETW000 [twdydbacc.c ,00568] i:4 28 0.384606

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: SRCSYSTEM 28 0.384634

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.384661

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 58 27 0.384688

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 10 28 0.384716

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:10 27 0.384743

4 ETW000 [twdydbacc.c ,00568] i:5 43 0.384786

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: AUTHOR 27 0.384813

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 810 0.385623

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 68 32 0.385655

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 12 27 0.385682

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:12 28 0.385710

4 ETW000 [twdydbacc.c ,00568] i:6 29 0.385739

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: SRCDEP 27 0.385766

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 29 0.385795

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 80 28 0.385823

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 1 27 0.385850

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 27 0.385877

4 ETW000 [twdydbacc.c ,00568] i:7 28 0.385905

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: DEVCLASS 28 0.385933

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.385960

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 81 27 0.385987

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 30 27 0.386014

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:30 27 0.386041

4 ETW000 [twdydbacc.c ,00568] i:8 29 0.386070

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: GENFLAG 27 0.386097

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.386124

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 111 27 0.386151

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 1 28 0.386179

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 27 0.386206

4 ETW000 [twdydbacc.c ,00568] i:9 28 0.386234

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: EDTFLAG 27 0.386261

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.386288

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 112 28 0.386316

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 1 27 0.386343

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 42 0.386385

4 ETW000 [twdydbacc.c ,00568] i:10 29 0.386414

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: CPROJECT 28 0.386442

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.386469

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 113 27 0.386496

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 8 27 0.386523

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:8 27 0.386550

4 ETW000 [twdydbacc.c ,00568] i:11 29 0.386579

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: MASTERLANG 30 0.386609

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.386636

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 121 27 0.386663

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 1 27 0.386690

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 27 0.386717

4 ETW000 [twdydbacc.c ,00568] i:12 29 0.386746

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: VERSID 185 0.386931

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 28 0.386959

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 122 28 0.386987

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 20 27 0.387014

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:20 27 0.387041

4 ETW000 [twdydbacc.c ,00568] i:13 29 0.387070

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: PAKNOCHECK 27 0.387097

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 28 0.387125

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 142 27 0.387152

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 1 41 0.387193

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 28 0.387221

4 ETW000 [twdydbacc.c ,00568] i:14 28 0.387249

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: OBJSTABLTY 28 0.387277

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.387304

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 143 27 0.387331

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 1 28 0.387359

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 27 0.387386

4 ETW000 [twdydbacc.c ,00568] i:15 31 0.387417

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: COMPONENT 27 0.387444

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 28 0.387472

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 144 27 0.387499

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 30 27 0.387526

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:30 27 0.387553

4 ETW000 [twdydbacc.c ,00568] i:16 29 0.387582

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: CRELEASE 28 0.387610

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.387637

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 174 27 0.387664

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 10 27 0.387691

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:10 27 0.387718

4 ETW000 [twdydbacc.c ,00568] i:17 29 0.387747

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: DELFLAG 27 0.387774

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.387801

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 184 28 0.387829

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 1 27 0.387856

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 27 0.387883

4 ETW000 [twdydbacc.c ,00568] i:18 29 0.387912

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.fname: TRANSLTTXT 27 0.387939

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.is_key: 0 27 0.387966

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.offset: 185 41 0.388007

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.db_length: 1 28 0.388035

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.fixed_length:1 27 0.388062

4 ETW000 [twdydbacc.c ,00727] buffer:'⛨Ыu0178Б' 3836 0.391898

4 ETW000 [twdydbacc.c ,00732] i:0 65 0.391963

4 ETW000 [twdydbacc.c ,00733] tw_fd_p<i>.offset:0 28 0.391991

4 ETW000 [twdydbacc.c ,00732] i:1 42 0.392033

4 ETW000 [twdydbacc.c ,00733] tw_fd_p<i>.offset:4 27 0.392060

4 ETW000 [twdydbacc.c ,00732] i:2 27 0.392087

4 ETW000 [twdydbacc.c ,00733] tw_fd_p<i>.offset:8 27 0.392114

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:713}

4 ETW000 5553 0.397667

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 )

4 ETW000 9965 0.407632

4 ETW000 Connected to DBMS = MSSQL --- SERVER = 'SESBSAPEH3' DBNAME = 'EH3' --- SYSTEM = 'EH3'.

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1258}

4 ETW000 11392 0.419024

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y4SESBSAPEeh300000033200000000003111750

4 ETW000 1613 0.420637

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 5160 0.425797

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 1338 0.427135

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SESBSAPEeh300000033200000000007111750

4 ETW000 523 0.427658

4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=1,#output=8) 7449 0.435107

4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=1) 998 0.436105

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1370}

4 ETW000 147 0.436252

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 1968 0.438220

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)

4 ETW000 645 0.438865

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 : 17.09.2008 - 11:17:51

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

4 ETW000 [dev trc ,00000] Wed Sep 17 11:17:51 2008 2743 0.002743

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 30 0.002773

4 ETW000 [dev trc ,00000] Disconnected from connection 0 7712 0.010485

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000 75 0.010560

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 52 0.010612

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 17.09.2008 - 11:17:51

1 ETP186 R3TRANS CONNECT

1 ETP110 end date and time : "20080917111751"

1 ETP111 exit code : "0"

1 ETP199 ######################################

Best regards

Mads Hammer

[Former Member]

Hi Markus

I just edited it for internet purpose. It is EH3.

Best regards

Mads Hammer

[markus_doehr2]

Ok.

Keep in mind that you execute the command line as eh3adm whereas the system itself runs under user SAPService<SID>. Did you change the environment of that user (registry)?

Markus

[Former Member]

Hi Markus

I will try logon this system as SAPServiceEH3 and check environment variables.

Best regards

Mads Hammer

[Former Member]

Hi Markus

What do you mean by registry??

I have checked the user environment varibales and they are correct.

Best regards

Mads Hammer

[markus_doehr2]

"Usually" the user SAPService<SID> is not enabled to logon interactively, you can, however, change that of course.

What happens if you do

- start --> execute
- runas /user:SAPService<SID> cmd.exe

and then execute in that opending command window the "tp connect" command - does that work?

Markus

[Former Member]

Hi Markus

Tried as you wrote, runas etc etc....

This is the error:

C:\WINDOWS\system32>tp connect EH3

This is tp version 372.04.36 (release 700, unicode enabled)

E-TPSETTINGS could not be opened.

EXIT

ERROR: System : Parameter SAPEVTPATH not set. Batch jobs cannot be started.

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,...)

C:\WINDOWS\system32>

TP_DOMAIN_EH3.PFL

TRANSDIR =
SESBSAPEH3\sapmnt\trans

#

EH3/DBHOST = SESBSAPEH3

EH3/DBNAME = EH3

EH3/DBTYPE = mss

EH3/NBUFFORM = 1

EH3/TP_VERSION = 266

Best regards

Mads Hammer

[markus_doehr2]

I was referring to the tp command you ran earlier (including the "pf=<profile>" line).

Markus

[Former Member]

Hi Markus

I hope this is what you are asking for

C:\WINDOWS\system32>tp connect EH3 pf=\usr\sap\trans\bin\tp_domain_eh3.pfl

This is tp version 372.04.36 (release 700, unicode enabled)

E-\usr\sap\trans\bin\tp_domain_eh3.pfl could not be opened.

EXIT

ERROR: System : Parameter SAPEVTPATH not set. Batch jobs cannot be started.

Error in \usr\sap\trans\bin\tp_domain_eh3.pfl: 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,...)

C:\WINDOWS\system32>t

[markus_doehr2]

> I hope this is what you are asking for

>

> C:\WINDOWS\system32>tp connect EH3 pf=\usr\sap\trans\bin\tp_domain_eh3.pfl

Try

tp connect EH3 pf=e:\usr\sap\trans\bin\tp_domain_eh3.pfl

Does that work?

Markus

[Former Member]

Hi Markus

This works fine !!!

C:\WINDOWS\system32>tp connect EH3 pf=e:\usr\sap\trans\bin\tp_domain_eh3.pfl

This is tp version 372.04.36 (release 700, unicode enabled)

Connection to Database of EH3 was successful.

This is R3trans.exe version 6.14 (release 700 - 28.07.08 - 15:52:00).

unicode enabled version

R3trans.exe finished (0000).

tp finished with return code: 0

meaning:

Everything OK

C:\WINDOWS\system32>

[markus_doehr2]

Ok.

Try

- logon to client 000

- start transaction SPAM

- execute "Utilities - Check transport tool"

What error message do you get?

Markus

[Former Member]

Hi

Last item on chesk list:

tp Call -> RFC Link works fine

tp Version works fine

DB connect fails

Offline call fails

[markus_doehr2]

It seems that the TMS is not using the correct profile.

Markus

[Former Member]

Hi Markus

Has re-imported the profiles but still same error.

This one is really hunting me !!!!!!!!

Best regards

Mads Hammer

[markus_doehr2]

Can you try again as user SAPService<SID>:

tp connect EH3 pf=\\SESBSAPEH3\sapmnt\trans\bin\tp_domain_eh3.pfl

Does that work?

[Former Member]

Hi Markus

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\WINDOWS\system32>tp connect EH3 pf=
SESBSAPEH3\sapmnt\trans\bin\tp_domain_eh

3.pfl

This is tp version 372.04.36 (release 700, unicode enabled)

Connection to Database of EH3 was successful.

This is R3trans.exe version 6.14 (release 700 - 28.07.08 - 15:52:00).

unicode enabled version

R3trans.exe finished (0000).

tp finished with return code: 0

meaning:

Everything OK

C:\WINDOWS\system32>

[markus_doehr2]

Looks good.

An if you check the TMS the SAME profile is used?

Markus

[Former Member]

Hi Markus

Yes.

Status tp configuration is active

Version 0003

Letzter Änderer EGMDS

Änderung am 16.09.2008 14:25:21

Profil TP_DOMAIN_EH3.PFL

[markus_doehr2]

Yes - but is the UNC path used?

Is

SESBSAPEH3\sapmnt\trans\bin\tp_domain_eh3.pfl

identical with

e:\usr\sap\trans\bin\tp_domain_eh3.pfl

for user SAPService<SID>?

Markus

[Former Member]

Hi Markus

Yes it is. Have just tried both UNC's and they both work fine(0000) for user domain\SAPServiceEH3 and domain\EH3ADM.

Mads Hammer

[markus_doehr2]

I must admit I have no more idea...

[Former Member]

Hi Markus

Thanks a lot for the assistance. I will let you know if i find a solution.

Best regards

Mads Hammer

[markus_doehr2]

> ERROR: Connect to SID failed (20080915155432, probably wrong environment).

Your TMS uses "SID" and you used in the manual command EH3?

Markus