The last few weeks we have been seeing the following types of error, about the same time (luckily not peak) and lasting about 20 mins Sap.Data.SQLAnywhere.SAException (0x80004005): Connection error: Timeout occurred while waiting for connection response Sap.Data.SQLAnywhere.SAException (0x80004005): Database server not found Sap.Data.SQLAnywhere.SAException (0x80004005): Connection error: No IP address found for Error Today the DB server crashed (first time that has ever happened and I have used Sybase going back to 1996) Where is the best place to start looking to track down where these errors are coming from? The error code appears to be very generic Thanks |
Can you add LOG=<file_spec> to the connection string for client side connection debugging and add -z -o <filespec) the the server startup. You can also configure the server option by using sa_server_option() procedure to set DebuggingInformation (-z) and the ConsoleLogFile (-o).
Do you have any insight into what the server is doing at the time that this occurs given that it occurs about the same time each day? Do you have an event or other schedule task?
If you have a support, please consider opening an incident so that we can look into this topic in more detail.
Chris
Thanks for the reply
Then I just add this to the end of the string ...;PrefetchBuffer=8192; LOG=SomeFileName"?
Where will client side logging be saved to? Do I need to add an extension to the file name (.log, .txt...)? Is both client side and server side required? (We can only restart the DB server once a month when the host machine updates are applied and it's rebooted)
When troubleshooting connectivity, it is best to get logs from both client and server. The file name is user defined and has no specific naming requirements. I suggest providing a full path to avoid any issues with were the file is created. As noted, you do not need to restart the server - in that case, use the sa_server_option procedure to enable the debug logging and if needed the log file (if there is not an -o option being used).
call sa_server_option( 'DebuggingInformation', 'Yes' ); call sa_server_option( 'ConsoleLogFile', '<filespec>' );
When the problem is captured, you can turn off this logging as follows:
call sa_server_option( 'DebuggingInformation', 'No' ); call sa_server_option( 'ConsoleLogFile', '' );
Note: ConsoleLogFile should only be set if the engine is not already using -o. If that is already used, the debug information will be directed to that location.