12.1.09: Service Pack 9
This topic contains information about fixes and enhancements in the FootPrints 12.1.09 release, and provides instructions for downloading and installing or upgrading to 12.1.09 version. For information about the issues that are corrected in this service pack, see Known-and-corrected-issues.
The following topics are provided:
Video overview
The following video (14:44) presentation provides an overview of enhancements in version 12.1.09.
Enhancements and changes
The following table lists items that are new or have changed in FootPrints version 12.1.09:
Impact on the Microsoft SQL Server during upgrade
If you use FootPrints with Microsoft SQL Server, the version 12.1.09 includes a fix that correctly displays the data in any language including special characters. The SQL server data types for a few system fields and all dynamically published fields are altered from single-byte ANSI to double-byte Unicode format. After the upgrade to FootPrints version 12.1.09, if you have large data volumes, the indexes are dropped and added again automatically. This process causes the upgrade to version 12.1.09 to take 40% more time than the earlier upgrades.
Also, the data type is changed from single-byte data to double-byte international data for many columns. To accommodate the international characters stored, the character fields that store user entered data doubles in size. The result is an increase in the database file size (.mdf) by 40-80%. The database transaction log file (.ldf) increases by 300% of the data file size assuming that the database is in Full Recovery Mode. Before you upgrade to version 12.1.09, ensure that you have adequate space on your database for the increased MDF and LDF file size.
Avoiding an increase in the database transaction log file size
Before upgrading, free up the required space by reducing the database transaction log file size after you create a backup.
- Stop the automatic schedule of normal log backup and full backup.
- Before the upgrade of FootPrints, perform the full database backup.
- Set the database to Simple Recovery Mode.
- Upgrade to FootPrints version 12.1.09.
- Set the database back to Full Recovery Mode.
- After the upgrade, to enable the transaction log files to recover the database again, perform a full database backup.
- Start the normal automatic schedule of the normal log backup and full backup.
Known and corrected issues
For the information about the issues that are corrected in these service pack, see Known-and-corrected-issues.
Downloading the service pack
For download instructions, see Downloading-the-installation-files.
Installing the service pack
For more information about installing the service pack, see Installing.
Upgrading to the service pack
For information about upgrading the service pack, see Upgrading.