2EETW169 no connect possible : "DBMS = SYBASE____" r3trans finished (0012)

[Former Member]

hi,

my server will work after restarting i am getting this error every 2 days:

i am getting the errror in R3trans as below:

2EETW169 no connect possible : "DBMS = SYBASE____" r3trans finished (0012)

and my Trans.log file show as below:

4 ETW000 R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09). 4 ETW000 unicode enabled version 4 ETW000 =============================================== 4 ETW000 4 ETW000 date&time : 08.02.2017 - 00:19:12 4 ETW000 control file: <no ctrlfile> 4 ETW000 R3trans was called as follows: R3trans -x 4 ETW000 trace at level 2 opened for a given file pointer 4 ETW000 [ dev trc,00000] Wed Feb 08 00:19:12 2017 231 0.000231 4 ETW000 [ dev trc,00000] db_con_init called 60 0.000291 4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information 4 ETW000 113 0.000404 4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3 4 ETW000 42 0.000446 4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 25 0.000471 4 ETW000 [ dev trc,00000] Loading DB library 'dbsybslib.dll' ... 81 0.000552 4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, count 1, addr 00007FFFC0C30000 4 ETW000 1542 0.002094 4 ETW000 [ dev trc,00000] using "E:\usr\sap\NSB\DVEBMGS00\exe\dbsybslib.dll" 18 0.002112 4 ETW000 [ dev trc,00000] Library 'dbsybslib.dll' loaded 21 0.002133 4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbsybslib.dll 18 0.002151 4 ETW000 [ dev trc,00000] Version of 'dbsybslib.dll' is "742.06", patchlevel (0.25) 417 0.002568 4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbsybslib.dll 32 0.002600 4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbsybslib.dll 15 0.002615 4 ETW000 [ dev trc,00000] New connection 0 created 38 0.002653 4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 4 ETW000 41 0.002694 4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 31 0.002725 4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3 4 ETW000 23 0.002748 4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 14 0.002762 4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 4 ETW000 45 0.002807 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 18 0.002825 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol 28 0.002853 4 ETW000 ==> connect info for default DB will be read from ssfs 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): profile parameter auth/shadow_upgrade is not set ==> connect info for shadow upgrade will not be read with an extra upgrade key set 4 ETW000 37 0.002890 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2 4 ETW000 94 0.002984 4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1437] 4 ETW000 84 0.003068 4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\data\SSFS_NSB.DAT" opened for read [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 4919] 4 ETW000 17026 0.020094 4 ETW000 [ dev trc,00000] RSecSSFs: SSFS-1430: File "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\key\SSFS_NSB.KEY" cannot be opened in mode "rb": No such file or directory (errno = 2); at this location, this is not considered an error [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1788] 4 ETW000 1525 0.021619 4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\key\SSFS_NSB.KEY" not found, using default key [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 2843] 4 ETW000 89 0.021708 4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1526] 4 ETW000 953 0.022661 4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs 4 ETW000 57 0.022718 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 31 0.022749 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2 4 ETW000 49 0.022798 4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1437] 4 ETW000 60 0.022858 4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\data\SSFS_NSB.DAT" opened for read [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 4919] 4 ETW000 1919 0.024777 4 ETW000 [ dev trc,00000] RSecSSFs: SSFS-1430: File "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\key\SSFS_NSB.KEY" cannot be opened in mode "rb": No such file or directory (errno = 2); at this location, this is not considered an error [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1788] 4 ETW000 1399 0.026176 4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\key\SSFS_NSB.KEY" not found, using default key [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 2843] 4 ETW000 80 0.026256 4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1526] 4 ETW000 831 0.027087 4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs 4 ETW000 68 0.027155 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 32 0.027187 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2 4 ETW000 37 0.027224 4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1437] 4 ETW000 58 0.027282 4 ETW000 [ dev trc,00000] RSecSSFs: Data file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\data\SSFS_NSB.DAT" opened for read [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 4919] 4 ETW000 1821 0.029103 4 ETW000 [ dev trc,00000] RSecSSFs: SSFS-1430: File "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\key\SSFS_NSB.KEY" cannot be opened in mode "rb": No such file or directory (errno = 2); at this location, this is not considered an error [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1788] 4 ETW000 1341 0.030444 4 ETW000 [ dev trc,00000] RSecSSFs: Key file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\key\SSFS_NSB.KEY" not found, using default key [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 2843] 4 ETW000 73 0.030517 4 ETW000 [ dev trc,00000] RSecSSFs: SSFS-4215: Data file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\data\SSFS_NSB.DAT" exists, but does not contain the requested entry [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 4949] 4 ETW000 316 0.030833 4 ETW000 [ dev trc,00000] RSecSSFs: SSFS-4218: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 4959] 4 ETW000 76 0.030909 4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: SSFS-4218: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage <-- SSFS-4215: Data file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\data\SSFS_NSB.DAT" exists, but does not contain the requested entry) [D:/depot/bas/742_REL/src/krn/rsec/rsecssfs.c 1526] 4 ETW000 578 0.031487 4 ETW000 [ dev trc,00000] read_ssfs_record(): not found is accepted, RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : SSFS-4218: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage <-- SSFS-4215: Data file "\\SANDBOXSAP\sapmnt\NSB\SYS\global\security\rsecssfs\data\SSFS_NSB.DAT" exists, but does not contain the requested entry 4 ETW000 81 0.031568 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): deregister callback ssfs_dbi_trace 28 0.031596 4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 250767 0.282363 4 ETW000 [ dev trc,00000] Thread ID:5248 41 0.282404 4 ETW000 [ dev trc,00000] lib_dbsl 742 10/21/2014 16:59:00 20 0.282424 4 ETW000 [ dev trc,00000] connection unquiesced 32 0.282456 4 ETW000 [ dev trc,00000] Using dynamic link library 'E:\usr\sap\NSB\DVEBMGS00\exe\dbsybslib.dll' 4 ETW000 44 0.282500 4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 30 0.282530 4 ETW000 [ dev trc,00000] SAP patchlevel 0 15 0.282545 4 ETW000 [ dev trc,00000] SAP patchno 28 16 0.282561 4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 29 0.282590 4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 25 16 0.282606 4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: stat stack overflow (2080663) 23 0.282629 4 ETW000 [ dev trc,00000] Wed Feb 08 00:19:13 2017 486320 0.768949 4 ETW000 [ dev trc,00000] spid 69 comm rd ODBC 37 0.768986 4 ETW000 [ dev trc,00000] spid 70 unc rd ODBC 528 0.769514 4 ETW000 [ dev trc,00000] Driver: Adaptive Server Enterprise Driver release: 16.0.01.01 45423 0.814937 4 ETW000 [ dev trc,00000] Driver full version: SAP ASE ODBC Driver/16.0.01.01/16.0 SP01 PL01/P/x86_64/Windows/drvmain/Build 1/64-bit/Normal/Wed Mar 25 UTC 21:39:29 2015/SQLLEN8 4 ETW000 62 0.814999 4 ETW000 [ dev trc,00000] Driver uses SQLLEN8 18 0.815017 4 ETW000 [ dev trc,00000] dbs/syb/cache_size: 200 16 0.815033 4 ETW000 [ dev trc,00000] GetServerInfo version: Adaptive Server Enterprise/16.0 SP01 PL01/EBF 24359 SMP/P/X64/Windows Server/ase160sp01plx/3663/64-bit/FBO/Wed Apr 01 04:09:11 2015 4 ETW000 600 0.815633 4 ETW000 [ dev trc,00000] GetServerInfo release: 16.0.01.01 590 0.816223 4 ETW000 [ dev trc,00000] GetServerInfo architecture: x86_64 30 0.816253 4 ETW000 [ dev trc,00000] GetServerInfo edition: P 15 0.816268 4 ETW000 [ dev trc,00000] GetServerInfo byte width: 64 bit 16 0.816284 4 ETW000 [ dev trc,00000] DbSlConnect hdl: 0 38646 0.854930 4 ETW000 [ dev trc,00000] trace file set 55 0.854985 4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 24 0.855009 4 ETW000 Connected to database. 4 ETW000 [ dev trc,00000] Disconnecting from ALL connections: 47651 0.902660 4 ETW000 [ dev trc,00000] DbSlDisconnect hdl: 0 29 0.902689 4 ETW000 [ dev trc,00000] DbSlDisconnect curr_thread_id: 5248 hdl 0 thread_id: 5248 20 0.902709 4 ETW000 [ dev trc,00000] Disconnected from connection 0 1961 0.904670 4 ETW000 [ dev trc,00000] statistics db_con_commit (com_total=0, com_tx=0) 34 0.904704 4 ETW000 [ dev trc,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 18 0.904722 4 ETW000 Disconnected from database. 4 ETW000 End of Transport (0000). 4 ETW000 date&time: 08.02.2017 - 00:19:13

Thank you.

Naveen

[Manigandan02]

Hi

You resolved this issue