Dispatcher moved to gray status after my new sap 7,51 installation on open suse on oracle VMware

[sudhir_ck77]

Hi

I am getting connection error when dispatcher is trying to connect to sybase. Pl help me on this. Pl check the below log from DEV_W0

Regards Sudhir

C lib_dbsl 745 12/15/2015 10:39:00 C dbsybslib.dll patch info C SAP patchlevel 0 C SAP patchno 30 C Last SYBASE DBSL patchlevel 0 C Last SYBASE DBSL patchno 9 C Last SYBASE DBSL patchcomment SYB: error 701 with R3load fastload option using bulk inse (2190271) C C Tue Dec 12 10:22:43 2017 C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 5110] C (30012) [08001] [SAP][ASE ODBC Driver]Client unable to establish a connection C syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART C Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=vhcalnplci;port=4901;uid=SAPSR3;db=NPL;pwd=xxxxxxxxxxx;TextSize=2147483647;$ C B ***LOG BV3=> severe db error 30012; work process is stopped [dbsh 1257] B ***LOG BY2=> sql error 30012 performing CON [dblink 625] B ***LOG BY0=> [ASE Error SQL30012:08001][SAP][ASE ODBC Driver]Client unable to establish a connection [dblink 625] M ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 88] M in_ThErrHandle: 1 M *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2495] *********************************************************************************************************** Trans.log 4 ETW000 R3trans version 6.25 (release 745 - 30.10.15 - 12:47:42 ). 4 ETW000 unicode enabled version 4 ETW000 =============================================== 4 ETW000 4 ETW000 date&time : 21.12.2017 - 17:06:18 4 ETW000 control file: <no ctrlfile> 4 ETW000 R3trans was called as follows: R3trans -d 4 ETW000 trace at level 1 opened for a given file pointer 4 ETW000 [ dev trc,00000] Thu Dec 21 17:06:18 2017 4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/NPL/SYS/exe/run/dbsybslib.so' ... 4 ETW000 [ dev trc,00000] Library '/usr/sap/NPL/SYS/exe/run/dbsybslib.so' loaded 4 ETW000 [ dev trc,00000] Version of '/usr/sap/NPL/SYS/exe/run/dbsybslib.so' is "745.04", patchlevel (0.9) 4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol 4 ETW000 ==> connect info for default DB will be read from ssfs 4 ETW000 [ dev trc,00000] Thu Dec 21 17:06:19 2017 4 ETW000 [ dev trc,00000] load of SQLLEN8 SYB library libsybdrvodb8.so successful. 4 ETW000 [ dev trc,00000] database is local: connect_timeout: 3 4 ETW000 [ dev trc,00000] lib_dbsl 745 12/15/2015 10:39:00 4 ETW000 [ dev trc,00000] dbsybslib.dll patch info 4 ETW000 [ dev trc,00000] SAP patchlevel 0 4 ETW000 [ dev trc,00000] SAP patchno 30 4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchlevel 0 4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchno 9 4 ETW000 [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: error 701 with R3load fastload option using bulk inse (2190271) 4 ETW000 [ dev trc,00000] Thu Dec 21 17:06:20 2017 4 ETW000 [ dev trc,00000] spid 113 comm rd ODBC 4 ETW000 [ dev trc,00000] spid 114 unc rd ODBC 4 ETW000 [ dev trc,00000] Driver: Adaptive Server Enterprise (ANSI) Driver release: 16.0.02.02 4 ETW000 [ dev trc,00000] Driver full version: SAP ASE ODBC Driver/16.0.02.02/16.0 SP02 PL02/P/x86_64/Linux/drvmain/Build 1/64-bit/Normal/Thu Oct 08 UTC 17:57:38 2015/SQLLEN8 4 ETW000 [ dev trc,00000] Driver uses SQLLEN8 4 ETW000 [ dev trc,00000] dbs/syb/cache_size: 200 4 ETW000 [ dev trc,00000] GetServerInfo version: Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux/ase160sp02plx/2492/64-bit/FBO/Sat Nov 21 04:05:39 2015 4 ETW000 [ dev trc,00000] GetServerInfo release: 16.0.02.02 4 ETW000 [ dev trc,00000] GetServerInfo architecture: x86_64 4 ETW000 [ dev trc,00000] GetServerInfo edition: P 4 ETW000 [ dev trc,00000] GetServerInfo byte width: 64 bit 4 ETW000 [ dev trc,00000] Thu Dec 21 17:06:21 2017 4 ETW000 [ dev trc,00000] DbSlConnect hdl: 0 4 ETW000 [ dev trc,00000] trace file set 4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 4 ETW000 [ dev trc,00000] NTAB: Structure of NTAB on DB is VERS_B, unicodelg of executable is 2, unicodelg of SVERS in nametab is 2 4 ETW000 Connected to DBMS = SYBASE --- --- SYSTEM = 'NPL'. 4 ETW690 COMMIT "0" "0" 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 : 21.12.2017 - 17:06:23 4 ETW000 function : CONNECT 4 ETW000 buffersync : YES 4 ETW000 clients : default 4 ETW000 purgedocu : YES 4 ETW000 commit : 100000 4 ETW000 table cache : dynamic 4 ETW000 4 ETW000 [ dev trc,00000] Thu Dec 21 17:06:23 2017 4 ETW000 [ dev trc,00000] Disconnecting from ALL connections: 4 ETW000 [ dev trc,00000] DbSlDisconnect hdl: 0 4 ETW000 [ dev trc,00000] Disconnected from connection 0 4 ETW000 [ dev trc,00000] statistics db_con_commit (com_total=1, com_tx=1) 4 ETW000 [ dev trc,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 4 ETW000 Disconnected from database. 4 ETW000 End of Transport (0000). 4 ETW000 date&time: 21.12.2017 - 17:06:23

[isaias_freitas]

Hello Sudhir,

At the other question, you have provided the output of "R3trans -d" and it showed no issues.

However, the dev_w0 trace file on this thread shows that the work processes cannot connect to the databse.

Please edit the tag of this incident, and switch it to a tag related to the SAP Sybase database (maybe "Sybase Adaptive Server Enterprise").

We need assistance from the Sybase team ;-).

Regards,

Isaías