Messages

Answer: The most common reason is that the Foxhound database didn't start properly, and the most common reason for that is some other process is using HTTP port 80 so the SQL Anywhere engine that runs Foxhound can't start.

See also...
Can't start HTTP listener on address 127.0.0.1:80

Answer: If this condition persists, try stopping and restarting Foxhound.

Answer: This message is safe to ignore if it is produced by the All Programs - Foxhound1 - Tools - Backup Foxhound Database process:

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
A subdirectory or file backup already exists.
*** Ignore "A subdirectory or file backup already exists."
The system cannot find the file specified.
*** Ignore "The system cannot find the file specified."
*** Foxhound backup started
*** Starting dbeng11 if necessary...
SQL Anywhere Start Server In Background Utility Version 11.0.1.2276
DBSPAWN ERROR:  -816
Specified database file already in use
*** Ignore "Specified database file already in use"
*** Starting dbbackup...
SQL Anywhere Backup Utility Version 11.0.1.2276
 (36864 of 83663 pages, 44% complete) 

Answer: An ALERT email is sent when one or more target database conditions match user-defined criteria.

The Alerts Criteria Page lets you turn alerts on and off and specify alert criteria for a particular target database. Individual criteria may include a threshold amount and/or a duration or waiting period.

The "Recent alert history" section of an ALERT email is a list of recent ALERT, ALL CLEAR and CANCELLED conditions for this target database.

The "Recent sample history" section of an ALERT email shows what the Foxhound History page looks like when the alert was issued, including blocked and current connections.

The sort order for the current connections section of an ALERT email depends on the alert condition, as follows:

Alert Email	Connection Sort Order	Connections Sorted On
1 - Database unresponsive	descending	CPU Time
2 - Long heartbeat	descending	CPU Time
3 - Long sample time	descending	CPU Time
4 - CPU usage	descending	CPU Time
5 - Database disk space	descending	Disk Writes
6 - Temp disk space	descending	Disk Writes
7 - Log disk space	descending	Disk Writes
8 - Other disk space	descending	Disk Writes
9 - Arbiter unreachable	descending	CPU Time
10 - Partner unreachable	descending	CPU Time
11 - HA failover	descending	CPU Time
12 - HA mode change	descending	CPU Time
13 - File fragmentation	descending	Disk Writes
14 - Waiting requests	descending	CPU Time
15 - Incomplete I/Os	descending	Disk Writes
16 - I/O operations	descending	Disk Writes
17 - Checkpoint urgency	descending	Disk Writes
18 - Recovery urgency	descending	Disk Writes
19 - Cache size	descending	CPU Time
20 - Cache satisfaction	ascending	Cache Satisfaction
21 - Temp file usage	descending	Temp Space
22 - Conn temp file usage	descending	Temp Space
23 - Blocked connections	descending	Conns Blocked
24 - Conn blocking others	descending	Conns Blocked
25 - Locks	descending	Locks Held
26 - Connections	descending	CPU Time
27 - Connection CPU	descending	CPU Time
28 - Long transaction	descending	Transaction Running Time
29 - Cache panics	descending	Cache Satisfaction

The Foxhound Options - Email Settings page lets you specify general email settings.

See also...
Foxhound Options - Email Settings
Alerts Criteria Page
ALL CLEAR ...
CANCELLED ...

Answer: This alert may not have anything to do with High Availability. Foxhound uses any runtime change in the server name to trigger this alert, and that can happen if you manually stop and restart the target database with a different server name.

If you are not using HA, you can disable Alert #11 to avoid this message.

Answer: An ALL CLEAR email is sent when an alert criteria is no longer met. If a waiting period is specified on the Alerts Criteria Page, Foxhound waits for approximately half that time before issuing the all clear.

The "Recent alert history" section of an ALL CLEAR email is a list of recent ALERT, ALL CLEAR and CANCELLED conditions for this target database.

The Foxhound Options - Email Settings page lets you specify general email settings.

See also...
Foxhound Options - Email Settings
Alerts Criteria Page
ALERT ...
CANCELLED ...

Answer: You have to run the Foxhound "unsetup" process before reinstalling Foxhound, or before installing a new version.

If you forget, you will see this error when you run the Foxhound setup; this is a limitation of the way the InstallShield setup for Foxhound is constructed:

There are three ways to run the Foxhound unsetup process:

• Click on start - All Programs - Foxhound1 - Tools - Unsetup Foxhound, or

• use the Control Panel - Add or Remove Programs dialog to remove Foxhound Version 1, or

• run this command: MsiExec.exe /X{B6CE87CB-2838-49AC-9E48-6E867BDD4B93}

Here's what you see when you click on start - All Programs - Foxhound1 - Tools - Unsetup Foxhound:

See also...
How do I install Foxhound?
How do I install a new version of Foxhound?
How do I reinstall Foxhound?
Why is it called "unsetup" instead of "uninstall"?
How do I remove Foxhound from my system?

Answer: A CANCELLED email is sent as soon as some alert criteria is changed or disabled using the Alerts Criteria Page. At that point the alert testing process "starts over"; it doesn't matter what the change is. For example, even if the new alert condition is already met when the change is made, if there is a waiting period it is honored before a new alert is issued.

