1898718 - Warning “Internal warning: Main dispatch took X seconds” indicates long startup of SQL Anywhere during Windows boot phase

Symptom

The start of the SQL Anywhere database server takes more than 2 minutes during the boot phase of the Windows server. If the related SQL Anywhere service is started manually after the boot phase, the server starts within seconds.

The server message log reports the following (warning):
:
I. 08/13 12:31:25. Using broadcast address of: 127.255.255.255
I. 08/13 12:31:30. Server not found (no reply received)
I. 08/13 12:31:30. TCPIP link started successfully
I. 08/13 12:34:48. Now accepting requests
I. 08/13 12:34:48. Starting TCPIP listener on IP address 0.0.0.0:2638
I. 08/13 12:34:48. Starting TCPIP listener on IP address (::):2638
W. 08/13 12:36:48. Internal warning: Main dispatch took 197 seconds
:

Environment

SAP Sybase SQL Anywhere 12 and higher

Product

SAP SQL Anywhere all versions

Keywords

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.