TPS-4161 (cumulative patch) - 6.5

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

TPS-4161 (cumulative patch)

Info Value
Patch Name Patch_20200731_TPS-4161_v1-6.5.1
Release Date 2020-07-31
Target Version 20180116_1512-V6.5.1
Product affected Talend Administrator Center

Introduction

This patch is cumulative. It includes all previous generally available patches for Talend Administrator Center 6.5.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-2306 [6.5.1] Unauthenticated database connector credentials leak in plaintext (TMC-12001)
  • TPS-2307 [6.5.1] Unauthenticated operations in jobserver (TPSVC-4026)
  • TPS-2337 [6.5.1] Provide a way to change visibility of the db config page. (TMC-11245)
  • TPS-2388 [6.5.1] Jobserver client doesn't support truststores. (TPSVC-4642)
  • TPS-2491 [6.5.1] When Deploying a Big Data Streaming Job into JobServer, Job jar Libaries are not Cached (TMC-12903)
  • TPS-2483 [6.5.1] Jobserver scheduled job fails with "job is null" after several iterations after jobcleaner run / Added additional logs. (TPSVC-5087)
  • TPS-2504 [6.5.1] TAC 'Execution Plan' screen refresh freakout (TMC-12971)
  • TPS-2608 [6.5.1] File Trigger of Execution Plan not working after applying Patch_20180625_TPS-2483_v2-6.5.1 (TPSVC-5554)
  • TPS-2602 [6.5.1] Use Latest Version not working with artifact job (TMC-12700&TMC-11378&TMC-12268)
  • TPS-2609 [6.5.1] "Job version" shows previous version even after choosing the job of new version(TMC-10942)
  • TPS-2640 [6.5.1] Unable to create a trigger for execution plan using 'CreateTrigger' option in Metaservlet (TMC-13242)
  • TPS-2648 [6.5.1] Cannot see some pages on Job Conductor after migration (TMC-13956)
  • TPS-2629 [6.5.1] Execution Plan page does not show pages via Filters(TMC-13807)
  • TPS-2656 [6.5.1] Cannot add a user depending on # of security administrator(TMC-11071)
  • TPS-2735 [6.5.1] Metaservlet doesn't supprot "Run Job as OS User" for execution tasks (TAC-4810)
  • TPS-2697 [6.5.1] TAC takes up too much CPU and even if it doesn't do anything(TMC-13735)
  • TPS-2742 [6.5.1] Metaservlet updateTask to Update execStatisticsEnabled Does Nothing(TAC-11855)
  • TPS-2766 [6.5.1] TAC 6.5.1 SSL via reverse proxy blank page (TAC-4131)
  • TPS-2842 [6.5.1] User/Group GridPanel blocking in Project Authorization page after patch TPS-2697
  • TPS-2831 [6.5.1] Unexpected limit for number of DI deactivated users - unable to create active users (TAC-4456)
  • TPS-2930 [6.5.1] Task hangs in jobconductor for long time -(TAC-12352, TAC-11849)
  • TPS-3021 [6.5.1] Execution plan stuck at "waiting for the task to end" (TAC-11849, TAC-12413)
  • TPS-3059 [6.5.1] Migration check doesn't work in Git project(TAC-12517)
  • TPS-2668 [6.5.1] TAC becomes non-responsive (TMC-13195)
  • TPS-3176 [6.5.1] The "executiontaskjobprm" table keeps growing (TAC-12080)
  • TPS-3167 [6.5.1] Studio cannot open Data Management project after activating Big Data License(TAC-12516)
  • TPS-3183 [6.5.1] Cannot create Git project from TAC - "Ref refs/remotes/origin/master can not be resolved" (TAC-12660)
  • TPS-3133 [6.5.1] Execution plan fails to complete (TAC-12673)
  • TPS-3190 [6.5.1] org.talend.exception.BusinessException: There is no artifact for task ... in Nexus Repository.(TAC-12794)
  • TPS-3482 [6.5.1] Better handling issues with disk storage(TAC-11987)
  • TPS-3658 [6.5.1] Many jobs in status requesting run (TAC-12653)
  • TPS-3723 [6.5.1] TAC Project Authorizations NullPointerException (TAC-13850, TAC-10341)
  • TPS-4199 [6.5.1] org.talend.administrator.common.exception.DBException: !!!Cannot flush and commit transaction.!!! (TAC-13204)
  • TPS-4161 [6.5.1] Tooo long time to complete the Job server status check (TAC-13761)

Prerequisites

Consider the following requirements for your system:

  • Talend Administrator Center 6.5.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.5.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 step6 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.
    • Add these properties to configuration.properties if missing:
    ###############################################################>
    CONFIGURATION PAGES EMERGENCY ENABLE
    ###############################################################
    configuration.admin.enable=true
    configuration.securityadmin.enable=true
    configuration.dbadmin.enable=true
    
  11. Restart the TAC.

    Note:

    • It's recommended to clear browser cache after TAC patch were applied.
    • After patch TAC please also update Jobserver to patch TPS-2483.
    • For TPS-3176, please clean the executiontaskjobprm table manually at same time. For example(mysql script): DELETE FROM executiontaskjobprm WHERE executiontaskjobprm_executiontask_e_id IS NULL;
    • For patch TPS-2608, you may have to do migration in dbconfig page, or use SQL statement for instead: update executiontask set uniqueid = concat('ep-',id) where dtype = 'ExecutionPlan';