The "Recent alert history" section of a CANCELLED email is a list of recent ALERT, ALL CLEAR and CANCELLED conditions for this target database.

The Foxhound Options - Email Settings page lets you specify general email settings.

See also...
Foxhound Options - Email Settings
Alerts Criteria Page
ALERT ...
ALL CLEAR ...

Answer: The Foxhound engine has probably already been started; i.e., a SQL Anywhere 11 database engine is the "another process" using the Foxhound database file. It is usually safe to ignore this message and proceed to use your browser to connect to Foxhound.

In Foxhound build 3655 and later this message is not displayed by the standard shortcuts Start Foxhound via Firefox and Start Foxhound via IE.

See also...
How do I start Foxhound?

Answer: If the full message looks like one of these:

Cannot open transaction log file -- Can't use log file "foxhound.log" since the database file has been used more recently

Cannot open transaction log file -- Can't use log file "foxhound.log" since the offsets don't match the offsets in the database file

start - All programs - Foxhound - Foxhound Tools - Start Foxhound via Firefox - debug

start - All programs - Foxhound - Foxhound Tools - Start Foxhound via IE - debug

Answer: If you are using one of the following "debug" shortcuts to stop and restart the Foxhound engine, try running it again; the previous dbeng11.exe process did not have time to release the foxhound1_debug.txt file before a new dbeng11.exe process tried to open that file:

All Programs - Foxhound1 - Tools - Start Foxhound via Firefox - debug

All Programs - Foxhound1 - Tools - Start Foxhound via IE - debug

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
Stopping the Foxhound engine if it is running...
SQL Anywhere Stop Server Utility Version 11.0.1.2276
Starting the Foxhound engine...
SQL Anywhere Start Server In Background Utility Version 11.0.1.2276
DBSPAWN ERROR:  -81
Invalid database server command line
******************************************************************
*** ERROR ********************************************************
*** dbspawn/dbeng11 set ERRORLEVEL = 1
*** To display startup diagnostics,
Press any key to continue . . .
04/23 06:39:58. Can't open Message window log file: foxhound1_debug.txt
Press any key to continue . . .

See also...
Invalid database server command line

Answer: Some other HTTP web server (Apache, IIS, another SQL Anywhere engine, etc) is probably already using TCP/IP port 80.

Either stop that other process, or tell Foxhound to use a different port.

See also...
What HTTP port should I use for Foxhound?
How do I tell Foxhound to use an HTTP port other than 80?
IANA port number assignments
Could not bind to address ...
Database server shutdown due to startup error

Answer: This is an unexpected message.

Please contact technical support at breck.carter@gmail.com.

Answer: This is an unexpected message.

Please contact technical support at breck.carter@gmail.com.

Answer: Messages like this appearing in Foxhound Options - Display Diagnostics mean that the Foxhound Monitor has given up waiting for a "connection failed" response to its attempt to connect to the target database:

   1663 2010-06-13 06:58:13.796 Full Build 3700a 1000000035 202a3a(202eh1) 
   Connection timeout for target DSN xxx after 15.1s (timeout threshold is 15.0s; see Foxhound Options) - 1000002348

Note that Foxhound does not give up trying to connect just because a connection failed, that's not what this kind of "timeout" is; for more information see Foxhound Options - Connection Timeout.

To stop further attempts to restart start sampling for this target database after a timeout, click on Start Sampling, then Cancel Request.

To stop all further attempts to restart sampling after a time out, or to change how often the attempts are made, see Foxhound Options - Timeout Retry.

See also...
Foxhound Options - Connection Timeout
Foxhound Options - Timeout Retry
Foxhound Options - Display Diagnostics

Answer: The rroad1.dll file may be missing from the Foxhound installation folder. Try reinstalling Foxhound.

Here is where rroad1.dll is installed by default on Windows XP and Vista:

C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound1
C:\ProgramData\RisingRoad\Foxhound1

• First, make sure that rroad1.dll is located in the same folder as the Foxhound database foxhound1.dll.
• Second, stop and restart the Foxhound database to ensure that rroad1.dll can be loaded.
• Finally, use the DSN tab on the Foxhound main menu to connect to a database without getting the "Could not load dynamic library..." message.

Note: The rroad1.dll file contains the very small portion of Foxhound logic that had to be written in C. The vast majority of Foxhound's code is written in SQL including all of the schema analysis, monitor logic and HTML creation.

See also...
How do I reinstall Foxhound?

Answer: Some other HTTP web server (Apache, IIS, another SQL Anywhere engine, etc) is probably already using TCP/IP port 80.

Either stop that other process, or tell Foxhound to use a different port.

See also...
What HTTP port should I use for Foxhound?
How do I tell Foxhound to use an HTTP port other than 80?
IANA port number assignments
Can't start HTTP listener on address 127.0.0.1:80
Database server shutdown due to startup error

Answer: There are two or more sampling sessions with the same target database, possibly because there are two or more different ODBC DSNs or connection strings that point to the same target database.

When you upgrade Foxhound to a new build, each sampling session tries to update the three Foxhound properties procedures on its target database, and only one attempt will work for each target.

You will see three or more error messages along with the three successful "Info:" exceptions:

