Skip to Content
1
Former Member
Jun 03, 2013 at 05:07 AM

ASE Error SQL30012:08001]Client unable to establish a connection

3029 Views

Hi All,

I am facing error while upgrading erp 6.0 ehp6 ,R3trans-d RC=12

Below is the r3trans log

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 : 03.06.2013 - 10:35:48

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 Jun 03 10:35:48 2013 87 0.000087

4 ETW000 [ dev trc,00000] db_con_init called 42 0.000129

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

4 ETW000 68 0.000197

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

4 ETW000 38 0.000235

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

4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 56 0.000312

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

4 ETW000 785 0.001097

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

4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 27 0.001151

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

4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "720.00", patchlevel (0.210) 57752 0.058931

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

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

4 ETW000 [ dev trc,00000] New connection 0 created 31 0.059045

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 58 0.059103

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

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

4 ETW000 35 0.059163

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 23 0.059186

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 50 0.059236

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

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

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 47 0.059350

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

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

4 ETW000 215 0.059616

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 1156 0.060772

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 728 0.061500

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

4 ETW000 934 0.062434

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

4 ETW000 46 0.062480

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

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

4 ETW000 116 0.062628

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 1291 0.063919

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 684 0.064603

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

4 ETW000 859 0.065462

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

4 ETW000 45 0.065507

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

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

4 ETW000 115 0.065654

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 1312 0.066966

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 682 0.067648

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 219 0.067867

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 539 0.068406

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 55 0.068461

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 23 0.068484

4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 6053 0.074537

4 ETW000 [ dev trc,00000] Thread ID:17684 49 0.074586

4 ETW000 [ dev trc,00000] lib_dbsl 720_REL 02/23/2012 10:32:00 29 0.074615

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

4 ETW000 50 0.074665

4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 64 0.074729

4 ETW000 [ dev trc,00000] SAP patchlevel 0 28 0.074757

4 ETW000 [ dev trc,00000] SAP patchno 210 23 0.074780

4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 25 0.074805

4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 210 25 0.074830

4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment Sybase ASE R3load fastload is failing (1688468)

4 ETW000 42 0.074872

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

4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3081]

4 ETW000 20462 0.095380

4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection

4 ETW000 54 0.095434

4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 49 0.095483

4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3081]

4 ETW000 15520 0.111003

4 ETW000 [ dev trc,00000] (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection

4 ETW000 47 0.111050

4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART 30 0.111080

4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=KBINDEV01;port=4901;uid=SAPSR3;db=DEV;pwd=xxxxxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=ServerDefault;EncryptPassword=2;EnableLOBLocator=0;app=R3 00 comm rd ODBC;logintimeout=3;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;

4 ETW000 89 0.111169

4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 30012 performing CON 231 0.111400

4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL30012:08001]Client unable to establish a connection[ASE Error SQL30012:08001]Client unable to establish a connection

4 ETW000 67 0.111467

2EETW169 no connect possible: "DBMS = SYBASE --- "