TPS-4339 (cumulative patch) - 7.1

Introduction

This patch is cumulative. It includes all previous generally available patches for MDM 7.1.1

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

Fixed issues

This patch contains the following fixes:

• TPS-3003 [7.1.1] [RestAPI] GET /data/{containerName}/{type}/{id} fails with HTTP 500 (TMDM-13124)
• TPS-3004 [7.1.1] Error when deploying Model : Duplicate class/entity mapping org.talend.mdm.storage.hibernate.X_insuredAddressPersonType (TMDM-13186)
• TPS-3080 [7.1.1] tMDMOutput / Is Update / Return Keys : java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 if nothing to update (TMDM-13190)
• TPS-3104 [7.1.1] java.lang.RuntimeException: Unable to load the item after items deletion by batch job (TMDM-13229)
• TPS-3114 [7.1.1] MDM REST API PUT /data/{containerName}/query : select where eq does not work when non ascii characters (TMDM-13371)
• TPS-3115 [7.1.1] Data not commited when AutoCommit not checked in tMDMConnection even if tMDMCommit called (TMDM-13414)
• TPS-3135 [7.1.1] [REST] PUT /data/{containerName}/query : operators eq / contains / startsWith / full_text do not return the same result (TMDM-13444)
• TPS-3143 [7.1.1] [REST] GET /data/{containerName}/{type}/{id} with datetime fails when swing = BEFORE (TMDM-13490)
• TPS-3148 [7.1.1] Error when deploying model : Caused by: org.hibernate.DuplicateMappingException: Duplicate class/entity mapping org.talend.mdm.storage.hibernate.X_addressPersonOrOrganisationAbsType (TMDM-13483)
• TPS-3398 [7.1.1] tMDMRestinput fails: Internal server error:Error occurred during result writing with full_text where (TMDM-13266)
• TPS-3409 [7.1.1] Wrong value returned by MDM REST API select query / contains when 2 fields with same name in 2 different entities (TMDM-13918)
• TPS-3512 [7.1.1] db migration tool failing - alternative method supportability (TMDM-12751)
• TPS-3536 [7.1.1] Wrong behavior of "Set the Roles with Write Access"/"Set role recursively" when Studio Internationalisation : Local Language = Français (TMDM-14122)
• TPS-3558 [7.1.1] No Foreign Key picker (FK Picker) in the Search Bar in MDM Web UI (TMDM-14007)
• TPS-3566 [7.1.1] Backport operands isNull and isEmpty in REST API Query language (TMDM-14221)
• TPS-3569 [7.1.1] Talend MDM timeout cannot be increased with IAM enabled (TMDM-12908)
• TPS-3618 [7.1.1] Wrong result returned by REST API PUT /data/{containerName}/query (TMDM-14236)
• TPS-3720 [7.1.1] [REST] PUT /data/{containerName}/query : issue when sort & paging (order_by & (start limit) ) (TMDM-14399)
• TPS-3751 [7.1.1] Error in mdm.log: Exception [com.amalto.core.delegator.IXtentisWSDelegator] Error during save. java.util.ConcurrentModificationException (TMDM-13195)
• TPS-3639 [7.1.1] tMDMRollback somtimes let transactions "opened" (TMDM-14289)
• TPS-3686 [7.1.1] AUTO_INCREMENT value for NOT Primary Key reset to 0 after MDM restart (TMDM-14192)
• TPS-4004 [7.1.1] [REST]: PUT /data/{containerName}/query : order_by on a Foreign Key (FK) : result not sorted (TMDM-14546, TMDM-13569, TMDM-14257)
• TPS-4077 [7.1.1] Talend MDM Foreign Key Item not set to value entered in the Web UI (TMDM-14625)
• TPS-4226 [7.1.1] [REST] PUT query with multiple joins does not return correct value (TMDM-14687)
• TPS-4339 [7.1.1] Only 2 search operators : Is equal to / Is empty or null available when the Foreign Key has a "Custom Simple Type" (TMDM-14743)

Prerequisites

Consider the following requirements for your system:

• Talend Studio 7.1.1 must be installed.
• Talend MDM Server 7.1.1 must be installed.

Installation

PATCH INSTALLATION NOTES FOR TALEND MDM SERVER 7.1.x

PRE-INSTALLATION

• Stop the MDM server
• Create a patch directory (eg: C:\MDM_Patch)
• Unzip patch file you receive from support into this directory
• Create a backup directory (eg: C:\MDM_Backup)

WEB APPLICATION REPLACEMENT

• Copy folder <MDM_SERVER_HOME>/apache-tomcat/webapps/talendmdm into the backup directory
• Replace it with the folder talendmdm contained in patch directory

POST-INSTALLATION

• Restart the MDM server
• Clear browser cache on clients

PATCH INSTALLATION NOTES FOR TALEND MDM STUDIO & COMMAND-LINE 7.1.x

PRE-INSTALLATION

• Close the Talend Studio
• Create a backup directory (eg: C:\MDM_Backup)

PLUGINS REPLACEMENT

Copy files/folder below into the backup directory

• <TALEND_STUDIO_HOME>/plugins/org.talend.mdm.workbench_7.1.1.20181026_1147
• <TALEND_STUDIO_HOME>/plugins/org.talend.designer.components.tomprovider_7.1.1.20181026_1147/components/tMDMOutput
• <TALEND_STUDIO_HOME>/plugins/org.talend.designer.components.tomprovider_7.1.1.20181026_1147/components/tMDMWriteConf

Replace them from corresponding files contained in patch directory

POST-INSTALLATION

• Restart the Talend Studio