2010-06-25 04:32:58.531 Full Build 3706a 1000000006 701.a3(701eh2) CREATE PROCEDURE rroad_engine_properties failed. SQLSTATE = WO005, ERRORMSG() = Server 'p002': [Sybase][ODBC Driver][SQL Anywhere]Item 'rroad_engine_properties' already exists
2010-06-25 04:32:58.531 Full Build 3706a 1000000005 204.d1b(204eh-b6) Info: Procedure rroad_engine_properties has been upgraded from build number 3705 to 3706 on aaa3 ddd11 dba sql
2010-06-25 04:37:21.437 Full Build 3706a 1000000026 702.a3(702eh2) CREATE PROCEDURE rroad_database_properties failed. SQLSTATE = WO005, ERRORMSG() = Server 'p001': [Sybase][ODBC Driver][SQL Anywhere]Item 'rroad_database_properties' already exists
2010-06-25 04:37:21.437 Full Build 3706a 1000000027 204.d6b(204eh-b9) Info: Procedure rroad_database_properties has been upgraded from build number 3705 to 3706 on sales
2010-06-25 04:37:21.687 Full Build 3706a 1000000027 204.e2b(204eh-c3) Info: Procedure rroad_connection_properties has been upgraded from build number 3705 to 3706 on sales
2010-06-25 04:37:21.703 Full Build 3706a 1000000026 700.a3(700eh2) CREATE PROCEDURE rroad_connection_properties failed. SQLSTATE = WO005, ERRORMSG() = Server 'p001': [Sybase][ODBC Driver][SQL Anywhere]Item 'rroad_connection_properties' already exists

See also...
How do I see Foxhound diagnostics, errors and exceptions?

Answer: When installing a new version of Foxhound, the data from an existing Foxhound database earlier than build 1.3586 cannot be upgraded.

The new Foxhound database will be installed but it will not contain any of the monitor samples or option settings from the old database.

Answer: If you are connecting via the String tab, here are the likely causes:

• If you have not specified a a DSN, make sure to specify a DRIVER.
  
  
• If there is a space ahead of the DRIVER parameter, try removing it. Certain versions of SQL Anywhere have a problem with that.
  
  
• If you have specified a DSN, make sure it exists. Try using the DSN tab instead.

Answer: Here are some possibilities:

• A local target server was specified, and that server is not running.
  
  
• A HOST= network server address was specified, and that server is not running.
  
  
• The correct HOST= network server address was specified on the Network tab, but the ENG= server name is wrong.
  
  
• The wrong HOST= network server address was specified on the Network tab.
  
  
• Caution: If you change the HOST= value, you may connect to the wrong server if a different, but working, IP address was cached in the workstation file C:\Program Files\Sybase\SQL Anywhere 9\win32\asasrv.ini. To avoid using this cache file specify "DOBROADCAST=NONE" on the Network tab; e.g.: use HOST=ip-address;DOBROADCAST=NONE to force only that address to be used.

Answer: Some other HTTP web server (Apache, IIS, another SQL Anywhere engine, etc) may already be using TCP/IP port 80.

If so, either stop that other process, or tell Foxhound to use a different port.

See also...
What HTTP port should I use for Foxhound?
How do I tell Foxhound to use an HTTP port other than 80?
IANA port number assignments
Can't start HTTP listener on address 127.0.0.1:80
Could not bind to address ...

Answer: This message is safe to ignore. It is a false error which is sometimes displayed by the "debug" shortcuts used to start the Foxhound engine:

All Programs - Foxhound1 - Tools - Start Foxhound via Firefox - debug

All Programs - Foxhound1 - Tools - Start Foxhound via IE - debug

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
Stopping the Foxhound engine if it is running...
SQL Anywhere Stop Server Utility Version 11.0.1.2276
Unable to stop database server -- Database server not found.
Starting the Foxhound engine...
SQL Anywhere Start Server In Background Utility Version 11.0.1.2276
******************************************************************
*** ERROR ********************************************************
*** dbspawn/dbeng11 set ERRORLEVEL = 0
*** To display startup diagnostics,
Press any key to continue . . .
*** No startup diagnostics are available.
Press any key to continue . . .
Launch IE to (try to) open the Foxhound display...
Press any key to continue . . .

Answer: This is a generic error message produced by the dbspawn.exe utility when the Foxhound database fails to start properly because dbeng11.exe has detected some problem. To determine what the real problem is, try using one of the "debug" shortcuts to start the Foxhound engine:

All Programs - Foxhound1 - Tools - Start Foxhound via Firefox - debug

All Programs - Foxhound1 - Tools - Start Foxhound via IE - debug

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
Stopping the Foxhound engine if it is running...
SQL Anywhere Stop Server Utility Version 11.0.1.2276
Starting the Foxhound engine...
SQL Anywhere Start Server In Background Utility Version 11.0.1.2276
DBSPAWN ERROR:  -81
Invalid database server command line
******************************************************************
*** ERROR ********************************************************
*** dbspawn/dbeng11 set ERRORLEVEL = 1
*** To display startup diagnostics,
Press any key to continue . . .
04/23 06:39:58. Can't open Message window log file: foxhound1_debug.txt
Press any key to continue . . .

