1TeamConnect® Data Warehouse 4.0 Update 1
This release of Data Warehouse works with TeamConnect Enterprise 4.0 and all 4.0 updates.
For complete installation and configuration details, see the Data Warehouse Installation & Configuration Guide.
2System Requirements
Data Warehouse uses Pentaho tools (Pan, Kitchen, and Spoon). It has the following system requirements for installing and configuring:
•A source database. Data Warehouse uses the TeamConnect production database as its source database.
•A target database. Data Warehouse supports the same database brands and versions as TeamConnect. Refer to the TeamConnect Release Notes for details.
oIf the target database uses an Oracle database server, the Data Warehouse login must have the CREATE MATERIALIZED VIEW system privilege, in addition to the rights and privileges mentioned for Oracle in the TeamConnect release notes.
oIf the target database uses a SQL Server database server, its configuration must also be altered as follows:
✍ALTER DATABASE <dbname> SET ALLOW SNAPSHOT_ISOLATION ON
✍ALTER DATABASE <dbname> SET READ_COMMITTED_SNAPSHOT ON
•The ability to use 150 simultaneous database connections on the target database and 60 connections on the source database.
•Java Runtime Environment version 1.6.
Important: TeamConnect Data Warehouse supersedes DataMart. Remove DataMart, following instructions in the DataMart Administration Guide, before installing Data Warehouse.
3Upgrading
An upgrade path exists for upgrading from Data Warehouse version 4.0 to version 4.0 Update 1. For detailed steps for upgrading, see the Data Warehouse Installation & Configuration Guide.
As of this publication, an upgrade path for versions prior to 4.0 to 4.0 does not exist. Contact Mitratech Support for more information.
4Known Issues
Users must change the text in the <type> element of the <connection> element to “MSSQLNATIVE” for SQL servers in the share.xml file. More information can be found in the Data Warehouse Installation & Configuration Guide.
5Resolved Issues
This section describes the issues that are resolved in the Data Warehouse 4.0 Update 1 release. Each resolved issue is documented in the following format:
•A description of the issue
•Internal tracking code
•Salesforce case number, if applicable
•The patch the issue was originally fixed in, if applicable
Issue: WH_Install script threw error in Data Warehouse 3.4 SP1.
Tracking code: SUPPORTPRI-6752
Case number: 2014-0807-106912
Issue: DW did not recognize fields from different categories with the same name.
Tracking code: SUPPORTPRI-6816
Case number: 2014-0819-108163
Issue: All invoices did not load after installing updates.
Tracking code: SUPPORTPRI-6861
Case number: 2014-0828-109014
Issue: Script errors prevented large data loads.
Tracking code: SUPPORTPRI-7299
Case number: 2014-1015-113771
Issue: Error thrown when attempting to refresh after removing a user.
Tracking code: SUPPORTPRI-7424
Case number: 2014-1031-115433
Issue: Not all invoices were loaded following DW rebuilds.
Tracking code: SUPPORTPRI-7475
Case number: 2014-1103-115592
Issue: Wh_document.author_contact_pk column was not populated for the majority of rows.
Tracking code: SUPPORTPRI-7567
Case number: 2014-1111-116405
Issue: Automated refresh errors kept rows from being updated.
Tracking code: SUPPORTPRI-8017
Case number: 2014-1201-118121
Issue: Errors thrown when users attempted to refresh “TeamConnect_Warehouse.”
Tracking code: SUPPORTPRI-6647
Case number: 2014-0722-105237
Issue: Changes in custom field implementations between 3.2 and 3.3 resulted in incorrect variable return from queries.
Tracking code: SUPPORTPRI-7090
Case number: 2014-0925-111863
Originally fixed in: DW 3.4 SP1 Update 2 Patch 1
Issue: User access permissions to objects were not clearly displayed.
Tracking code: SUPPORTPRI-7111
Case number: 2014-0925-111929
Issue: Changes in custom field implementations between 3.2 and 3.3 resulted in incorrect variable return from queries.
Tracking code: SUPPORTPRI-8295, SUPPORTPRI-8303
Case number: 2014-1212-119718, 2014-1212-119719
Originally fixed in: DW 3.4 SP1 Update 2 Patch 2
Issue: Project phases table contained duplicate information.
Tracking code: SUPPORTPRI-6814
Case number: 2014-0819-108144
Issue: OOTB Data Warehouse did not correctly set the Main Assignee column of projects.
Tracking code: SUPPORTPRI-7745
Case number: 2014-1118-117003
Issue: Error ORA-24816 thrown after running install with custom fields of Memotext.
Tracking code: SUPPORTPRI-7793
Case number: 2014-1120-117304
Issue: DataWarehouse would not install on TeamConnect 4.0 U2 because of errors in the shared.xml file.
Tracking code: SUPPORTPRI-10987
Case number: 2014-1120-117304
