Skip to Content
Former Member
Apr 22, 2013 at 10:46 AM

SAP loses connection to Sybase ASE database


Hello all,

I'm currently having an issue on a newly installed SAP system on Sybase ASE, where the SAP workprocesses seem to lose the connection to the database and go into reconnect status. A reconnection is never achieved until the entire instance is restarted (both SAP and the Sybase ASE database). While the SAP processes cannot connect to the database anymore, I can still connect to the database using (db)isql.

Here's a segment of a SAP work process developer trace:

C Mon Apr 22 12:47:24 2013

C database is local: connect_timeout: 3

C Thread ID:4084

C lib_dbsl 720 03/06/2013 13:33:00

C 720_EXT build

C Using dynamic link library 'E:\usr\sap\XMD\DVEBMGS00\exe\dbsybslib.dll'

C dbsybslib.dll patch info

C SAP patchlevel 0

C SAP patchno 420

C Last SYBASE DBSL patchlevel 0

C Last SYBASE DBSL patchno 420

C Last SYBASE DBSL patchcomment Sybase IQ: Enable remote/secondary connect to Sybase IQ (1737415)

C lpc:(local) connection used on XPEMON01


C Mon Apr 22 12:47:27 2013

C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4028]

C (30012) [08001] [Sybase][ODBC Driver]Client unable to establish a connection

C syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART

I'm running kernel 7.20_EXT x64 Unicode, patch 402, dbsybslib.dll patch 420 and version of the ODBC driver.

Does anybody have any ideas about this? Thanks in advance!

Kindest regards, WIlbert