See also...
Can't open Message window log file: foxhound1_debug.txt

Answer: This is a generic error message produced by the dbspawn.exe utility when the Foxhound database fails to start properly because dbeng11.exe has detected some problem. To determine what the real problem is, try using one of the "debug" shortcuts to start the Foxhound engine:

All Programs - Foxhound1 - Tools - Start Foxhound via Firefox - debug

All Programs - Foxhound1 - Tools - Start Foxhound via IE - debug

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
Stopping the Foxhound engine if it is running...
SQL Anywhere Stop Server Utility Version 11.0.1.2276
Starting the Foxhound engine...
******************************************************************
*** ERROR ********************************************************
*** dbspawn/dbeng11 set ERRORLEVEL = 255
*** To display startup diagnostics,
Press any key to continue . . .
04/24 04:05:44. Can't open Message window log file: foxhound1_debug.txt
Press any key to continue . . .

See also...
Can't open Message window log file: foxhound1_debug.txt

Answer: This is a generic error message produced by the dbspawn.exe utility when the Foxhound database fails to start properly because dbeng11.exe has detected some problem. To determine what the real problem is, try using one of the "debug" shortcuts to start the Foxhound engine:

All Programs - Foxhound1 - Tools - Start Foxhound via Firefox - debug

All Programs - Foxhound1 - Tools - Start Foxhound via IE - debug

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
Stopping the Foxhound engine if it is running...
SQL Anywhere Stop Server Utility Version 11.0.1.2276
Starting the Foxhound engine...
SQL Anywhere Start Server In Background Utility Version 11.0.1.2276
DBSPAWN ERROR:  -81
Invalid database server command line
******************************************************************
*** ERROR ********************************************************
*** dbspawn/dbeng11 set ERRORLEVEL = 1
*** To display startup diagnostics,
Press any key to continue . . .
04/23 06:39:58. Can't open Message window log file: foxhound1_debug.txt
Press any key to continue . . .

See also...
Can't open Message window log file: foxhound1_debug.txt

Answer: An Alert email could not be sent because of an SMTP error.

Here's an example where the Alert email subject was "09:02 - ALERT #7 - Log disk space - test10_local" and the SMTP return code was 554:

EMAIL FAILURE - SMTP send email failed with return code 554 when sending "09:02 - ALERT #7 - Log disk space - test10_local"

See also...
SMTP Error Codes & SMTP Status Codes & SMTP Reply Codes Reference 2010.

Answer: Look in the target database server console log for a message like this:

Cannot open dbspace 'xxx' from file 'incorrect-filespec'.

If that's the problem, fix the filespec in the target database

ALTER DBSPACE xxx RENAME 'correct-filespec';

Answer: The Database Monitor portion of the Foxhound Basic edition will stop sampling the target database and display one of the following messages when one of its limitations of the Basic edition is exceeded:

   3:32:14 PM    1.8s   -- Foxhound Extended edition is required for more than 1 physical processor on the target server --
   3:32:12 PM    2.1s   -- Foxhound Extended edition is required for more than 1 physical processor on the target server at -- 

   2:11:52 PM   10.0s   -- Foxhound Extended edition is required for more than 100 target database connections --
   2:11:42 PM    6.5s   -- Foxhound Extended edition is required for more than 100 target database connections at -- 

   1:58:03 AM   12.5s   -- Foxhound Extended edition is required for use with SQL Anywhere Standard or Advanced edition --
   1:57:50 AM    2.4s   -- Foxhound Extended edition is required for use with SQL Anywhere Standard or Advanced edition at --

To continue sampling you must obtain an Extended edition registration key and enter it on the Foxhound About page.

See also...
What are the differences among the different editions of Foxhound: Beta, Evaluation, Basic and Extended?

Answer: Foxhound needs "JavaScript" or "Active scripting" to be enabled in the browser; here's how:

Firefox 3: Tools - Options - Content - check "Enable JavaScript"

IE 8: Tools - Internet Options - Security - Local intranet - Custom level...
   - Scripting - Active scripting - check "Enable"

Answer: Try connecting from the browser again.

Answer: Sampling stopped because the Foxhound engine was not running.

When Foxhound is restarted it will automatically try to reconnect to the target database and start sampling again.

Answer: If Foxhound is trying to make connection to a local SQL Anywhere 5.5 target database, make sure that "Agent - Not Specified" is selected on the Startup Options dialog box of the ODBC DSN. In particular, the registry entry for the ODBC DSN should not include an "Agent"="..." line.

Answer: This is a generic error message produced by the dbspawn.exe utility when the Foxhound database fails to start properly because dbeng11.exe has detected some problem. To determine what the real problem is, try using one of the "debug" shortcuts to start the Foxhound engine:

All Programs - Foxhound1 - Tools - Start Foxhound via Firefox - debug

All Programs - Foxhound1 - Tools - Start Foxhound via IE - debug

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
Stopping the Foxhound engine if it is running...
SQL Anywhere Stop Server Utility Version 11.0.1.2276
Starting the Foxhound engine...
SQL Anywhere Start Server In Background Utility Version 11.0.1.2276
DBSPAWN ERROR:  -81
Invalid database server command line
******************************************************************
*** ERROR ********************************************************
*** dbspawn/dbeng11 set ERRORLEVEL = 1
*** To display startup diagnostics,
Press any key to continue . . .
04/23 06:39:58. Can't open Message window log file: foxhound1_debug.txt
Press any key to continue . . .

