Solved: EHP 6 upgrade error

Hi all,

I am facing below eroor

hase PREP_SETUP/SQLDB_CLEANINDCRE:

ERROR: No connect due to DbSl Load Lib Failure

ERROR: Possible reasons are:

ERROR: - The value set for dbms_type ('syb') is invalid.

ERROR: - Cannot find the DLL dbsybslib.dll in path

ERROR: - problems when loading DB-dependent DLLs

ERROR: Connect to DEV failed (20130601184805).

Please suggesr any one

SAP Managed Tags:
NW AS Java Administrator (NWA)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

did you update your R3trans and TP ? Does R3trans -x work?

If not upload the trans.log pls

Let me know

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

I have updated only r3 trans

log

C:\Users\devadm>r3trans -d

This is r3trans version 6.22 (release 720 - 09.02.12 - 18:31:00 ).

unicode enabled version

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

r3trans finished (0000).

4 ETW000 r3trans version 6.22 (release 720 - 09.02.12 - 18:31:00 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 01.06.2013 - 19:07:02

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] Sat Jun 01 19:07:02 2013 87 0.000087

4 ETW000 [ dev trc,00000] db_con_init called 43 0.000130

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000 71 0.000201

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 41 0.000242

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

4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 60 0.000325

4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, addr 000007FEF0670000

4 ETW000 869 0.001194

4 ETW000 [ dev trc,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll" 29 0.001223

4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 30 0.001253

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 32 0.001285

4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.430) 474 0.001759

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 40 0.001799

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 28 0.001827

4 ETW000 [ dev trc,00000] New connection 0 created 38 0.001865

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 59 0.001924

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

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 38 0.001989

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 25 0.002014

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 53 0.002067

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.002092

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol 45 0.002137

4 ETW000 ==> connect info for default DB will be read from ssfs

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2

4 ETW000 52 0.002189

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 850] 52 0.002241

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3965]

4 ETW000 203 0.002444

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2351]

4 ETW000 1000 0.003444

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1271]

4 ETW000 547 0.003991

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 911]

4 ETW000 788 0.004779

4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs

4 ETW000 46 0.004825

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 850] 34 0.004859

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3965]

4 ETW000 118 0.004977

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2351]

4 ETW000 869 0.005846

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1271]

4 ETW000 513 0.006359

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 911]

4 ETW000 696 0.007055

4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs

4 ETW000 45 0.007100

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 850] 34 0.007134

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3965]

4 ETW000 117 0.007251

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2351]

4 ETW000 863 0.008114

4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1271]

4 ETW000 561 0.008675

4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2373]

4 ETW000 207 0.008882

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage) [rsecssfs.c 911]

4 ETW000 439 0.009321

4 ETW000 [ dev trc,00000] read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage

4 ETW000 56 0.009377

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 27 0.009404

4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 133513 0.142917

4 ETW000 [ dev trc,00000] Thread ID:52152 58 0.142975

4 ETW000 [ dev trc,00000] lib_dbsl 720 05/22/2013 09:05:00 34 0.143009

4 ETW000 [ dev trc,00000] 720_EXT build 27 0.143036

