This document details the upgrade information, new features, resolved issues, and known issues that are included in TeamConnect Data Warehouse 4.0.2 (4.0 Update 2).

1TeamConnect® Data Warehouse 4.0.2

This release of Data Warehouse works with TeamConnect Enterprise 4.0 and all 4.0 updates.

Note: Multi-value list fields are only available for Oracle users.

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.

•The latest SQL Server driver (earlier versions do not support datetime2)

•Ensure that the kettle.properties file has the WH_BATCH_SIZE=5000 field present. Data Warehouse will not function without this field present.

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 Data Warehouse to version 4.0.2. For detailed steps for upgrading, see the Data Warehouse Installation & Configuration Guide.

As of this publication, an upgrade scripts for versions prior to 4.0 to 4.0 does not exist. Contact Mitratech Support for more information, or refer to TeamConnect Data Warehouse Help online for upgrade instructions.

4Resolved Issues

This section describes the issues that are resolved in the Data Warehouse 4.0.2 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: Data Warehouse would not complete refresh after creating many invoices.

Tracking code: SUPPORTPRI-9790

 

Issue: Script deadlock prevented reporting queries from completing.

Tracking code: SUPPORTPRI-11378

Case number: 2015-0723-140570

 

Issue: Reports timed out during execution.

Tracking code: SUPPORTPRI-11806, SUPPORTPRI-13455

Case number: 2015-0403-129494