See also...
Can't open Message window log file: foxhound1_debug.txt

Answer: Passwords may be cAsE sEnSiTiVe in target databases created with SQL Anywhere Version 10 and later.

Perhaps the password has changed and Foxhound needs to use the new value:

• If this message appears on the Foxhound Monitor page for a session that uses an ODBC DSN to connect, and the user id and password specified inside that DSN are used to make the connection, try updating the DSN to specify the new password.
• If this message appears on the Foxhound Monitor page for a session that uses an ODBC DSN to connect, but the user id and password were explicitly specified on the Foxhound menu when the Monitor session was originally started, try specifying the user id and new password on the menu page and clicking on the Monitor Database button again.

Answer: The Foxhound Options - Connection sampling threshold value prevented detailed information about any connections from being recorded.

Two versions of this message are produced; here's the full text:

No detailed information about blocked connections was recorded for the sample taken at xxx; see Foxhound Options - Connection sampling threshold.

No detailed information about the xxx connections was recorded for the sample taken at xxx; see Foxhound Options - Connection sampling threshold.

Answer: No samples have been recorded yet so there is no information about blocked connections yet either.

Two versions of this message are produced; here's the full text:

No information about blocked connections has been gathered yet.

No information about connections has been gathered yet.

Answer: This sample was lost so there is no information about connections.

Two versions of this message are produced; here's the full text:

No information about blocked connections is available for the sample lost at xxx.

No information about connections is available for the sample lost at xxx.

Answer: The Foxhound purge process last ran at the "Older sample purged at ..." date/time, and the sample date/time shown to the left identifies the most recent sample that was deleted.

See Foxhound Options - Purge sample data.

Answer: Foxhound has been unable to create one or more of the following procedures on the target database:

rroad_connection_properties

rroad_database_properties

rroad_engine_properties

One solution is to GRANT RESOURCE to the user id Foxhound uses to connect to the target database.

Another solution is to create the procedures yourself on the target database, with the Foxhound user id as the owner.

See also...
Foxhound Help - Introduction and Setup - Connecting to Target Databases.

Answer: When using the DSN tab on the Foxhound menu to choose Display Schema or Monitor Database, both the user id and password values must be specified together, in the same place: either explicitly in the User Id: and Password: fields on the menu, or inside the target database ODBC DSN itself.

Currently, Foxhound cannot deal with the following scenarios:

• A DSN with an encrypted password.

  Workaround: Store the unencrypted password in the DSN, or specify the unencrypted password value in the Password: field on the menu together with the User Id: value.

• A user id with an empty password.

  Workaround: Create a user id with a non-empty password and use that user id instead.

This message may also appear in a Database Monitor session that was once able to connect to the target database via an ODBC User DSN, but is no longer able to connect because the Foxhound database was started as a service and thus requires System DSNs in order to connect to target databases. Try deleting the User DSN and recreating it as a System DSN; that will allow Foxhound to reconnect and resume sampling in the old sampling session rather that starting a new session.

Answer: You installed a new build of Foxhound, and when it connected to a target database it successfully pushed the new version of this stored procedure to that target database.

This message usually appears in sets of three because there are three procedures pushed to each target database "xxx":

Info: Procedure rroad_engine_properties has been upgraded from build number ... to ... on xxx
Info: Procedure rroad_database_properties has been upgraded from build number ... to ... on xxx
Info: Procedure rroad_connection_properties has been upgraded from build number ... to ... on xxx

Answer: A newer version of the Foxhound Monitor was previously used on this target database.

Use the new version of Foxhound instead of this one, or drop the following procedures from the target database so the old version of Foxhound can install its own version of these procedures:

rroad_engine_properties

rroad_database_properties

rroad_connection_properties

Answer: Try using a number larger than 600 for the one or both of the HTTP protocol options TimeOut (to) and KeepaliveTimeOut (kto)... or change them to zero to disable HTTP timeouts.

You can do this by editing one or more of the following Windows command files:

$start_foxhound1_engine.bat

$start_foxhound1_firefox.bat

$start_foxhound1_firefox_debug.bat

$start_foxhound1_ie.bat

$start_foxhound1_ie_debug.bat

C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound1

C:\ProgramData\RisingRoad\Foxhound1

-xs http(port=80;maxsize=0;to=600;kto=600)^

Answer: Samples were not recorded because you clicked Stop Sampling.

Answer: This error message may appear in two locations. It may be displayed on the Monitor page:

EMAIL FAILURE - SMTP send email failed with return code 5 when sending "03:34 - ALERT #1 - Database unresponsive - benchmark_test_on_BRECK-PC"

2 2010-03-10 03:34:38.484 Full Build 3642a 1000000083 223b9(223eh3) Info: SMTP send email failed with return code 5 when sending "03:34 - ALERT #1 - Database unresponsive - benchmark_test_on_BRECK-PC"