4 ETW000 [ dev trc,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll'

4 ETW000 56 0.143092

4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 94 0.143186

4 ETW000 [ dev trc,00000] SAP patchlevel 0 30 0.143216

4 ETW000 [ dev trc,00000] SAP patchno 430 26 0.143242

4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 26 0.143268

4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 430 31 0.143299

4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Short dump - SAPSQL_ARRAY_INSERT_DUPREC (1861476)

4 ETW000 48 0.143347

4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 62 0.143409

4 ETW000 [ dev trc,00000] Sat Jun 01 19:07:03 2013 233974 0.377383

4 ETW000 [ dev trc,00000] lpc:(local) connection used on KBINDEV01 17135 0.394518

4 ETW000 [ dev trc,00000] spid 189 comm rd ODBC 74790 0.469308

4 ETW000 [ dev trc,00000] spid 186 unc rd ODBC 713 0.470021

4 ETW000 [ dev trc,00000] Driver: Adaptive Server Enterprise Driver release: 15.7.0.105 1268 0.471289

4 ETW000 [ dev trc,00000] Driver full version: Sybase ASE ODBC Driver/15.7.0/ESD#1/P/x86/Windows/drvmain/Build 105/32-bit/Normal/Wed Feb 15 UTC 18:35:16 2012

4 ETW000 77 0.471366

4 ETW000 [ dev trc,00000] GetServerInfo version: Adaptive Server Enterprise/15.7.0/EBF 20076 SMP ESD#01 Refresh#1/P/X64/Windows Server/aseasap/2926/64-bit/OPT/Thu May 24 01:24:50 2012

4 ETW000 740 0.472106

4 ETW000 [ dev trc,00000] GetServerInfo release: 15.7.0.012 820 0.472926

4 ETW000 [ dev trc,00000] GetServerInfo architecture: x86_64 49 0.472975

4 ETW000 [ dev trc,00000] GetServerInfo edition: P 26 0.473001

4 ETW000 [ dev trc,00000] GetServerInfo byte width: 64 bit 25 0.473026

4 ETW000 [ dev trc,00000] DbSlConnect hdl: 0 2242 0.475268

4 ETW000 [ dev trc,00000] trace file set 54 0.475322

4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 33 0.475355

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

4 ETW000 [ dev trc,00000] NTAB: unicodelg of executable is 2 36 0.479995

4 ETW000 [ dev trc,00000] NTAB: unicodelg of SVERS in nametab is 2 24 0.480019

4 ETW000 [ dev trc,00000] NTAB: standalone processing 52 0.480071

4 ETW000 [ dev trc,00000] NTAB: ntprofile(), read profile 23 0.480094

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

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

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

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

4 ETW000 [ dev trc,00000] NTAB: compute_hash_card: 2003. 36 0.480215

4 ETW000 [ dev trc,00000] NTAB: maxcnt 1000. 42 0.480257

4 ETW000 [ dev trc,00000] NTAB: hfactor 2003. 21 0.480278

4 ETW000 [ dev trc,00000] NTAB: mem_protocol_size 112 21 0.480299

4 ETW000 [ dev trc,00000] NTAB: hdr_backpack_offset 0 20 0.480319

4 ETW000 [ dev trc,00000] NTAB: hdr_backpack_size 0 20 0.480339

4 ETW000 [ dev trc,00000] NTAB: FTAB: header_size 88. 21 0.480360

4 ETW000 [ dev trc,00000] NTAB: FTAB: item_size 64. 20 0.480380

4 ETW000 [ dev trc,00000] NTAB: FTAB: item_cnt 1000. 21 0.480401

4 ETW000 [ dev trc,00000] NTAB: FTAB: unit_size 4 19 0.480420

4 ETW000 [ dev trc,00000] NTAB: FTAB: unit_cnt 128000. 21 0.480441

4 ETW000 [ dev trc,00000] NTAB: FTAB: data_size 512000. 20 0.480461

4 ETW000 [ dev trc,00000] NTAB: IREC: header_size 88. 21 0.480482

4 ETW000 [ dev trc,00000] NTAB: IREC: item_size 64. 20 0.480502

4 ETW000 [ dev trc,00000] NTAB: IREC: item_cnt 250. 20 0.480522

4 ETW000 [ dev trc,00000] NTAB: IREC: unit_size 16 20 0.480542

4 ETW000 [ dev trc,00000] NTAB: IREC: unit_cnt 6400. 20 0.480562

4 ETW000 [ dev trc,00000] NTAB: IREC: data_size 102400. 21 0.480583

4 ETW000 [ dev trc,00000] NTAB: STAB: header_size 88. 20 0.480603

4 ETW000 [ dev trc,00000] NTAB: STAB: item_size 64. 20 0.480623

4 ETW000 [ dev trc,00000] NTAB: STAB: item_cnt 250. 20 0.480643

4 ETW000 [ dev trc,00000] NTAB: STAB: unit_size 4 19 0.480662

4 ETW000 [ dev trc,00000] NTAB: STAB: unit_cnt 25600. 20 0.480682

4 ETW000 [ dev trc,00000] NTAB: STAB: data_size 102400. 21 0.480703

4 ETW000 [ dev trc,00000] NTAB: TTAB: header_size 200. 93 0.480796

4 ETW000 [ dev trc,00000] NTAB: TTAB: item_size 40. 28 0.480824

4 ETW000 [ dev trc,00000] NTAB: TTAB: item_cnt 1000. 21 0.480845

4 ETW000 [ dev trc,00000] NTAB: TTAB: unit_size 256 21 0.480866

4 ETW000 [ dev trc,00000] NTAB: TTAB: unit_cnt 1000. 21 0.480887

4 ETW000 [ dev trc,00000] NTAB: TTAB: data_size 256000. 21 0.480908

4 ETW000 [ dev trc,00000] NTAB: FTAB: hh_p ad83eb0, hh_len 88 636 0.481544

4 ETW000 [ dev trc,00000] NTAB: FTAB: aa_p ad84570, aa_len 16024 31 0.481575

4 ETW000 [ dev trc,00000] NTAB: FTAB: ia_p ad88410, ia_len 64000 22 0.481597

4 ETW000 [ dev trc,00000] NTAB: FTAB: dat_p ad97e20, dat_len 512000 23 0.481620

4 ETW000 [ dev trc,00000] NTAB: IREC: hh_p ad83f10, hh_len 88 22 0.481642

4 ETW000 [ dev trc,00000] NTAB: IREC: aa_p ae14e30, aa_len 16024 22 0.481664

4 ETW000 [ dev trc,00000] NTAB: IREC: ia_p ae18cd0, ia_len 16000 21 0.481685

4 ETW000 [ dev trc,00000] NTAB: IREC: dat_p ae1cb60, dat_len 102400 22 0.481707

4 ETW000 [ dev trc,00000] NTAB: STAB: hh_p ad83f70, hh_len 88 22 0.481729

4 ETW000 [ dev trc,00000] NTAB: STAB: aa_p ae35b70, aa_len 16024 22 0.481751

4 ETW000 [ dev trc,00000] NTAB: STAB: ia_p ae39a10, ia_len 16000 21 0.481772

4 ETW000 [ dev trc,00000] NTAB: STAB: dat_p ae3d8a0, dat_len 102400 22 0.481794

4 ETW000 [ dev trc,00000] NTAB: TTAB: hh_p ad83fd0, hh_len 200 22 0.481816

4 ETW000 [ dev trc,00000] NTAB: TTAB: aa_p ae568b0, aa_len 16024 21 0.481837

4 ETW000 [ dev trc,00000] NTAB: TTAB: ia_p ae5a750, ia_len 40000 22 0.481859

4 ETW000 [ dev trc,00000] NTAB: TTAB: dat_p ae643a0, dat_len 256000 22 0.481881

4 ETW000 [ dev trc,00000] NTAB: ntab_mem_protocol ad83fd0, ntab_mp_p ad83fd0, ntab_proc_id 0 36 0.481917

4 ETW000 [ dev trc,00000] NTAB: FTAB: hh_p ad83eb0, ha_list ad84570, hi_list ad88410, buffer ad97e20

4 ETW000 82 0.481999

4 ETW000 [ dev trc,00000] NTAB: IREC: hh_p ad83f10, ha_list ae14e30, hi_list ae18cd0, buffer ae1cb60

4 ETW000 38 0.482037

4 ETW000 [ dev trc,00000] NTAB: STAB: hh_p ad83f70, ha_list ae35b70, hi_list ae39a10, buffer ae3d8a0

4 ETW000 36 0.482073

4 ETW000 [ dev trc,00000] NTAB: TTAB: hh_p ad84040, ha_list ae568b0, hi_list ae5a750, buffer ae643a0

4 ETW000 36 0.482109

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

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

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

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

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

4 ETW000 5650 0.487894

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

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

4 ETW000 110 0.491261

4 ETW000 [ dbcrtab ,00000] ***LOG BZ9=>table MTSETTINGS does not exist in nametab 629 0.491890

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

4 ETW000 Connected to DBMS = SYBASE --- --- SYSTEM = 'DEV'.

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

4 ETW000 251 0.492180

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

4 ETW000 [ dev trc,00000] { dsql_open (con_da=(0,R/3),#binds=0,#input=0, 74 0.495038

4 ETW000 name=UNKNOWN, stmtid=NULL,

4 ETW000 stmt="SELECT EXECUTABLE,SAPRELEASE,HOSTNAME,PLATFORM,DBVENDOR,TIMESTAMP,PATCHNO,DBSLPATCHN FROM ...")

4 ETW000 [ dev trc,00000] } dsql_open()=0, *cu_id_p=1 2554 0.497592

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

4 ETW000 [ dev trc,00000] } dsql_fetch()=0, rec_cnt=1, mod_cnt=1 132 0.497766

