2017 05 08  patch-4729-004-billion-row-tables

This patch is for installed copies of Foxhound 4 build 4729. 

If you experience any problems or challenges with this patch, or 
with your copy of Foxhound 4 in general, please contact breck.carter@gmail.com. 
Many issues can be resolved quickly.

-----------------------------------------------------------------------

    ********************************************
    *****     DESCRIPTION OF THE FIXES     *****
    ********************************************

This patch updates several stored procedures in the Display Schema 
part of Foxhound 4 to solve this exception when a table has more 
than 999,999,999 rows in the target database:

   SQLCODE = -158
   SQLSTATE = 22003
   ERRORMSG() = Value nnn out of range for destination.

This patch can be applied independently from previous patches.

-----------------------------------------------------------------------

   ******************************* 
   *****     INSTRUCTIONS    *****
   ******************************* 

1. Shut down Foxhound 4, if it's running. 

2. If desired, make a backup copy the Foxhound 4 folder:
      C:\ProgramData\RisingRoad\Foxhound4

3. Unzip this file:   zipped-patch-4729-004-billion-row-tables.zip
   into this folder:  C:\ProgramData\RisingRoad\Foxhound4

   It will create this file: patch-4729-004-billion-row-tables.bin

4. Start Foxhound 4; it will automatically apply the patch.

5. Wait a few seconds for Foxhound 4 to shut down automatically;
   you won't see it in the browser, but you will see the Windows process disappear.

6. Start Foxhound 4 again, to continue work.

7. Optional: Use notepad to verify that the patch was applied OK.

   Scroll to the bottom of this file:

      C:\ProgramData\RisingRoad\Foxhound3\foxhound4_debug.txt 

=====
I. 05/03 09:17:49. ---------------------------------------
I. 05/03 09:17:49. Foxhound Version 4.0 by RisingRoad - Extended Edition 4.0.4729a built at 
                      2016 10 04 07:08 in a SQL Anywhere 16.0.0.2127 database created at 2016 10 04 07:07
I. 05/03 09:17:49. ---------------------------------------
I. 05/03 09:17:50. The patch file is being applied to the Foxhound database: "patch-4729-004-billion-row-tables.bin"
I. 05/03 09:17:50. DIAG 2017-05-03 09:17:50.275 Starting patch-4729-003-DLLs-Properties.txt
I. 05/03 09:17:50. DIAG 2017-05-03 09:17:50.276    DROP EVENT fire_once
I. 05/03 09:17:50. DIAG 2017-05-03 09:17:50.277    CREATE EVENT fire_once
I. 05/03 09:17:50. DIAG 2017-05-03 09:17:50.318    @sql = ALTER EVENT fire_once ADD SCHEDULE START TIME '2017-05-03 09:18:00.318'
I. 05/03 09:17:50. DIAG 2017-05-03 09:17:50.321    ALTER EVENT fire_once ENABLE
I. 05/03 09:17:50. The patch file was executed: "patch-4729-004-billion-row-tables.bin"
I. 05/03 09:18:00. DIAG 2017-05-03 09:18:00.322    STOP ENGINE UNCONDITIONALLY
I. 05/03 09:18:01. Database server shutdown requested by STOP ENGINE statement
W. 05/03 09:18:03. TCPIP listener on IP address (::):49156 is exiting
W. 05/03 09:18:03. TCPIP listener on IP address 0.0.0.0:49156 is exiting
W. 05/03 09:18:03. HTTP listener on IP address (::):80 is exiting
W. 05/03 09:18:03. HTTP listener on IP address 0.0.0.0:80 is exiting
I. 05/03 09:18:03. Starting checkpoint of "f" (foxhound4.db) at Wed May 03 2017 09:18
I. 05/03 09:18:03. Finished checkpoint of "f" (foxhound4.db) at Wed May 03 2017 09:18
I. 05/03 09:18:04. Database server stopped at Wed May 03 2017 09:18
=====

8. Optional: Verify the patch via All Programs - Foxhound4 - Tools - Adhoc Query Foxhound Database via ISQL

SELECT * FROM applied_patch;

file_name,applied_to_build_number,inserted_at,updated_at,status
'patch-4729-004-billion-row-tables.bin',4729,'2017-05-03 09:17:50.220','2017-05-03 09:17:50.325',The patch file was executed: "patch-4729-004-billion-row-tables.bin"

-- end --