2 xp_startsmtp failed
3 xp_stopsmtp failed
5 xp_sendmail failed
12 Attachment not found
15 Insufficient memory
20 Unknown recipient
25 Mail session failed to start
100 Socket error.
101 Socket timeout.
102 Unable to resolve the SMTP server hostname.
103 Unable to connect to the SMTP server.
104 Server error; response not understood. For example, the message is poorly formatted, or the server is not SMTP.
105 A TLS error occurred
421 domain service not available, closing transmission channel.
450 Requested mail action not taken: mailbox unavailable.
451 Requested action not taken: local error in processing.
452 Requested action not taken: insufficient system storage.
500 Syntax error, command unrecognized. (This may include errors such as a command that is too long).
501 Syntax error in parameters or arguments.
502 Command not implemented.
503 Bad sequence of commands.
504 Command parameter not implemented.
550 Requested action not taken: mailbox unavailable. For example, the mailbox is not found, there is no access, or no relay is allowed.
551 User not local; please try forward-path
552 Request mail action aborted: exceeded storage allocation.
553 Requested action not taken: mailbox name not allowed. For example, the mailbox syntax is incorrect.
554 Transaction failed.

Answer: Use the ODBC Administrator link to check the ODBC DSN for a problem like this:

The "Database file:" field is filled in and "Start database automatically" is checked, but the database is already running. If your ODBC DSN specifies different "Server name" and/or "Database name" values than the ones already in use, it will try to start the same database file a second time, and that is not allowed.

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
A subdirectory or file backup already exists.
*** Ignore "A subdirectory or file backup already exists."
The system cannot find the file specified.
*** Ignore "The system cannot find the file specified."
*** Foxhound backup started
*** Starting dbeng11 if necessary...
SQL Anywhere Start Server In Background Utility Version 11.0.1.2276
DBSPAWN ERROR:  -816
Specified database file already in use
*** Ignore "Specified database file already in use"
*** Starting dbbackup...
SQL Anywhere Backup Utility Version 11.0.1.2276
 (36864 of 83663 pages, 44% complete) 

Answer: Check ODBC DSN or connection string for a problem like one of these:

• The server is running, but the database name is wrong.
  
  
• The server is not running, and no database file is specified.
  
  
• The server starts OK, but the specified database file is not found.

Answer: Currently, Foxhound only supports target databases created with SQL Anywhere versions 5.5, 6, 7, 8, 9, 10 and 11.

Answer: Currently, Foxhound only supports target databases running on SQL Anywhere 5.5, 6, 7, 8, 9, 10 and 11 engines.

Answer: Foxhound currently supports only databases created with SQL Anywhere 5.5, 6, 7, 8, 9, 10 and 11.

Answer: Other versions of SQL Anywhere can be used to run the databases being displayed, but Foxhound itself requires a particular version to run.

Answer: The Foxhound engine stopped because you clicked on the Stop Foxhound Engine button.

Answer: If the target database is using SQL Anywhere 5.5 and you get one of these messages, try upgrading the target database engine to 5.5.5.2787:

Syntax error: near 'rroad_..._properties' in "[rroad_..._properties]"

Syntax error: syntax error near 'creator'

Syntax error: syntax error near 'sa_conn_properties'

Syntax error: syntax error near 'table_name'

