SAP Knowledge Base Article - Preview

2641477 - [ASE Error SQL30293:HY000][SAP][ASE ODBC Driver]The socket failed to connect within the timeout specified. - SAP ASE

Symptom

  • SAP Export on ECC 6.0 EHP-8 Test System (Source system) has occurred ASE ODBC Driver issue during the export.
  • An error occurred while processing option SAP NetWeaver 7.5 > SAP ASE > System Copy > Source System > Based on AS ABAP > Export Preparation
  • Last error reported by the step: Execution of the command "tp.exe "pf=C:/Program Files/sapinst_instdir/NW750/SYB/COPY/EXP/AS-ABAP/PREEXP/tp.pf" getdbinfo SID" finished with return code 232.

Output:

TRACE-INFO: 1: [ dev trc,00000] Thu May 03 15:07:10 2018
TRACE-INFO: 2: [ dev trc,00000] DlLoadLib success: LoadLibrary("dbsybslib.dll"), hdl 0, count 1, addr 00007FFEDEB20000
TRACE-INFO: 3: [ dev trc,00000] using "\PATH\dbsybslib.dll"
TRACE-INFO: 4: [ dev trc,00000] database is local: connect_timeout: 3
TRACE-INFO: 5: [ dev trc,00000] Thread ID:6568
TRACE-INFO: 6: [ dev trc,00000] lib_dbsl 749 03/23/2018 14:39:00
TRACE-INFO: 7: [ dev trc,00000] Using dynamic link library '\PATH\dbsybslib.dll'
TRACE-INFO: 8: [ dev trc,00000] dbsybslib.dll patch info TRACE-INFO: 9: [ dev trc,00000] SAP patchlevel 0
TRACE-INFO: 10: [ dev trc,00000] SAP patchno 500
TRACE-INFO: 11: [ dev trc,00000] Last SYBASE DBSL patchlevel 0
TRACE-INFO: 12: [ dev trc,00000] Last SYBASE DBSL patchno 500
TRACE-INFO: 13: [ dev trc,00000] Last SYBASE DBSL patchcomment SYB: Function modul DB_GETSET is very slow (2623164)
TRACE-INFO: 14: [ dev trc,00000] Thu May 03 15:07:13 2018
TRACE-INFO: 15: [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6113]
TRACE-INFO: 16: [ dev trc,00000] (30293) [HY000] [SAP][ASE ODBC Driver]The socket failed to connect within the timeout specified.
TRACE-INFO: 17: [ dev trc,00000]
TRACE-INFO: 18: [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
TRACE-INFO: 19: [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6113]
TRACE-INFO: 20: [ dev trc,00000] (30012) [08001] [SAP][ASE ODBC Driver]Client unable to establish a connection
TRACE-INFO: 21: [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
TRACE-INFO: 22: [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=XXX;port=0000;uid=SAPSR3;db=SID;pwd=xxxxxxxxxxx;TextSize=2147483647;CRC=0;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;QuotedIdentifier=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=1;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;ProtocolCapture=cap_p6248_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
TRACE-INFO: 23: [ dblink ,00000] ***LOG BY2=>sql error 30012 performing CON
TRACE-INFO: 24: [ dblink ,00000] ***LOG BY0=>[ASE Error SQL30293:HY000][SAP][ASE ODBC Driver]The socket failed to connect within the timeout specified.
ERROR: Connect to SID failed (20180503150713, [ASE Error SQL30293:HY000][SAP][ASE ODBC Driver]The socket failed to connect within the timeout specified.


Read more...

Environment

  • SAP ASE 16.0 SP02 PL05
  • SAP ECC 6.0 EHP-8
  • Windows 2012 r2 standard

Product

SAP ERP 6.0

Keywords

dbs_syb_port , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.