No connect due to DbSl Load Lib Failure

[Former Member]

Hi,

When i test the TP tool , i am getting the following error pls hlep

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

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to BWS failed (20080915125753).

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:

I had done the following to correct the issue, but did not get resolved

1. Downloaded and installed the latest tp and mslib file .

2. Restarted the machine.

3. cheked the environment variables and found to be correct

Pls guide.

The following is output of r3trans file

4 ETW000 r3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 15.09.2008 - 13:15:56

4 ETW000 control file: avc

4 ETW000 R3trans was called as follows: r3trans -d avc

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

4 ETW000 [dev trc ,00000] Mon Sep 15 13:15:58 2008 6673 0.006673

4 ETW000 [dev trc ,00000] db_con_init called 53 0.006726

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

4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 46 0.006842

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

4 ETW000 [dev trc ,00000] using "D:\usr\sap\BWS\SYS\exe\uc\NTAMD64\dbmssslib.dll"

4 ETW000 47 0.175627

4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 15 0.175642

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

4 ETW000 23 0.175665

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

4 ETW000 26329 0.201994

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

4 ETW000 25 0.202019

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

4 ETW000 25 0.202044

4 ETW000 [dev trc ,00000] New connection 0 created 10089 0.212133

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 56 0.212189

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

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

4 ETW000 31 0.212239

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 25 0.212264

4 ETW000 [dev trc ,00000] Thread ID:5960 15999 0.228263

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

4 ETW000 [dev trc ,00000] Using dynamic link library 'D:\usr\sap\BWS\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000 19 0.228295

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 29 0.228324

4 ETW000 [dev trc ,00000] patchlevel 0 10 0.228334

4 ETW000 [dev trc ,00000] patchno 176 9 0.228343

4 ETW000 [dev trc ,00000] patchcomment IA64 alignment errors (1245982) 9 0.228352

4 ETW000 [dev trc ,00000] np:(local) connection used on WDBSSAPBWS01 87 0.228439

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'bws' 11 0.228450

4 ETW000 [dev trc ,00000] Mon Sep 15 13:15:59 2008 203594 0.432044

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 17 0.432061

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

4 ETW000 152 0.432213

4 ETW000 [dev trc ,00000] Provider Release:9.00.3042.00 271901 0.704114

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 27262 0.731376

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

4 ETW000 107 0.731483

4 ETW000 [dev trc ,00000] Cache sizes: header 104 bytes, 100 names (164800 bytes), 100 dynamic statements (575200 bytes), total 740104 bytes

4 ETW000 15694 0.747177

4 ETW000 [dev trc ,00000] Initializing private procedure name cache. 16 0.747193

4 ETW000 [dev trc ,00000] procedure cache created/attached 19 0.747212

4 ETW000 [dev trc ,00000] Connected to db server : [WDBSSAPBWS01] server_used : [np:(local)], dbname: BWS, dbuser: bws

4 ETW000 32 0.747244

4 ETW000 [dev trc ,00000] pn_id:WDBSSAPBWS01_BWSBWS_BWS 9 0.747253

4 ETW000 [dev trc ,00000] Using MARS (on sql 9.0) 9 0.747262

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 15 0.747277

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

4 ETW000 48385 0.795662

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

4 ETW000 34467 0.830129

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

4 ETW000 [dev trc ,00000] NTAB: standalone processing 4760 0.835714

4 ETW000 [dev trc ,00000] NTAB: read profile 16 0.835730

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

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

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

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

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 22 0.835806

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 35 0.835841

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 8 0.835849

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 112 9 0.835858

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 9 0.835867

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 8 0.835875

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 80. 9 0.835884

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 64. 9 0.835893

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 8 0.835901

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 9 0.835910

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 9 0.835919

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 9 0.835928

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 80. 8 0.835936

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 64. 9 0.835945

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 8 0.835953

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 9 0.835962

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 57 0.836019

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 10 0.836029

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 80. 9 0.836038

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 64. 8 0.836046

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 9 0.836055

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 8 0.836063

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 9 0.836072

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 9 0.836081

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 192. 9 0.836090

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 40. 8 0.836098

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 9 0.836107

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 256 9 0.836116

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 8 0.836124

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 256000. 9 0.836133

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 27f4a0, hh_len 80 560 0.836693

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 2e8000, aa_len 16024 11 0.836704

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p a3d9880, ia_len 64000 10 0.836714

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p a3e9880, dat_len 512000 9 0.836723

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 27f500, hh_len 80 10 0.836733

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 2ebeb0, aa_len 16024 9 0.836742

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 2efd60, ia_len 16000 10 0.836752

