TPS-4473 (cumulative patch) - 7.1

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

TPS-4473 (cumulative patch)

Info Value
Patch Name Patch_20201030_TPS-4473_v2-7.1.1
Release Date 2020-10-30
Target Version 20181026_1147-V7.1.1
Product affected Talend Administrator Center

Introduction

This patch is cumulative. It includes all previous generally available patches for Talend Administrator Center 7.1.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-2861 [7.1.1] disable "Allow anonymous users to access the server" blocks adding Artifact Task (TAC-12152)
  • TPS-2866 [7.1.1] Jobs could run on non-privileged server in server project authorization in this specific certain scenario (TAC-12213)
  • TPS-2917 [7.1.1] Check/test TAC possibility to work with Nexus 3 without custom scripts (TAC-12222)
  • TPS-2914 [7.1.1] Cannot set Dictionary Service Role when user in a User Group (TAC-12346)
  • TPS-2940 [7.1.1] Migration error during TAC DB migration (TAC-12385,TAC-12354)
  • TPS-2953 [7.1.1] The "executiontaskjobprm" table keeps growing (TAC-12080)
  • TPS-2973 [7.1.1] Cannot create a data preparation user with user role null (TAC-12318)
  • TPS-2981 [7.1.1] task cannot be triggered in execution plan and cannot delete some tasks (TAC-12413,TAC-12453)
  • TPS-2957 [7.1.1] Create trigger using metaservlet doesn't create trigger properly (TAC-12395)
  • TPS-2967 [7.1.1] Can add artifact task to Job Conductor but not to ESB Conductor: Save failed (TESB-24679)
  • TPS-2995 [7.1.1] Nexus 3.15.2 support by TAC (TAC-12490)
  • TPS-3011 [7.1.1] Non-default Artifactory context path, not working (Artifact, shared libs, talend-update, Studio) (TAC-12435)
  • TPS-3089 [7.1.1] Revert changes from TAC-11970 about Context password security fix (TAC-12651)
  • TPS-3085 [7.1.1] Authentication required in jobconductor while connecting to Artifactory (TUP-22182)
  • TPS-3134 [7.1.1] task cannot be triggered in execution plan (TAC-12677)
  • TPS-3163 [7.1.1] Artifactory gives incorrect error in TAC UI (TAC-12748)
  • TPS-3177 [7.1.1] TAC redeploys task multiple times (TAC-12735)
  • TPS-3191 [7.1.1] disable Allow anonymous users to access the artifactory repositories blocks adding Artifact Task (TAC-12834 & TAC-12152)
  • TPS-3200 [7.1.1] Migration check doesn't work in Git project (TAC-12517)
  • TPS-3201 [7.1.1] Call to MetaServlet API/"actionName":"createUser"/ fails with {"error":"Role is required","returnCode":5} while it works in the TAC WebUI (TAC-12729)
  • TPS-3258 [7.1.1] behavior of context path in TAC Artifactory configuration url (TAC-12925)
  • TPS-3256 [7.1.1] Artifact task / Confirm popup Windows / Custom value applied to context parameter(s).. at each change (TAC-12913)
  • TPS-3308 [7.1.1] TAC not balancing the load equally among Virtual jobservers when jobs deployed simultaneously. (TAC-13052)
  • TPS-3205 [7.1.1] Jobs are going into TASK_LAUNCHED mode for very long time (TAC-12828 & TAC-12859)
  • TPS-3463 [7.1.1] Tasks are stuck in running state (TAC-12559)
  • TPS-3475 [7.1.1] Impossible to delete Jobserver from TAC - Null pointer exception error. (TAC-13250)
  • TPS-3556 [7.1.1] Execution Plan Authorization issue (TAC-13515)
  • TPS-3557 [7.1.1] Task hang issue with "PackageNotFoundException: Package with uri 'http://www.talend.org/tdqmatching' not found". (TAC-13544)
  • TPS-3669 [7.1.1] The TAC connection is lost (TPSVC-10197)
  • TPS-3633 [7.1.1] Refactoring and improvements related to TAC synchronization | TAC stuck periodically due to MSSQL db locks created (TAC-13568,TAC-13231,TAC-12828)
  • TPS-3643 [7.1.1] Cannot create Git project from TAC - "Ref refs/remotes/origin/master can not be resolved" (TAC-12660)
  • TPS-3705 [7.1.1] Project authorization changes for users having custom role (TAC-12646)
  • TPS-3710 [7.1.1] Sort order of Artifacts from Nexus (TAC-13726)
  • TPS-3735 [7.1.1] ProcessItemLoader and MessagesUpdater make tac inaccessible from browser page(TAC-13840)
  • TPS-3870 [7.1.1] Support Cache-Control attributes (No-store, No-cache)(TAC-13817)
  • TPS-3910 [7.1.1] SaveEsbTask metaservlet command does not set context as active. (TESB-28187)
  • TPS-4037 [7.1.1] Execution plan is running but tasks are finished (performance issues TAC-13320)
  • TPS-4201 [7.1.1] org.talend.administrator.common.exception.DBException: !!!Cannot flush and commit transaction.!!! (TAC-13204)
  • TPS-4188 [7.1.1] Tooo long time to complete the Job server status check(TAC-13761)
  • TPS-4196 [7.1.1] Roles for download an artifact from Nexus in TAC Job Conductor view (TAC-14316)
  • TPS-4240 [7.1.1] MetaServlet can't update the task or associatePreGeneratedJob which was created from jfrog artifactory (TAC-14402)
  • TPS-4307 [7.1.1] TAC begins to hang / frozen (TAC-14369)
  • TPS-4407 [7.1.1] Sort error on JobConductor (TAC-13674)
  • TPS-4408 [7.1.1] ERROR ExecutionTaskRefresher - org.quartz.ObjectAlreadyExistsException (TAC-14132)
  • TPS-4455 [7.1.1] NPE happens when migration from 6.4.1 to 7.2.1 (TAC-13671)
  • TPS-4473 [7.1.1] TAC resiliency issue with statistics port (TAC-14670)

Prerequisites

Consider the following requirements for your system:

  • Talend Administrator Center 7.1.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-7.1.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.
    • <TOMCAT>/endorsed/talend-url-mvn-1.0.0.jar is not needed any more, you can delete this jar.
    • TPS-3089 reverts changes of the TAC-11970 (TPS-2906). To avoid issues with the patch it's required to cleanup Jobserver work folder <JobServer>/TalendJobServersFiles
    • TPS-3870 provide new configuration property, so if in your configuration.properties file there is no browser.cache.enabled=false property - please add it
  11. Restart the TAC.

    Note:

    • It's recommended to clear browser cache after TAC patch were applied.
    • For TPS-2953, Better to clean the executiontaskjobprm table manually at same time. for example(mysql script): DELETE FROM executiontaskjobprm WHERE executiontaskjobprm_executiontask_e_id IS NULL;