TPS-3807 - 7.1

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Integration
EnrichPlatform
Talend Studio

TPS-3807

Info Value
Patch Name Patch_20200316_TPS-3807_v1-7.1.1
Release Date 2020-03-16
Target Version 20181026_1147-V7.1.1
Product affected Talend Studio

Introduction

This a cumulative patch of Snowflake component for 7.1.1.

NOTE: For information on how to obtain this patch, reach out to your Support contact at Talend.

Fixed issues

This patch for 7.1.1 contains the following fixes:

  • TDI-41277 tSnowflakeInput--> table column with space name doesn't work
  • TDI-41766 Snowflake table creation error due to wrong precision and length handling at New Balance POC
  • TDI-41238 tSnowflakeXX --> Advanced settings --> Tracing doesn't work on 7.1.1
  • TDI-42854 tSnowflakeOutput Dynamic column does not work when additional static columns are added
  • TPS-3527 [7.1.1]Snowflake gives incorrect output in sydney/melbourne (DST) from date at DST start/end(TDI-43038)
  • TPS-3588 [7.1.1]Snowflake Output component - Using Dynamic column - Datetime columns is created only with Date (missing Time)(TDI-42938)
  • TPS-3783 [7.1.1] dynamic schema issue in tsnowflakeoutput Component (TDI-43629)
  • TPS-3807 [7.1.1] Problem with retrieving Snowflake tables from Studio (TDI-43612)
  • TDI-41407 Can't create temp table if action on table used in tSnowflakeoutputBulkExec + dyn schema
  • TDI-41534 tSnowflake Case Sensitive doesn't work on 7.2.1

Prerequisites

Consider the following requirements for your system:

  • Talend Studio 7.1.1 must be installed.

Installation

NOTE: If the patch is deployed in the approach Installing the patch using Talend Studio, the folders configuration and plugins under this patch must be replaced manually.

Installing the patch using Software update

1) Logon TAC and switch to Configuration->Software Update, then enter the correct values and save referring to the documentation: https://help.talend.com/reader/f7Em9WV_cPm2RRywucSN0Q/j9x5iXV~vyxMlUafnDejaQ

2) Switch to Software update page, where the new patch will be listed. The patch can be downloaded from here into the nexus repository.

3) On Studio Side: Logon Studio with remote mode, on the logon page the Update button is displayed: click this button to install the patch.

Installing the patch using Talend Studio

1) Create a folder named "patches" under your studio installer directory and copy the patch .zip file to this folder.

2) Restart your studio: a window pops up, then click OK to install the patch, or restart the commandline and the patch will be installed automatically.

Installing the patch using Commandline

Execute the following commands:

  1. Talend-Studio-win-x86_64.exe -nosplash -application org.talend.commandline.CommandLine -consoleLog -data commandline-workspace startServer -p 8002 --talendDebug
  2. initRemote {tac_url} -ul {TAC login username} -up {TAC login password}
  3. checkAndUpdate -tu {TAC login username} -tup {TAC login password}

Uninstallation

In case this patch cannot be uninstalled, it is your responsibility to define the backup procedures for your organization before installing.

Affected files for this patch

The following files are installed by this patch: - {Talend_Studio_path}/configuration/.m2/repository/org/talend/components/components-common/0.25.3/components-common-0.25.3.jar - {Talend_Studio_path}/configuration/.m2/repository/org/talend/components/components-snowflake-definition/0.25.3/components-snowflake-definition-0.25.3.jar - {Talend_Studio_path}/configuration/.m2/repository/org/talend/components/components-snowflake-ee-runtime/0.25.3/components-snowflake-ee-runtime-0.25.3.jar - {Talend_Studio_path}/configuration/.m2/repository/org/talend/components/components-snowflake-runtime/0.25.3/components-snowflake-runtime-0.25.3.jar - {Talend_Studio_path}/plugins/org.talend.components.snowflake.definition_0.25.3.jar