Sybase RS agent fails to monitor as not able to read or find the "interfaces" or "sql.ini" file. The following messages may be present in the agent logs:
Either interfaces (on UNIX)or sql.ini (on Windows) File Does Not Exist
Replication Server Name has no mapping in the sql.ini file
com.quest.glue.core.agent.AgentInstance - Failed to start data collection
java.lang.RuntimeException: java.lang.RuntimeException: Failed to Initialize Agent. Excption:
For input string: "hostname"
Connection file (sql.ini / interfaces) is not present on the Foglight Agent Manager (FglAM) host.
Invalid characters prevent the file from being read.
Incorrect file format.
For Linux, there more than one space between values of the server connection parameters in the interfaces file.
The addition of a ssl field in a line of the interfaces file cannot be read
SYBASE_SERVER query tli tcp /dev/tcp \x000213880a3ee71c0000000000000000 master tli tcp /dev/tcp \x000213880a3ee71c0000000000000000
The sql.ini or interfaces connection file must be present in a path that is local to the FglAM host running the Sybase RS agent.
Invalid hidden characters in the file will cause issues when attempting to read. This can be confirmed by using a text editor with the option to see hidden symbols.
The connections file format (interfaces or sql.ini) should match the one for the Operating System of the FglAM host.
SAMPLE_RS master tcp ether 10.0.0.1 11752 query tcp ether 10.0.0.1 11752
[SAMPLE_RS] master=nlwnsck,10.0.0.1,11752 query=nlwnsck,10.0.0.1,11752
Verify if from the entries in the interfaces files there is any with more than one "space" character between any of its values. For example, two spaces between "master" and "tcp" will cause 'For input string: "hostname"' type errors when the agent tries to convert the string to a numerical value.
# Fails with 'For input string: "hostname"' SAMPLE_RS master tcp ether hostname 11752 query tcp ether hostname 11752
SAMPLE_RS master tcp ether hostname 11752 query tcp ether hostname 11752
Defect ID FOM-771 was logged to recognize interface file lines with SSL settings. This has been fixed in the 188.8.131.52 and higher releases of the Sybase SAP ASE cartridge.
In previous years this was the way to define an entry in the interfaces file. To translate these to the usual non-hex notation follow this simple method:
The new entry in the interfaces file should then be:
SYBASE_SERVER query tcp ether <hostname> 5000 master tcp ether <hostname> 5000