TPS-3527 - 7.1

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

TPS-3527

Info Value
Patch Name Patch_20191122_TPS-3527_v3-7.1.1
Release Date 2019-11-22
Target Version 20181026_1147-V7.1.1
Product affected Talend Studio

Introduction

This is the second 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 is the second patch of 7.1.1 and contains the following fixes:

  • TPS-3367 [7.1.1] tSnowflakeOutput Dynamic column does not work when additional static columns are added (TDI-42854)
  • TPS-3527 [7.1.1] Snowflake gives incorrect output in sydney/melbourne (DST) from date at DST start/end (TDI-43038)
  • TDI-42178 [7.1.1] tSnowflakeInput --> Time type has timezone issue.
  • TDI-41766 [7.1.1] Snowflake table creation error due to wrong precision and length handling
  • TDI-41277 [7.1.1] tSnowflakeInput--> table column with space name doesn't work
  • TDI-41238 [7.1.1] tSnowflakeXX --> Advanced settings --> Tracing doesn't work on 7.1.1

Prerequisites

Consider the following requirements for your system:

  • Talend Studio 7.1.1 must be installed.
  • Patch TPS-3365 must be installed.

Installation

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 responsability to define the backup procedures for your organization before installing.

Affected files for this patch

The following files are installed by this patch:

  • configuration/.m2/repository/org/talend/components/components-common/0.25.5/components-common-0.25.5.jar
  • configuration/.m2/repository/org/talend/components/components-snowflake-definition/0.25.5/components-snowflake-definition-0.25.5.jar
  • configuration/.m2/repository/org/talend/components/components-snowflake-ee-runtime/0.25.5/components-snowflake-ee-runtime-0.25.5.jar
  • configuration/.m2/repository/org/talend/components/components-snowflake-runtime/0.25.5/components-snowflake-runtime-0.25.5.jar
  • plugins/org.talend.components.snowflake.definition_0.25.5.jar