Answer: You may see the following error message if you are using the Task Scheduler on Windows Vista to backup the Foxhound database using the technique described here: (see How do I backup my Foxhound database on a regular basis?

******************************************************************
*** ERROR ********************************************************
*** The $backup_foxhound1.bat file looked for a path specification
*** in the FOXHOUND1 environment variable and it was empty.
*** Try rebooting and running $backup_foxhound1.bat again,
*** then contact Breck.Carter@gmail.com
******************************************************************

Here's a workaround: Reboot the computer after installing a new version of Foxhound.

See also...
How do I backup my Foxhound database on a regular basis?
How do I install a new version of Foxhound?
How do I reinstall Foxhound?

Answer: Start the Foxhound engine and try again.

Answer: The Foxhound post-setup process has begun to copy and upgrade the data stored in a previous version of the Foxhound database.

More information may be found in this file on Windows XP:

C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound1\setup\post_setup_trace.txt

C:\ProgramData\RisingRoad\Foxhound1\setup\post_setup_trace.txt

See also...
How do I install a new version of Foxhound?

Answer: The Foxhound post-setup process was unable to copy and upgrade the data stored in a previous version of the Foxhound database. This doesn't stop the new installation, but it does mean the history of Monitor samples and alerts did not get copied over to the new installation, nor did your Foxhound option and alert settings.

More information may be found in this file on Windows XP:

C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound1\setup\post_setup_trace.txt

C:\ProgramData\RisingRoad\Foxhound1\setup\post_setup_trace.txt

See also...
How do I install a new version of Foxhound?

Answer: The Foxhound post-setup process has successfully copied and upgraded the data stored in a previous version of the Foxhound database.

More information may be found in this file on Windows XP:

C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound1\setup\post_setup_trace.txt

C:\ProgramData\RisingRoad\Foxhound1\setup\post_setup_trace.txt

See also...
How do I install a new version of Foxhound?

Answer: Here is the full message text:

The Foxhound database must run on its own SQL Anywhere engine.
   Do not start another database on the same engine, and
   do not start the Foxhound database on an engine that is already running another database.

To get around this problem, take whatever steps are necessary to prevent any other database from being started on the Foxhound engine, and then stop and restart the Foxhound engine.

See also...
How do I stop and restart Foxhound?

Answer: The Foxhound engine stopped because you clicked on the Stop Foxhound Engine button.

Answer: The registration key you entered is either invalid, or it will not work on the copy of Foxhound you have installed.

Enter the correct registration key, or get a copy of Foxhound that will work with the key you have, or get another key.

Answer: BETA copies of Foxhound can only be activated using a "BETA" registration key. They cannot be activated as "FULL" copies.

Note that a BETA copy may be upgraded to a FULL copy later on. You will need to download and install a FULL copy and obtain a FULL registration key. The upgrade process will copy your data and then ask you for the registration key when you start Foxhound.

Answer: Try starting the Foxhound engine, and check the URL: http://localhost

Answer: This message is safe to ignore if it is produced by the All Programs - Foxhound1 - Tools - Backup Foxhound Database process:

C:\ProgramData\RisingRoad\Foxhound1>ECHO OFF
A subdirectory or file backup already exists.
*** Ignore "A subdirectory or file backup already exists."
The system cannot find the file specified.
*** Ignore "The system cannot find the file specified."
*** Foxhound backup started
*** Starting dbeng11 if necessary...
SQL Anywhere Start Server In Background Utility Version 11.0.1.2276
DBSPAWN ERROR:  -816
Specified database file already in use
*** Ignore "Specified database file already in use"
*** Starting dbbackup...
SQL Anywhere Backup Utility Version 11.0.1.2276
 (36864 of 83663 pages, 44% complete) 

Answer: Multiple indexes on the same columns often indicate an inefficiency or error in database design. Sometimes multiple indexes are redundant, and redundant indexes may waste space in the database; they may also waste time every time a row is inserted or deleted, and every time the indexed columns are updated. Other times, multiple indexes aren't redundant, but they still might indicate a flaw in the database design.

Note: Versions 10 and later of SQL Anywhere do not create duplicate physical indexes when duplicate logical indexes are defined. However, Foxhound still warns about these duplicates because it may be a design issue. The duplication may affect performance; e.g., if one of the indexes is incorrect it may not be used to improve performance in the way it was intended. It may also affect integrity; e.g., if one of the indexes is a foreign key referring to the wrong column it may not be used to check referential integrity in the way it was intended.

Note: Versions 7 and later of SQL Anywhere automatically create a separate unique index for every PRIMARY KEY and UNIQUE column or table constraint that you define, as well as a separate non-unique index for every FOREIGN KEY constraint. There is no reason to explicitly create indexes on the same columns, and such indexes are redundant.

However, versions 5 and 6 of SQL Anywhere create a combined index for each PRIMARY KEY or UNIQUE constraint; this index "also contains the entries for all foreign keys that reference this table, whether those foreign keys appear in the same table or in a different one" (from the ASA 6 User's Guide, Chapter 25, The effect of column order in a composite index). These combined indexes can be much larger than an ordinary index on the primary key or unique constraint columns, and in those cases an explicitly created unique index on the same columns may improve performance. Such indexes are no longer needed in versions 7 and later.

The following discussion is written in terms of SQL Anywhere Version 9; i.e., separate indexes are automatically created for all primary keys, unique constraints and foreign keys.

Each list of two or more indexes is sorted by "relative importance" to help you choose which ones to keep: primary key first, then foreign key, UNIQUE constraint, UNIQUE index and finally non-unique index.

Each pair of multiple indexes should be considered separately, as follows:

• Primary key and unique constraint on the same columns: The unique constraint is redundant and should be dropped; a primary key acts as a unique constraint and is supported by a unique index. If the unique constraint is clustered, make the primary key clustered.
  
  
• Primary key and unique index on the same columns: The unique index is redundant and should be dropped. If the unique index is clustered, make the primary key clustered.
  
  
• Primary key and non-unique index on the same columns: The non-unique index is redundant and should be dropped. If the non-unique index is clustered, make the primary key clustered.
  
  
• Primary key and foreign key on the same columns: Determine why this table has the same columns in the primary key as in the parent table's primary key or unique constraint that is the target of the foreign key; there may be a design error. Otherwise, if the primary key and foreign key are both required, there's nothing that can be done about the fact the foreign key index is redundant from a performance point of view.
  
  
• Two unique constraints on the same columns: One unique constraint is redundant and should be dropped. If one of the unique constraints is clustered, drop the other one.
  
  
• Unique constraint and unique index on the same columns: The unique index is redundant and should be dropped; each unique constraint is supported by a unique index. If the unique index is clustered, make the unique constraint clustered.
  
  
• Unique constraint and non-unique index on the same columns: The non-unique index is redundant and should be dropped. If the non-unique index is clustered, make the unique constraint clustered.
  
  
• Unique constraint and foreign key on the same columns: Determine why this table has the same columns in the candidate key (unique constraint) as in the parent table's primary key or unique constraint that is the target of the foreign key; there may be a design error. Otherwise, if the unique constraint and foreign key are both required, there's nothing that can be done about the fact the foreign key index is redundant from a performance point of view.
  
  
• Two unique indexes on the same columns: One unique index is redundant and should be dropped. If one of the unique indexes is clustered, drop the other one.
  
  
• Unique index and non-unique index on the same columns: The non-unique index is redundant and should be dropped. If the non-unique index is clustered, make the unique index clustered.
  
  
• Unique index and foreign key on the same columns: Determine why this table has the same columns in the unique index as in the parent table's primary key or unique constraint that is the target of the foreign key; there may be a design error. Otherwise, if the unique index and foreign key are both required, there's nothing that can be done about the fact the foreign key index is redundant from a performance point of view.
  
  
• Two non-unique indexes on the same columns: One non-unique index is redundant and should be dropped. If one of the non-unique indexes is clustered, drop the other one.
  
  
• Non-unique index and foreign key on the same columns: The non-unique index is redundant and should be dropped. If the non-unique index is clustered, make the foreign key clustered.
  
  
• Two foreign keys on the same columns: If the same primary key or unique constraint in the same parent table is the target for both foreign keys, one of the foreign keys is redundant and should be dropped. Otherwise, determine why two different foreign key constraints on the same column are required; there may be a design error. If both foreign keys are required, there's nothing that can be done about the fact one of them is redundant from a performance point of view.

Answer: Without a primary key or unique constraint, some operations may be slow.

Four different flavors of this message may be produced, flagged as Note, Warning, Caution and Danger:

Note: The table ... has no primary key or unique constraint, but does have a unique index.

This table currently has fewer than 1,000 rows so there may be no performance problems, but if the table grows larger those operations may become extremely slow.

Warning: The table ... has no primary key or unique constraint, but does have a unique index.

This table currently has more than 1,000 rows; performance may not be a problem now but if the table grows larger those operations may become extremely slow.

Caution: The table ... has no primary key or unique constraint, but does have a unique index.

This table has more than 100,000 rows so there is a very real chance those operations will be extremely slow.

Danger: The table ... has no primary key or unique constraint, but does have a unique index.

This table has more than one million rows so there is a very real danger those operations will be extremely slow; think geological time scale :)

See also...
The table ... has no primary key, unique constraint or unique index.

Answer: Because there is no way to uniquely identify each row in this table, queries and database recovery operations may be slow.

Four different flavors of this message may be produced, flagged as Note, Warning, Caution and Danger:

Note: The table ... has no primary key, unique constraint or unique index.

This table currently has fewer than 1,000 rows so there may be no performance problems, but if the table grows larger those operations may become extremely slow.

Warning: The table ... has no primary key, unique constraint or unique index.

This table currently has more than 1,000 rows; performance may not be a problem now but if the table grows larger those operations may become extremely slow.

Caution: The table ... has no primary key, unique constraint or unique index.

This table has more than 100,000 rows so there is a very real chance those operations will be extremely slow.

Danger: The table ... has no primary key, unique constraint or unique index.

This table has more than one million rows so there is a very real danger those operations will be extremely slow; think geological time scale :)

