[What?] [How?] [Why?] [Messages] To see everything in one page: [What?] [How?] [Why?] [Messages]
Top Questions...
What is Foxhound?What's new in Foxhound 4?What are the system requirements? What edition of Foxhound do I need?How do I get a copy?How do I upgrade to Foxhound 4?
[What?] [How?] [Why?] [Messages] [Top]
What? What are the differences among all the activation keys? What are the differences among the different editions of Foxhound: Rental, Basic and Extended? What are the Foxhound system requirements? What does the connection-level "Transaction Running Time" tell me? What edition of Foxhound do I need? What environment variables are used by Foxhound? What happens when a copy of Foxhound expires? What HTTP port should I use for Foxhound? What is a "30-day Rental Key"? What is a "Basic To Extended Key"? What is a "Basic Upgrade Key"? What is a "New Basic Key"? What is a "New Extended Key"? What is a "Registration Key"? What is an "Activation Key"? What is an "Extended Upgrade Key"? What is Foxhound? What is the Foxhound End-User License Agreement (EULA)? What is the foxhound4.db ... .ORIGINAL_COPY file? What is the upgrade policy for installing new builds of Foxhound? What operating system will Foxhound run on? What versions of SQL Anywhere will Foxhound work with? What's new in Foxhound 4?
How? How do I backup my Foxhound database? How do I backup my Foxhound database on a regular basis? How do I change the Alerts criteria? (threshold settings, etcetera) How do I figure out what went wrong during an installation? How do I find the post_setup_trace.txt file? How do I force Foxhound to use the 32-bit version of SQL Anywhere? How do I get a copy of Foxhound? How do I get a registration key for Foxhound? How do I get an activation key for Foxhound? How do I get an HTTP request log for Foxhound? How do I get the new value of the FOXHOUND4 environment variable to show up after Foxhound is installed? How do I get the "Send Test Email" button to respond? How do I install a new version of Foxhound? How do I install Foxhound? How do I install version 16 of SQL Anywhere on the same machine used to run an earlier version of SQL Anywhere? How do I install version 17 of SQL Anywhere on the same machine used to run an earlier version of SQL Anywhere? How do I keep the Foxhound database file from growing so large? How do I keep the Foxhound log file from growing so large? How do I make Foxhound web pages available on the internet? How do I make the post-setup process run faster when a large Foxhound database is being upgraded? How do I make the upgrade process run faster? How do I measure latency and throughput? How do I measure response time and throughput? How do I monitor a large number of databases? How do I move Foxhound to a different disk drive? How do I move the Foxhound transaction log to a different physical disk drive? How do I move the SQL Anywhere temporary file for Foxhound to a different physical drive? How do I protect the security of my target database? How do I read the Foxhound exception messages? How do I reduce the amount of space used by the Foxhound database file? How do I reduce the amount of space used by the Foxhound transaction log? How do I reinstall an earlier build of Foxhound? How do I reinstall Foxhound? How do I remove Foxhound from my system? How do I rename a connection string on the String tab of the Foxhound Menu page? How do I renew the Rental Edition of Foxhound 4? How do I report unexpected errors and exceptions? How do I restore the Foxhound database from a backup? How do I restore the old build of Foxhound after installing a new build? How do I run Foxhound as a service? How do I run the Foxhound "unsetup" process? How do I "Save As" an existing connection string to a new string with a different name on the String tab of the Foxhound Menu page? How do I see Foxhound diagnostics, errors and exceptions? How do I set the environment variables used by Foxhound? How do I set up Foxhound to monitor a large number of target databases? How do I shrink the size of the Foxhound database? How do I specify the HTTPS transport-layer security for Foxhound? How do I start Foxhound? How do I start Foxhound in "debug mode"? How do I start Foxhound in "safe mode"? How do I start Foxhound with the 32-bit version of SQL Anywhere when both the 32-bit and 64-bit versions of SQL Anywhere are installed? How do I stop and restart Foxhound? How do I stop Foxhound? How do I stop the "User Id:" and "Password:" from being redisplayed on the Foxhound Menu page? How do I tell Foxhound to send Alert emails via the Gmail SMTP server smtp.gmail.com? How do I tell Foxhound to use an HTTP port other than 80? How do I tell if Foxhound has been started in safe mode? How do I tell if Foxhound is running on the 32-bit or 64-bit version of SQL Anywhere? How do I turn "safe mode" on and off? How do I uninstall Foxhound? How do I "unsetup" Foxhound? How do I upgrade Foxhound from one edition to another? How do I upgrade from the Basic Edition of Foxhound 4 to the Extended Edition? How do I upgrade from the Rental Edition of Foxhound 4 to the Basic Edition? How do I upgrade from the Rental Edition of Foxhound 4 to the Extended Edition? How do I upgrade to a new version of Foxhound without losing any of my data? How do I upgrade to Foxhound 4? How do the different FOXHOUND4UPGRADE values work? How do the Foxhound backup shortcuts work? How many target databases can one copy of Foxhound monitor? How much disk space does Foxhound need? How much overhead does the Foxhound connection add to the target database?
Why? Why are my Alert emails garbled? Why are the "User Id:" and "Password:" values redisplayed after I blank them out on the Foxhound Menu page? Why are there so many "Connection timeout" messages in Foxhound - Options - Display Diagnostics? Why aren't more "Uninteresting Connections" being deleted by the Foxhound purge process? Why can't I see my ODBC DSNs any more on the DSN tab of the Foxhound Menu page? Why did Foxhound start automatically after I stopped it? Why didn't the Alert Email Schedule go into effect when it was supposed to? Why didn't the AutoDrop Schedule go into effect when it was supposed to? Why didn't the Connection Sample Schedule go into effect when it was supposed to? Why didn't the Sample Schedule go into effect when it was supposed to? Why do I see so many Alert #1 - Database unresponsive messages? Why do I see so many "Timed out" messages on the Monitor display? Why do the Monitor and History pages show samples in different orders? Why does "Duplicate Foxhound sampling sessions" appear after a High Availability failover? Why does Foxhound issue Alert #1 - Database unresponsive immediately after Foxhound is started? Why does Foxhound "lock up" and become unresponsive? Why does Foxhound take so long to start up? Why does it still say "Status: ...stopping" after the Stop Sampling button was clicked? Why does it take so long for Foxhound to start a large number of Monitor sampling sessions? Why does my target database engine start up again right after I shut it down? Why does the Delete All Sessions button display "- skipped, currently starting or running" after I click on Stop All Sessions? Why does the Facts & Figures display "O/S: Windows Vista Build 7601 Service Pack 1" for a SQL Anywhere 9 database running on Windows 7? Why does the Foxhound ping process fail when everything else looks OK? Why does the Foxhound post-upgrade process take so long? Why doesn't an upgrade with FOXHOUND4UPGRADE = yyyymmdd or nnn remove old Alerts? Why doesn't sampling stop when I close the Foxhound Monitor display page? Why doesn't the display scroll by exactly the number of lines I requested on the History Page? Why doesn't the Foxhound backup process create the generation2 subfolder? Why doesn't the Foxhound unsetup process completely remove the Foxhound4 installation folder? Why doesn't the Locks Held number in the Most Recent or Top Sample section agree with the total of the values shown in the Connections section? Why doesn't the purge process delete very old samples? Why doesn't the purge process remove old Alerts? Why doesn't the "Send Test Email" button respond? Why doesn't the Unsetup Foxhound process delete all the shortcuts in All programs - Foxhound4? Why don't I get emails for the Alerts that appear on the Monitor page? Why don't the Alerts disappear from the Monitor tab on the Foxhound Menu page when the All Clear lines appear on the Monitor page? Why don't the connection strings show up on the String tab of the Foxhound Menu page after they were created on the Monitor Options page? Why don't the schedules work? Why is Alert #1 - Database unresponsive issued and cleared with every sample gathered? Why is Alert #14 - Unscheduled requests issued before the threshold is reached? Why is Foxhound taking so long to gather samples? Why is Foxhound unresponsive when it starts? Why is it called "unsetup" instead of "uninstall"? Why is scrolling stuck in the History display? Why is the "bytes per row" larger than the actual amount of data in each row? Why is the "Choose a DSN:" drop down list empty? Why is the CPU time % so large for an inactive database? Why is the Force Default Settings On All Targets button disabled on the Monitor Options page? Why is the ODBC Administrator button disabled on the DSN tab of the Foxhound Menu page? Why is the Restore Default Settings button disabled on the Monitor Options page? Why is the Save Settings As Default button disabled on the Monitor Options page? Why is the Stop Foxhound Engine button disabled on the Foxhound Options page? Why is the temporary DBSPACE file size shown in the Facts & Figures section larger than the Temp Space amount shown on the Monitor page? Why isn't an Alert #1 - Database unresponsive issued when Foxhound can't connect to the target database? Why isn't the new value of the FOXHOUND4 environment variable available immediately after Foxhound is installed? Why isn't the purge process deleting anything? Why won't sampling start? Why won't the target database auto-start when Foxhound tries to connect to it?
Messages -307: All threads are blocked -81: DBSPAWN ERROR: -81 0: dbspawn/dbsrv16 set ERRORLEVEL = 0 011c-irpl1(011c-irpl1) Info: Unique index collision avoided: ping_id = ... ping_log_inserted_at = ... sampling_id = ... 1: Client address backtrace: ::1 1: dbspawn/dbsrv16 set ERRORLEVEL = 1 1: Error - File output check failed with return code 1 1: ERRORLEVEL from dbstop: Unable to stop database server -- Request to start/stop database denied. 121;42501;Permission denied: you do not have permission to execute the procedure "sa_server_option" 1730: You must be an Administrator to remove this application. - Error 1730. 2.7.0 Accepted 206b2a(206eh4) SQLCODE = -196, SQLSTATE = "23505", ERRORMSG() = "Index 'ix_ping_inserted' for table 'rroad_ping_log' would not be unique" 2203: Internal Error 2203: C:\Windows\Installer\597604a.ipi,-2147287035 23: I/O error Fatal error: A disk read from file "...\foxhound4.db" failed with error code: (23) -- transaction rolled back -- 235/2.7.0 Accepted 255: dbspawn/dbsrv16 set ERRORLEVEL = 255 3: dbspawn/dbsrv16 set ERRORLEVEL = 3 404: Not Found 408: Request Time-Out 40W06: All threads are blocked 503: Service Temporarily Unavailable 57014: Handler for event 'rroad_monitor_sample_loop' caused SQLSTATE '57014' 660 Incorrect syntax near the keyword 'TRANSACTION' 9: ERRORLEVEL from dbstop: Unable to stop database server -- Database server not found. 990xx: Internal error A disk read from file "...\foxhound4.db" failed with error code: (23) -- transaction rolled back -- A subdirectory or file backup already exists. Access is denied. ALERT ... Alert #11 - HA failover - ... on ... ALL CLEAR ... All threads are blocked An attempt to start sample loop event ... for sampling id ... failed because event ... was already running for that sampling id. Another version of this product is already installed. Authentication failed bad call to rroad_update_rroad_global_options: column = "...", value = "..." CANCELLED ... Cannot access file '...' -- The filename, directory name, or volume label syntax is incorrect. Cannot access file '...' -- The system cannot find the file specified Cannot access ... foxhound4.db ... another process may be using the file Cannot convert '...' to a timestamp Cannot CREATE PROCEDURE rroad_... Cannot open transaction log file -- Can't use log file "foxhound.log" Can't open Message window log file: foxhound4_debug.txt Can't start HTTP listener on address 0.0.0.0:80 Can't start HTTP listener on address 127.0.0.1:80 Can't start HTTP listener on address (::):80 Choose a connection string. Choose an ODBC DSN. Client address backtrace: ::1 Connection "..." by user id "..." rejected during post-setup data upgrade process. Connection ... dropped by Foxhound because it failed to connect to target DSN ... after ... (timeout threshold is ...; see Foxhound Options) Connection error: No IP address found for ... Could not bind to address 0.0.0.0:80 Could not execute statement. Item 'rroad_..._properties' already exists Could not load dynamic library ... CREATE PROCEDURE rroad_..._properties failed ... Item 'rroad_..._properties' already exists CREATE PROCEDURE rroad_..._properties failed ... Modifications not permitted for read-only database Data cannot be copied from an old Foxhound database that has never been activated. Data cannot be copied from the beta build ... to the non-beta build ... Data cannot be upgraded from ... to ... Data source name not found and no default driver specified Database server connection limit exceeded Database server not found Database server shutdown due to startup error DBSPAWN ERROR: -81 dbspawn/dbsrv16 set ERRORLEVEL = 0 dbspawn/dbsrv16 set ERRORLEVEL = 1 dbspawn/dbsrv16 set ERRORLEVEL = 255 dbspawn/dbsrv16 set ERRORLEVEL = 3 DIAG ... Data cannot be copied from an old Foxhound database that has never been activated. Do not attempt to UPDATE rroad_connection_string.connection_string_name EMAIL FAILURE - SMTP send ... email failed with return code ... when sending "..." EMAIL FAILURE - SMTP start ... email failed with return code ... when sending "..." Error - File output check failed with return code 1 Error 1730. You must be an Administrator to remove this application. Error: Cannot access file '...' -- The system cannot find the file specified Error code/text 235/2.7.0 Accepted ERROR ... DIAG ... Data cannot be copied from an old Foxhound database that has never been activated. Error in syntactical analysis: Invalid or missing keyword near 'CPOOL‘. ERROR SQLANY16 or SQLANY17 environment variable not set properly. Error: SQLCODE = ..., SQLSTATE = ..., ERRORMSG() = ... ERROR The $post_setup.bat file could not MOVE the new foxhound4.db file to the FOXHOUND4 folder ERRORLEVEL = 0 from dbspawn/dbsrv16 ERRORLEVEL = 1 from dbspawn/dbsrv16 ERRORLEVEL = 1 from dbstop: Unable to stop database server -- Request to start/stop database denied. ERRORLEVEL = 255 from dbspawn/dbsrv16 ERRORLEVEL = 3 from dbspawn/dbsrv16 ERRORLEVEL = 9 from dbstop: Unable to stop database server -- Database server not found. EXCEPTION in EVENT rroad_... at ...: SQLCODE = ..., SQLSTATE = ..., ERRORMSG() = ... EXCEPTION in patch process EXECUTE IMMEDIATE: patch file name = ... EXCEPTION in patch process INSERT: patch file name = ... EXCEPTION in PROCEDURE rroad_... at ...: SQLCODE = ..., SQLSTATE = ..., ERRORMSG() = ... File access denied. file is unavailable File output check failed with return code 1 Fill in the "Connection Strings file:" field and press Save before clicking on ... Foxhound:-121;42501;Permission denied: you do not have permission to execute the procedure "sa_server_option" Foxhound can only be started with the SQL Anywhere database name set to "f". Foxhound Extended edition is required for ... Foxhound itself cannot be run using the OEM or AUTHENTICATED editions of SQL Anywhere. Foxhound needs JavaScript to be enabled. Foxhound now accepting requests Foxhound stopped Foxhound supports 100 sessions Foxhound was not available yet, probably because the Foxhound engine had not finished starting up. HA failover - Alert #11 Handler for event 'rroad_monitor_sample_loop' caused SQLSTATE '57014' Handler for event 'rroad_scheduled_purge' caused SQLSTATE '57014' However, version ... is actually being used. HTTPValidityCheck failed on the Monitor Options page; input values ignored I/O error Fatal error: A disk read from file "...\foxhound4.db" failed with error code: (23) -- transaction rolled back -- Incorrect syntax near the keyword 'TRANSACTION' Index 'ix_ping_inserted' for table 'rroad_ping_log' would not be unique Info: HTTPValidityCheck failed on the Monitor Options page; input values ignored. Info: Procedure rroad_... has been upgraded from build number ... to ... on ... Info: Unique index collision avoided: ping_id = ... ping_log_inserted_at = ... sampling_id = ... input values ignored Internal Error 2203: C:\Windows\Installer\597604a.ipi,-2147287035 Internal error 999xx Internal error; bad call to rroad_update_rroad_global_options: column = "...", value = "..." Internal error: Do not attempt to UPDATE rroad_connection_string.connection_string_name Internal error: No code exists to validate connection-level property ... Internal error: Retry loop failed to find a Top Sample or Most Recent Sample to display. Invalid database engine command line Invalid database server command line Invalid or missing keyword near 'CPOOL‘ Invalid server and/or database name: The database engine is stopping. Invalid user ID or password Item 'rroad_..._properties' already exists Item 'rroad_..._properties' already exists Modifications not permitted for read-only database No code exists to validate connection-level property "..." No detailed information about blocked connections is recorded for the sample taken at ... No detailed information about the ... connection(s) is recorded for the sample taken at ... No information about ... connections has been gathered yet. No information about ... connections is available for the sample lost at ... No IP address found for ... No unused patch files were detected. Not Found - 404 Older samples purged at ... Only the Extended edition of Foxhound can be started with a SQL Anywhere server name other than "foxhound4". Page not found Parse error: Invalid or missing keyword near 'CPOOL‘ Patch error: patch file name = ... patch file contains a hash error: ... patch file contains data of the wrong length: ... patch file is being applied to the Foxhound database: ... patch file is empty: ... patch file was executed: ... Permission denied: Cannot CREATE PROCEDURE rroad_... Permission denied: you do not have permission to execute a statement of this type Permission denied: you do not have permission to execute the procedure "sa_server_option" Pick a valid ODBC DSN, and specify the user id and password on the Foxhound DSN tab or inside the DSN itself Please fill in both User Id and Password, or leave both empty. Please install version ... or later. See www.sap.com. Preparing monitor sample sessions... Procedure rroad_... has been upgraded from build number ... to ... on ... Procedure rroad_... not used; build number ... is more recent than Foxhound build number ... proxy_rroad_..._properties returned a result set with a different schema than expected Purge run ... which started at ... has been cancelled because it was running too long. Request Time-Out (408) Retry loop failed to find a Top Sample or Most Recent Sample to display. Sample Schedule in effect Sampling stopped Service Temporarily Unavailable - 503 Setup error: DIAG yyyy-mm-dd hh:nn:ss.sss ... SMTP send ... email failed with return code ... when sending "..." SMTP send test Alert email failed with return code -1 when sending "Foxhound Test Alert Email ...". Error code/text 235/2.7.0 Accepted SMTP start ... email failed with return code ... when sending "..." Specified database file already in use Specified database not found SQL Anywhere database server ... not supported SQL Anywhere database version ... not supported SQL Anywhere version ... not supported. SQL Anywhere version ... or later is required to run this application. SQL error: Could not load dynamic library ... SQL error: User-defined exception signaled SQLANY16 or SQLANY17 environment variable not set properly. SQLCODE = -196, SQLSTATE = "23505", ERRORMSG() = "Index 'ix_ping_inserted' for table 'rroad_ping_log' would not be unique" SQLCODE = -307, SQLSTATE = 40W06, ERRORMSG() = All threads are blocked SQLCODE = -660, SQLSTATE = WO005, ERRORMSG() = Server 'p001': [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near the keyword 'TRANSACTION' Statement interrupted by user Statement interrupted by user - Handler for event 'rroad_scheduled_purge' caused SQLSTATE '57014' Status: proxy_rroad_connection_properties returned a result set with a different schema than expected Stop Foxhound Engine requested at ... Syntax error: syntax error near ... Target SQL Anywhere server version ... not supported TCP/IP link, function bind, error code 10048 The $backup_foxhound4.bat file looked for a path specification in the FOXHOUND4 environment variable and it was empty. The $backup_foxhound4_log.bat file did not find an existing full backup of the database and log files in the folder ... The $post_setup.bat file could not MOVE the new foxhound4.db file to the FOXHOUND4 folder The activation upgrade was not successful: The registration key has been used before. The beta testing period for this copy of Foxhound has expired. The connection was refused when attempting to contact localhost The data upgrade process has begun: to build ... from ... The data upgrade process has failed: to build ... from ...; diagnostics = "..." The data upgrade process has succeeded: to build ... from ... The filename, directory name, or volume label syntax is incorrect. The Foxhound database must run on its own SQL Anywhere engine. The Foxhound engine has been shut down. The Foxhound Standard Edition supports 10 sessions The initial activation was not successful: The registration key did not work. The page cannot be displayed The patch file contains a hash error: ... The patch file contains data of the wrong length: ... The patch file is being applied to the Foxhound database: ... The patch file is empty: ... The patch file was executed: ... The process cannot access the file because it is being used by another process. The specified DSN contains an architecture mismatch between the Driver and Application The system cannot find the file specified. The system cannot find the path specified. The system could not find the environment option that was entered. The table ... has more than one index on columns ( ... ) The table ... has no primary key or unique constraint, but does have a unique index. The table ... has no primary key, unique constraint or unique index. The table or view ... was not found, probably because it has been recently dropped. There are no user tables to display. This monitor session has been stopped and the samples have been deleted. This view has no column definitions in SYSCOLUMN; it may contain a syntax error. To help protect your security, Internet Explorer has restricted this file from showing active content that could access your computer. Too many sampling sessions in progress. Stop one and try again. transaction rolled back: I/O error Fatal error: A disk read from file "...\foxhound4.db" failed with error code: (23) Unable to load either rroad4.dll or rroad464.dll... Unable to read rroad4.dll. Unable to read rroad464.dll. Unable to stop database server -- Database server not found. Unable to stop database server -- Request to start/stop database denied. Unexpected exception from SET TEMPORARY OPTION DEDICATED_TASK = ... ignored: ... Unexpected operation: "..." Unique index collision avoided: ping_id = ... ping_log_inserted_at = ... sampling_id = ... User "DBA" dropped event connection ... ("rroad_monitor_sample_loop") User "DBA" dropped event connection ... ("rroad_scheduled_purge") User-defined exception signaled Value '...' out of range for destination you do not have permission to execute a statement of this type You must be an Administrator to remove this application. - Error 1730.