Searching the Error Log for Messages

Search log entries based on words or phases, the date, and the number of recent messages.

Prerequisites
Register and authenticate the agent to enable error log viewing.
Task
  1. Open the server error log view.
    • To view server error log entries from the monitor view: From the Perspective Resources view, click the drop-down arrow that appears next to the server name, then select Monitor. In the Adaptive Server Monitor window, click on Error Log.
    • To view server error log entries from the Administration Console: In the left pane of the Administration Console, select ASE Servers to populate the right pane with a list of servers. Select a server, click the drop-down arrow that appears next to the name, then select View Error Log.
    • To view server error log entries from an instance in the Adaptive Server Cluster Edition: In the left pane of the Administration Console, select Cluster Management > Instances. Select an instance, click the drop-down arrow that appears next to the name, then select View Error Log.
    The error log window appears. The last 1000 log entries are displayed by default.
  2. (Optional) In the error log view, you can deselect Auto Refresh, which allows additional log messages to be added to the error log viewer as they occur.
  3. Click Show Search Options.
  4. In the Search text field, enter words or phases to isolate server messages containing the entry. Once a search is applied, the words and phases that have been entered are available for future searches by selecting down arrow next to the text field.
  5. (Optional) Uncheck Ignore Case to limit the search to the exact text case entered.
  6. Choose the number of entries in which to search or a specific time frame.
    • Search all entries.
    • Specify the number of last log entries in which to search.
    • Specify the number of days, hours, or minutes in which to search.
    • Specify a specific from and to date in which to search.
  7. (Optional) Select one or more flag types to limit the search for specific types of log messages.
  8. Click Apply Search Options.
    The error log is updated based on the search options.
  9. (Optional) Sort columns in ascending or descending order.
  10. (Optional) Click Restore Defaults to reset the search options to the default values.
  11. (Optional) Click Also reset search before selecting Hide Search Options to reset the search options to the default values when collapsing the search options menu.
Parent topic: Adaptive Server Error Log