11
Site '%s' not found in interfaces file.
When you execute a remote procedure call (RPC) from one Adaptive Server to another, the local interfaces file of the initiating Adaptive Server has to contain information about the remote Adaptive Server.
Error 7220 occurs in one of the following situations:
When you try to execute an RPC on an Adaptive Server which is not referenced in the local interfaces (or sql.ini) file. Its name can, however, be found in the sysservers table.
When you attempt to use the dump or load commands and the Backup Server is not listed in the interfaces (or sql.ini) file.
Throughout this write-up, your network addressing file
is referred to as the “interfaces file” although
the file name on Windows platforms is sql.ini.
Eliminate the 7220 error by following the instructions that are appropriate to your situation.
Use dsedit or dscp to check the items in the steps below:
Determine whether the local interfaces file has the query entry for the remote Adaptive Server.
Determine whether the Adaptive Server name is spelled correctly in the local interfaces file and if the tabs are set correctly at the beginning of each row which contains information about the Adaptive Server ports.
If you cannot find any information about the remote Adaptive Server in any interfaces file, you have two options. You can either:
Use a backup copy of the local or remote interfaces file, and add the name of the remote Adaptive Server to the local interfaces file manually. Add the query entry for the remote Adaptive Server to the local interfaces file
or:
Look for lines like the following in your remote Adaptive Server error log (the example is from a Solaris system). If you do not have a backup copy of the local interfaces file, check the remote Adaptive Server’s error log for the network name and port numbers at the last restart (that is, at the end of the error log file). Refer to the Open Client/Server installation guide for your platform for more information about Adaptive Server ports.
... 00:00000:00008:2007/09/13 15:51:58.34 kernel network name sampa, interface IPv4, address 158.78.41.25, type tcp, port 8915, filter NONE ....
Look for the port number, the network type, and the machine name.
Add an entry to the interfaces file like the following:
ase1502_64 master tcp ether sampa 8915 query tcp ether sampa 8915
WARNING! Before you add Adaptive Server’s query, master, and console entries to the local interfaces file, verify that no other Adaptive Server has the same port numbers assigned in the local interfaces file.
After changing the interfaces file, try accessing the remote Adaptive Server through isql or, if it is not running, restart it.
Also check your hardware error log for possible hardware failures, in case you still cannot reboot or access the remote Adaptive Server.
The entry for the local Backup Server is created when you install Adaptive Server. If you have installed a remote Backup Server on another machine, choose one of these options to resolve the error:
Copy the interfaces file entry for this Backup Server to the interfaces file on the machine where your Adaptive Server runs.
Locate the interfaces file on a file system that is shared by both machines.
Use the dsedit or dscp utility to update your interfaces file on the machine where your Adaptive Server runs. Refer to the Adaptive Server configuration and installation guide for your platform for information about these utilities.
For more additional information, refer to the “allow remote access” configuration parameter in the System Administration Guide: Volume 1chapter “Setting Configuration Parameters,” and “interfaces file” in the Adaptive Server Enterprise installation and configuration guide for your platform.
All versions
