If you are using a version of TeamConnect prior to 4.0 , there are several tasks that you may have to perform before you run the 4.0  installer. Review the sections below to see which tasks apply to your situation.

 

Version Upgrade Path Notes

•For clients with version 3.3 SP3 Update 18: For clients seeking to ultimately upgrade to TeamConnect 4.0.5 or later (including 4.1 and 4.2), TeamConnect must be upgraded to either version 3.4 SP1 Update 17 or 3.4 SP1 Update 18 prior to further upgrades. Attempting to upgrade past version 4.0.5 from 3.3 SP3 Update 18 will result in an error. For more information, contact support@mitratech.com.

Licensing

If you are upgrading from a version earlier than 3.3 SP1, please see Licensing for more information.

Database Schema Changes

To support the new feature for localizing TeamConnect, some database columns that were datatype VARCHAR in earlier versions of TeamConnect are now datatype NVARCHAR2 (Oracle) or NVARCHAR (SQL Server).

The physical limit for a text column in Oracle is 4000 bytes, regardless of text datatype. NVARCHAR2 requires 2 bytes per character. This means that a column that could have up to 4000 characters as a VARCHAR now holds a maximum of 2000 characters as an NVARCHAR2. It is possible, though unlikely, that existing lengthy text data from previous versions could be truncated to 2000 characters in this version.

There is a database script to check for some occurrences of this potential issue. It can be found in your installation media in folder:

/validation/TC33SP1_Upgrade_Data_Validation

Run Oracle/Oracle_TC33SP1_upgrade_data_validation.sql (for Oracle databases)

or MSSQL/MSSQL_TC33SP1_upgrade_data_validation.sql (for SQL Server databases)

Run this script before performing your upgrade. It checks for excessive-length columns in the following situations:

•Invoice comments are now NVARCHAR2(2000). Since this column has an overhead of 53 bytes, the maximum practical length of invoice comments is 1947.

•Portal pane content previously had a maximum limit of 4000 characters. Now the maximum is 2000.

If your portal pane content exceeds 2000 characters, take some actions before upgrading. Instead of one long content field, create two or more content fields of 2000 characters or less. Concatenate the multiple fields within the block.