TPS-3096 - 6.4

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend Data Fabric
EnrichPlatform
Talend Administration Center

TPS-3096

Info Value
Patch Name Patch_20190505_TPS-3096_v1-6.4.1
Release Date 2019-05-05
Target Version 20170623_1246-V6.4.1
Product affected Talend Administrator Center

Introduction

This patch is cumulative. It includes all previous generally available patches for Talend Administrator Center 6.4.1.

NOTE: To download this patch, liaise with your Support contact at Talend.

Fixed issues

This patch is cumulative and contains the following fixes:

  • TPS-2138 [6.4.1] Task randomly fails with connection to server failed (TMC-10623)
  • TPS-2140 [6.4.1] Branch/Tag Target field doesnt allow DOTs (TMC-11167)
  • TPS-2157 [6.4.1] Failed to add new license with Chinese or Japanese language (TMC-10665)
  • TPS-2221 [6.4.1] Cannot activate more than 25 users when with 3 licenses (TMC-11427, Including fix for TMC-10571, TMC-11270, and TMC-11154)
  • TPS-2213 [6.4.1] ESB deployment failing - Nexus using anonymous user (TESB-20526)
  • TPS-2211 [6.4.1] "Use LDAP login/password" not working (TMC-11426)
  • TPS-2253 [6.4.1] TAC can't automatically recover Task's status from "Running..." causing major issues (TMC-11766)
  • TPS-2259 [6.4.1] Job is misFired-Notifications sent after the event occurs (TMC-11779)
  • TPS-2178 [6.4.1] TAC goes down frequently (TMC-11246)
  • TPS-2245 [6.4.1] Issues after TAC migration (TMC-11125, TMC-11771, TMC-11933, TDP-4608, TPSVC-3524)
  • TPS-2293 [6.4.1] Problem with TAC ESB-Conductor feature picker (TMC-9598)
  • TPS-2383 [6.4.1] "Job version" shows previous version even after choosing the job of new version (TMC-10942)
  • TPS-2407 [6.4.1] migration blocked with custom context in TAC (TMC-12508)
  • TPS-2371 [6.4.1] In TAC Context parameters does not reflect latest context variable values when "Use Latest Version" is selected for the artifact in Job conductor (TMC-11378, TMC-12268)
  • TPS-2418 [6.4.1] Task failed to run - and has a negative duration - but its status stays Running (TMC-11768,TMC-10747)
  • TPS-2325 [6.4.1] TAC password input type can be changed to "text" and the password field in the UI can be made visible which is a security breach (TMC-12170,TMC-12897,TMC-12001)
  • TPS-2484 [6.4.1] Artifact Tasks revert to Master branch when executing task (TMC-11047)
  • TPS-2486 [6.4.1] Tag/Branch with Git does not maintain reference links (TMC-10557)
  • TPS-2494 [6.4.1] Can't login on projects with branches due to duplicated records in projectreference table (Oracle 12c) (TMC-13007)
  • TPS-2512 [6.4.1] Nexus 2 issue from new fix about CI publish (TMC-12700)
  • TPS-2496 [6.4.1] [MetaServlet] updateTask cannot update version for an artifact task (TMC-12837)
  • TPS-2489 [6.4.1] Security issue with cross site scripting (TMC-12532)
  • TPS-2522 [6.4.1] Task stayed on "Requesting to run" for long time before running - JobServer Invalid Socket issue (TPSVC-2911)
  • TPS-2541 [6.4.1] Support git branch name with special characters (TMC-9975)
  • TPS-2548 [6.4.1] database schema migration from 6.2.1 to 6.4.1 failed (TMC-13140)
  • TPS-2453 [6.4.1] TAC Real Time Statistics disappear (TMC-10624, TMC-11073)
  • TPS-2554 [6.4.1] Unexpected limit for number of DI deactivated users - unable to create active users (TMC-13230)
  • TPS-2569 [6.4.1] An execution plan in TAC stuck in running state (TMC-10931)
  • TPS-2592 [6.4.1] Add two parameters in exection plan then the transaction hangs on the database server (TMC-13608)
  • TPS-2599 [6.4.1] Unable to create a trigger for execution plan using 'CreateTrigger' option in Metaservlet (TMC-13242)
  • TPS-2623 [6.4.1] Studio send Warning/Error when starting. complaining about [LibLocation] action. (TMC-12630)
  • TPS-2522 [6.4.1] Task stayed on "Requesting to run" for long time before running - JobServer Invalid Socket issue (TPSVC-2911)
  • TPS-2760 [6.4.1] Issue adding a Task to Execution plan with large number of Tasks (TAC-11898)
  • TPS-2737 [6.4.1] Spark job doesn't appear in job conductor's repository (TAC-3978)
  • TPS-2826 [6.4.1] jvmParams in updateTask, createTask, etc... (TAC-11805)
  • TPS-2806 [6.4.1] Task not restarted on second jobserver (TAC-11964)
  • TPS-2858 [6.4.1] Metaservlet "associatePreGeneratedJob" issue if target TAC project type is None Storage (TAC-3249)
  • TPS-2840 [6.4.1] TAC Real Time Statistics disappear(TAC-3890)
  • TPS-2513 [6.4.1] studio looks for svn credential from Tac LDAP setting (TMC-13088)
  • TPS-2929 [6.4.1] Create Metaservlet to fix User-group bidirectional relation and project authorization datas (TAC-10341)
  • TPS-2951 [6.4.1] The "executiontaskjobprm" table keeps growing (TAC-12080)
  • TPS-2985 [6.4.1] TAC Performance issue due to license checking (TAC-12387)
  • TPS-3048 [6.4.1] Execution plan stuck at "waiting for the task to end" (TAC-11849, TAC-12413)
  • TPS-3096 [6.4.1] cannot add new user even though there's license seat available (TAC-12514)

