Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

We have several database servers in AWS cloud in ap-southeast-2 region. On each server we have several SAP ASA 17 databases (17.0.10.5963), running as Windows services.
Each service is configured as delayed auto start. On 24.02 24 and 26.02.24 we had the following problem. After server reboot several (1-5) database services didn’t started on all servers.
There are no messages in database logs saying that database was started. No errors (-oe file). In Windows system log we have messages like this:
“A timeout was reached (30000 milliseconds) while waiting for the SQLANYs...DB service to connect.”
“The SQL Anywhere - ...DB service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.”

No messages about dbsrv17.exe crash.

DB service parameters are like this:
-n AU1409_CMS -x tcpip(ServerPort=40415) D:\XXX.db -o D:\YYY.txt -on 2M -oe D:\ZZZ.txt -gnl 20 -sb 0 -xd

Is it possible to avoid this error?

ps There is a SAP note, but for ASE:
2599552 - Error 1053:The service did not respond to the start or control request in a timely fashion - SAP ASE
Is it worth trying to use the solution (set ServicesPipeTimeout = «180000») from it?

asked 27 Feb, 03:32

Ilia63's gravatar image

Ilia63
1.2k525782
accept rate: 44%


ServicesPipeTimeout is a general setting for the Windows service control manager, so you can provide more time for all services to start.

What you observe might be just a slow VM environment. It might even be that the SC manager has not even called the main routine for dbsrv17 to start before the timeout killed it already again (therefore you don't see any logs from dbsrv17).

permanent link

answered 28 Feb, 08:55

Martin's gravatar image

Martin
9.0k130169257
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×22

question asked: 27 Feb, 03:32

question was seen: 303 times

last updated: 28 Feb, 08:55