Cannot start ASE backup server

[former_member1050515]

I installed SAP ASE 16.0 and I am trying to load a database from a backup and I get the following when executing:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.

A look at the log file shows me this:

Jan 26 11:07:34 2021: Open Server Error: 16253.10.0: srv_thread_props(): property SRV_T_LISTENADDR not valid for service thread .

Jan 26 11:07:34 2021: Started listener at

Jan 26 11:07:34 2021: Open Server Error: 16240.10.0: Net-Library routine sybnet_listen() failed in srv__start_net Network error: status = 23 - Net-Lib protocol driver call to register a listener failed .

Jan 26 11:07:34 2021: Open Server Server Fatal Error: 16029.20.0: Failed to start any network listeners

I've tried manually restarting the SAP BCKServer service but get Error 1067: The process terminated unexpectedly and I get those same entries in the log file

[Mark_A_Parsons · Accepted solution]

My initial thought is an issue with the name of the (windows) service, the name of the backupserver as ASE knows it and/or an issue with the backupserver entry in the sql.ini file.

What does the (windows) service show as the name of the backupserver process?

Could you log into your ASE instance, run sp_helpserver, and then post the entire contents here for us to see?

Also please post the contents of your sql.ini file (default location is %SYBASE%\ini\sql.ini).

[former_member1050515 · Accepted solution]

sure thing (seems like my screenshots don't want to attach)

Service name from Services:

• SYBBCK_BOC_Backup

Display name from Services:

• SAP BCKServer _ BOC_Backup

results of sp_helpserver (also attached because the paste looks real badsp-helpserver-results.png😞

name	network_name	security_mechanism	server_principal	class	status	id	cost
BOC	BOC			local	 	 0	   0
BOC_XP	BOC_XP			RPCServer	no timeouts, no net password encryption, writable , enable login redirection	 2	1000
SYB_BACKUP	BOC_Backup			ASEnterprise	timeouts, no net password encryption, writable , enable login redirection	 1	NULL

contents of sql.ini file (original port number was 5001 but have tried numerous unused ports):

[BOC]
master=NLWNSCK,Graeme-PC,5000

query=NLWNSCK,Graeme-PC,5000

[BOC_Backup]
master=nlmsnmp,Graeme-PC,5051
query=nlmsnmp,Graeme-PC,505

[former_member1050515 · Accepted solution]

ahHA! No, I didn't make any modifications other than the port number (and yes, good catch, didn't copy/paste full string). Changing the entry as you described worked like a charm.

Much appreciated!

[katrinhelm]

Hello graeme_housego42,

are you running on Linux? If yes, please check (please use the corresponding commands for windows)

1. Could you please check with "netstat -ano | grep <port>" command, if there is already a process on the backup server port running? See interfaces file for that, on which port the backupserver will be started (execute in sybase/<SID> folder a "cat interfaces"). And please check if the host is valid which is entered there.

2. Please check as well, if backup server is running already. There could be a backup server process visible on OS side: "ps -ef | grep backupserver".

3. In addition, please check /etc/hosts for invalid entries.

And maybe please check as well: KBA 2344498 & KBA 2424948

Ps: Is this a remote dump/load? Some additional information would help to answer such questions much faster.

Bets regards,
Katrin

[former_member1050515]

Hi Katrin,

This is a Windows installation, I am very new to SAP ASE so I don't have all the lingo down yet. To answer your questions:

1. No the port is not in use (using netstat -aon | findstr <port>)

2. The service is not already running (tasklist | find "bcksrvr")

3. There are no invalid entries in my hosts file.

I do not have access to those KB articles

[katrinhelm]

Hi graeme_housego42,

could you please try to change the port anyhow once to see, if the backup server can be started on a different port?

Please try to change it in the interfaces file manually or via dsedit.

BR,

Katrin

[former_member1050515]

I tried several different unused ports and the same result every time.