4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p a467880, dat_len 102400 10 0.836762

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 27f440, hh_len 80 9 0.836771

4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 2f3bf0, aa_len 16024 10 0.836781

4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 2f7aa0, ia_len 16000 9 0.836790

4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p a481880, dat_len 102400 10 0.836800

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 2fb960, hh_len 192 9 0.836809

4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 2fd930, aa_len 16024 10 0.836819

4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p a49b880, ia_len 40000 9 0.836828

4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p a4c0080, dat_len 256000 10 0.836838

4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 2fb960, ntab_mp_p 2fb960, ntab_proc_id 0

4 ETW000 20 0.836858

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 27f4a0, ha_list 2e8000, hi_list a3d9880, buffer a3e9880

4 ETW000 43 0.836901

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 27f500, ha_list 2ebeb0, hi_list 2efd60, buffer a467880

4 ETW000 16 0.836917

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 27f440, ha_list 2f3bf0, hi_list 2f7aa0, buffer a481880

4 ETW000 15 0.836932

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 2fb9d0, ha_list 2fd930, hi_list a49b880, buffer a4c0080

4 ETW000 16 0.836948

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

4 ETW000 23 0.836971

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

4 ETW000 23 0.836994

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

4 ETW000 22 0.837016

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

4 ETW000 21 0.837037

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

4 ETW000 55 0.837092

4 ETW000 [twdydbacc.c ,00571] i:0 690 0.837782

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: PGMID 11 0.837793

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 1 7 0.837800

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 0 8 0.837808

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 4 7 0.837815

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:4 7 0.837822

4 ETW000 [twdydbacc.c ,00571] i:1 9 0.837831

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: OBJECT 8 0.837839

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 1 7 0.837846

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 4 7 0.837853

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 4 8 0.837861

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:4 7 0.837868

4 ETW000 [twdydbacc.c ,00571] i:2 8 0.837876

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: OBJ_NAME 8 0.837884

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 1 7 0.837891

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 8 7 0.837898

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 40 8 0.837906

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:40 7 0.837913

4 ETW000 [twdydbacc.c ,00571] i:3 8 0.837921

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: KORRNUM 7 0.837928

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.837936

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 48 7 0.837943

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 10 8 0.837951

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:10 7 0.837958

4 ETW000 [twdydbacc.c ,00571] i:4 8 0.837966

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: SRCSYSTEM 7 0.837973

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.837981

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 58 7 0.837988

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 10 8 0.837996

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:10 7 0.838003

4 ETW000 [twdydbacc.c ,00571] i:5 8 0.838011

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: AUTHOR 8 0.838019

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 34 0.838053

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 68 8 0.838061

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 12 8 0.838069

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:12 7 0.838076

4 ETW000 [twdydbacc.c ,00571] i:6 8 0.838084

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: SRCDEP 8 0.838092

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 7 0.838099

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 80 16 0.838115

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 1 10 0.838125

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:1 8 0.838133

4 ETW000 [twdydbacc.c ,00571] i:7 8 0.838141

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: DEVCLASS 7 0.838148

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.838156

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 81 7 0.838163

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 30 8 0.838171

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:30 7 0.838178

4 ETW000 [twdydbacc.c ,00571] i:8 8 0.838186

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: GENFLAG 7 0.838193

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.838201

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 111 7 0.838208

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 1 8 0.838216

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:1 7 0.838223

4 ETW000 [twdydbacc.c ,00571] i:9 8 0.838231

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: EDTFLAG 8 0.838239

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 7 0.838246

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 112 8 0.838254

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 1 7 0.838261

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:1 7 0.838268

4 ETW000 [twdydbacc.c ,00571] i:10 8 0.838276

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: CPROJECT 8 0.838284

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 7 0.838291

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 113 8 0.838299

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 8 7 0.838306

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:8 8 0.838314

4 ETW000 [twdydbacc.c ,00571] i:11 8 0.838322

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: MASTERLANG 7 0.838329

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.838337

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 121 7 0.838344

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 1 8 0.838352

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:1 7 0.838359

4 ETW000 [twdydbacc.c ,00571] i:12 8 0.838367

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: VERSID 9 0.838376

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.838384

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 122 7 0.838391

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 20 8 0.838399

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:20 7 0.838406

