on 09-15-2008 6:10 PM
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
Hi Balaji,
From when are you getting this error? After upgrading your kernel?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I donwloaded the same kernel verison again and copied to the SYS path and restarted the machine
It solved the issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I donwloaded the same kernel verison again and copied to the SYS path and restarted the machine
It solved the issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
kernel was upgraded long back.
I am just trying to update the support packs and getting the error
Pls help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.