Prerequisites

Consider the following requirements for your system:

  • Talend Administrator Center 6.4.1 must be installed.

Installation

  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. Login to local Nexus, and download the patch file.
  4. Stop the TAC.
  5. Create a patch directory (eg: <Talend>/TAC_Patch).
  6. Unzip patch file you received from support into this directory, then unzip the org.talend.administrator.war file as org.talend.administrator folder. (Note: Please rename org.talend.administrator-6.3.1.war if your old tac application folder has a different name. Set the name as same as your old TAC application name).
  7. Create a backup directory (eg: <Talend>/TAC_Backup).
  8. Copy folder <TOMCAT>/webapps/org.talend.administrator into the backup directory.
  9. In <TOMCAT>/webapps/ directory, remove the previous org.talend.administrator folder, then copy the org.talend.administrator folder from step3 and paste in the current directory.
  10. Restore TAC configuration by replacing <TOMCAT>/webapps/org.talend.administrator/WEB-INF/classes/configuration.properties and quartz.properties with ones from your backup directory.

    Note:

    • If your TAC db is H2 db and embedded in TAC web folder (<TOMCAT>/webapps/org.talend.administrator/WEB-INF/database by default), don't forget to restore H2 db by replacing this folder with the exact corresponding folder from your backup directory.
    • If your TAC works with SSO, you should restore the IDP Metadata file (<TOMCAT>/webapps/org.talend.administrator/WEB-INF/classes/IDPMetadata.xml) from your backup directory.
  11. Restart the TAC.

    Note:

    • It's recommended to clear browser cache after TAC patch were applied.
    • For TPS-2494, you need to remove the records with empty branch in projectreference table manually. For example(mysql script): DELETE FROM projectreference WHERE branch IS NULL;
    • For TPS-2951, please clean the executiontaskjobprm table manually at same time. For example(mysql script): DELETE FROM executiontaskjobprm WHERE executiontaskjobprm_executiontask_e_id IS NULL;
    • Patch TPS-2245 contains changes for the "User", "UserGroup", and "ExecutionTask" tables, you will have to do migration on dbconfig page, or use SQL statement instead:

    • Create "uniqueid" column for "User", "UserGroup", and "ExecutionTask" table, for example in MySQL, execute following SQL

      • ALTER TABLE user ADD uniqueid varchar(255);
      • ALTER TABLE usergroup ADD uniqueid varchar(255);
      • ALTER TABLE executiontask ADD uniqueid varchar(255);
    • Fill "uniqueId" column with id, for example in MySQL, execute following SQL

      • UPDATE user set uniqueid=id;
      • UPDATE usergroup set uniqueid=id;
      • UPDATE executiontask set uniqueid=id;