SAP Knowledge Base Article - Preview

1893426 - After the "TCPIP link started successfully" message, the SQL Anywhere database server pauses in Microsoft Windows environments for up to 3 minutes

Symptom

  • When running in certain Microsoft Windows environments and starting the database server as a system service at system start-up, the SQL Anywhere database server may take additional time (observed to be up to three minutes, or 180 seconds) to accept requests from database clients after being able to successfully start the network communication interface.
  • The additional 3 minute pause would not be seen with SQL Anywhere 11 versions or earlier.
  • Starting the database server after the operating system has started will not show the same delay.
  • Tracing the SQL Anywhere database process during this time with a program such as Microsoft Sysinternals Process Monitor will show threads being started from the SQL Anywhere server and accessing the Microsoft Windows "Windows Management Instrumentation" (WMI) DLL "wbemprox.dll" in the thread stack trace.
  • The following messages will be shown in the SQL Anywhere database console log, showing timestamps that are three minutes apart:

    I. 01/01 12:00:00. TCPIP link started successfully
    I. 01/01 12:03:00. Now accepting requests


Read more...

Environment

  • Microsoft Windows XP, Vista, 7, 8, 2000, 2003, 2008, 2008 R2, 2012
  • SAP Sybase SQL Anywhere 12
  • SAP Sybase SQL Anywhere 16

Product

SAP SQL Anywhere 16.0 ; SAP Sybase SQL Anywhere 12.0

Keywords

11730929 , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

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

Search for additional results

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