Troubleshooting and Error Messages Guide

Home

Troubleshooting and Error Messages Guide

Chapter 3 Error Message Writeups

Distributed Database Network Errors

Error 7235

Severity

Error message text

No other query entry found for the remote server %s - site %s. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.

Explanation

Communication between an Adaptive Server and another server requires a site handler to manage connections between the servers. When you log on to Server A, and issue a command that necessitates communication with Server B (such as Backup Server for dumps and loads), Server A uses a site handler to open a connection to Server B, sending the query and receiving results from Server B.

When the first attempt to open a site handler connection fails, Adaptive Server raises Error 7234 ("Failed to connect to remote server %s %s %s %s %s for site %s. Trying the next query entry of this server, if any."). The server then re-tries the connection using the next entry, if any, in the interfaces file. Error 7235 is raised after all such connection attempts fail.

Action

Check that the remote server is up and running. If you see the error after issuing a dump command, for example, type the following:
```
1> exec SYB_BACKUP...sp_who
2> go
```
If Backup Server is running, you will get a meaningful response to this query.
Check the remote server's network name in sysservers:
```
1> select srvname, srvnetname from master..sysservers
2> go
```
The remote server's srvnetname entry must match the name appearing in the interfaces file. (An incorrect srvnetname can prevent the server from reaching the correct remote server.)

Additional information

Have the following information ready when you call Sybase Technical Support:

Server version and SWR rollup level
Server error log
Text of all error messages.

Versions in which this error is raised

All versions


	Expand Search