17
Can’t open a connection to site ’%S_SRVID’ because there are no remote sites available. Rerun when there are fewer active remote sites, or contact a user with System Administrator (SA) role.
The number of remote sites parameter (called remote sites in pre-11.0 releases) determines the number of site connection handlers that can be active at any one time. Site handlers maintain connections between Adaptive Servers, Backup Servers, and Open Server applications.
Error 7201 is raised if there are no site handlers available when the server attempts to open a connection to another server (named in the error text). This occurs when the number of remote entries in sysservers exceeds the number of remote sites. For example, the error may be seen when you execute a dump command, since this requires communication with Backup Server, which in turn requires a site handler.
7201 errors are corrected by configuring sufficient remote sites.
Check the number of remote sites:
1> sp_configure "number of remote sites" 2> go
The Run Value in
the output shows the number of remote sites that can access the
server simultaneously.
Increase the value of number of remote sites as necessary. This is a static parameter, so you must shut down and restart the server to have Adaptive Server use the new value.
See the chapter “Managing Remote Servers” in the System Administration Guide: Volume 1 for more information.
All versions
