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.

I'm runnung SA16 (16.0.0.2043) under linux (Ubuntu/trusty64) and VirtualBox as a service using the commands:

$ sudo /opt/sqlanywhere16/bin64/dbsvc -as -t network -s automatic -w demosvc -n demo -xd -x "tcpip(serverport=2600)" -oe /home/vagrant/demo/demo_errors.txt /home/vagrant/demo/demo.db
$ sudo service SA_demosvc start
That works fine, and I can successfully connect to the database service from Sybase Central.

The problem is that, sometimes, when I shutdown the machine and restart it, the service does not start up. If I try to start it manually, I see:

$ sudo service SA_demosvc start
Starting SAL Anywhere "Network" service demosvc
* Communication error
and the error file (demo_errors.txt) contains:
A Database server with that name has already started
Communication error

I've tried stopping the service - says there isn't one.
I've tried deleting the re-creating the service - problem persists.

I have found an unsatisfactory work-around that involves deleting the service and recreating it with a different server name (e.g.,, -n demo2), but that screws up the connection parameters for every client that is trying to use the database.

Has anyone else seen this? Am I missing something?

asked 29 Jan '15, 14:27

Terry%20Wilkinson's gravatar image

Terry Wilkinson
746303548
accept rate: 25%

edited 29 Jan '15, 14:30

OOPS! that was the problem!!!!!!! Thanks Breck!! I'd up-vote you if this was an answer :-(

(29 Jan '15, 14:49) Terry Wilkinson

Do you have a SQL Anywhere server (service or foreground) running on another computer, using that server name? There can be only one :)

alt text

permanent link

answered 29 Jan '15, 14:35

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

Thanks for the help Breck. I didn't immediately think of that constraint, and the error message, though completely accurate, didn't jog my memory.

(29 Jan '15, 22:34) Terry Wilkinson
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:

×261
×68
×40
×18

question asked: 29 Jan '15, 14:27

question was seen: 2,809 times

last updated: 29 Jan '15, 22:34