See also...
The table ... has no primary key or unique constraint, but does have a unique index.

Answer: The schema in the right frame is displayed using up-to-date information from the target database. This message is produced when you click on a table name in the left frame, and that table has been dropped since the left frame was displayed.

Answer: This is an informational message only. This view may raise a syntax error if you use it in a SQL statement.

Answer: This database only contains system tables. You can see the system tables by checking Include system tables on the main menu.

Answer: This database monitor session can no longer be displayed because it has been stopped and all the corresponding data has been deleted.

If you want to start monitoring this database again, open a new Foxhound menu and then use the Monitor Database button on the DSN or String tab of the Foxhound menu.

Answer: In Internet Explorer, go to Tools - Internet Options... - Advanced tab.

Then scroll down to Security options and check "Allow active content to run in files on My Computer".

Answer: Foxhound supports up to 10 monitor sampling sessions at one time. Try stopping one of the other sampling sessions; this one should then be able to start automatically.

Answer: This is an unexpected message.

Please contact technical support at breck.carter@gmail.com.

Answer: Messages like this appearing in the Foxhound database engine console log probably mean that the Foxhound Monitor has given up waiting for a "connection failed" response to its attempt to connect to the target database:

   User "DBA" dropped event connection 1000002348 ("rroad_monitor_sample_loop")

To confirm this, look for corresponding messages in Foxhound Options - Display Diagnostics; these diagnostic messages will tell you which target database is affected:

   1663 2010-06-13 06:58:13.796 Full Build 3700a 1000000035 202a3a(202eh1) 
   Connection timeout for target DSN xxx after 15.1s (timeout threshold is 15.0s; see Foxhound Options) - 1000002348

To stop further attempts to restart start sampling for this target database after a timeout, click on Start Sampling, then Cancel Request.

To stop all further attempts to restart sampling after a time out, or to change how often the attempts are made, see Foxhound Options - Timeout Retry.

See also...
Foxhound Options - Display Diagnostics
Connection timeout for target ... after ... (timeout threshold is ...; see Foxhound Options)
Foxhound Options - Connection Timeout
Foxhound Options - Timeout Retry