4 ETW000 [twdydbacc.c ,00571] i:13 8 0.838414

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: PAKNOCHECK 8 0.838422

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 7 0.838429

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 142 8 0.838437

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 1 7 0.838444

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:1 8 0.838452

4 ETW000 [twdydbacc.c ,00571] i:14 7 0.838459

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: OBJSTABLTY 8 0.838467

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.838475

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 143 7 0.838482

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 1 7 0.838489

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:1 8 0.838497

4 ETW000 [twdydbacc.c ,00571] i:15 8 0.838505

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: COMPONENT 7 0.838512

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.838520

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 144 7 0.838527

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 30 8 0.838535

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:30 7 0.838542

4 ETW000 [twdydbacc.c ,00571] i:16 8 0.838550

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: CRELEASE 8 0.838558

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 7 0.838565

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 174 8 0.838573

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 10 7 0.838580

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:10 8 0.838588

4 ETW000 [twdydbacc.c ,00571] i:17 7 0.838595

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: DELFLAG 8 0.838603

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.838611

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 184 7 0.838618

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 1 8 0.838626

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:1 7 0.838633

4 ETW000 [twdydbacc.c ,00571] i:18 8 0.838641

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: TRANSLTTXT 8 0.838649

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 7 0.838656

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 185 8 0.838664

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 1 7 0.838671

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:1 7 0.838678

4 ETW000 [twdydbacc.c ,00730] buffer:' ' 435 0.839113

4 ETW000 [twdydbacc.c ,00735] i:0 10 0.839123

4 ETW000 [twdydbacc.c ,00736] tw_fd_p<i>.offset:0 7 0.839130

4 ETW000 [twdydbacc.c ,00735] i:1 7 0.839137

4 ETW000 [twdydbacc.c ,00736] tw_fd_p<i>.offset:4 8 0.839145

4 ETW000 [twdydbacc.c ,00735] i:2 6 0.839151

4 ETW000 [twdydbacc.c ,00736] tw_fd_p<i>.offset:8 8 0.839159

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

4 ETW000 498 0.839657

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

4 ETW000 7215 0.846872

4 ETW000 Connected to DBMS = MSSQL --- SERVER = 'WDBSSAPBWS01' DBNAME = 'BWS' --- SYSTEM = 'BWS'.

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

4 ETW000 13679 0.860551

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

4 ETW000 261 0.860812

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

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 342 0.862954

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

4 ETW000 6999 0.869953

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

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

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

4 ETW000 39 0.873852

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

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

4 ETW000 18 0.874085

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

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 22737 0.898366

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 : 15.09.2008 - 13:15:59

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] Disconnecting from ALL connections: 2507 0.002507

4 ETW000 [dev trc ,00000] Disconnected from connection 0 1357 0.003864

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

4 ETW000 23 0.003887

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

4 ETW000 20 0.003907

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 15.09.2008 - 13:15:59

[Former Member · Accepted solution]

Hi Balaji,

From when are you getting this error? After upgrading your kernel?

[Former Member]

I donwloaded the same kernel verison again and copied to the SYS path and restarted the machine

It solved the issue

[Former Member]

I donwloaded the same kernel verison again and copied to the SYS path and restarted the machine

It solved the issue

[Former Member]

Hi,

For the below errors,please follow the steps below to clear the issue.

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to DES failed (20070811135509).

So ,please once again Check the environment variable in the system

dbms_type = ora

In registry.

HKEY_LOCAL_MACHINE

>SOFTWARE

>SAP

> SID

> ENVIRONMENT

DBMS_TYPE REG_SZ ORA

DBS_ORA_TNSNAME REG_SZ <SID>

If the above is not set ,please set the variables and check. Hope this resolves your problem.

If not

please review Note

128126 - Database Connect for external tools

Make sure that the environment variable is in lower case for all users.Please also check that you have set 'dbms/type = ora' in the dataprofile

'default.pfl'.

Also it appears that the problem is due to a database issue and not a TMS configuration issue. The connection is failing due to a DBLI_RC_LOAD_LIB_FAILED error. Can I therefore ask you to review the following note:

556232 Environment settings for R/3/Oracle on Windows

19466 Downloading SAP kernel patches

Could you please compare and check the Environment for sap<sid> and Sapservice<sid>?

Hope the problem will be resolved.

Thanks & Regards,

Pradeep Srigiri

[Former Member]

Hi,

kernel was upgraded long back.

I am just trying to update the support packs and getting the error

Pls help

[Former Member]

It definately looks like issue with library file(kernel). In which phase does the import failed?