4 ETW000 [ dev trc,00000] { dsql_close (con_da=(0,R/3),cu_id=1) 33 0.497799

4 ETW000 [ dev trc,00000] } dsql_close()=0 44 0.497843

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

4 ETW000 42 0.497885

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

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) 77 0.499741

4 ETW000 [ dev trc,00000] dbsync[db_syflush]: to_be_committed = 1 34 0.499775

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 : 01.06.2013 - 19:07:03

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [ dev trc,00000] Disconnecting from ALL connections: 231 0.000231

4 ETW000 [ dev trc,00000] DbSlDisconnect hdl: 0 33 0.000264

4 ETW000 [ dev trc,00000] Disconnected from connection 0 3985 0.004249

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

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

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 01.06.2013 - 19:07:03

running the command in that way you are not using the executable and libs of the upgrade in my point of view, but the actuals in E:\usr\sap\DEV\SYS\exe\uc\NTAMD64.

Try to update R3trans & TP in the upgrade dir and run the command from those...

Let me know

upgraded tp as well

now its working fine thanks you very much if any isue arise i wull post the thread please repply me

Thanks

my pleasure

Good luck

Answers (1)

Hi Sap Basis,

Run the Env command on os

and check the dbms_type value out there.

With Regards

Ashutosh Chaturvedi

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

EHP 6 upgrade error

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)

Re: MDK - setFocus AlwaysHide not working on Andro...

Re: How to make a REST "PUT" call to a dynamic url...

Re: Abap2xlsx: print internal table without header

Re: CF Deployment Error: Error getting tenant t0

Abap2xlsx: print internal table without header