Problems deleting records or users in MDM Web User Interface when using an Oracle database - 7.1

EnrichVersion
7.1
EnrichProdName
Talend Data Fabric
Talend MDM Platform
EnrichPlatform
Talend MDM Web UI
task
Administration and Monitoring

Problems deleting records or users in MDM Web User Interface when using an Oracle database

Subscription
Missing Foreign Key indexes may cause issues when you try to delete records from the recycle bin or users from the user manager in the Talend MDM Web User Interface. This article describes how to resolve these issues with the aid of a script.
Environment

This article is applicable when using an Oracle database to store the system objects.

Symptoms/Description

In the Talend MDM Web User Interface, if you try to delete numerous records from the recycle bin or several users from the user manager, you may find that only one record or user is deleted. This happens if the related Foreign Key indexes are missing, and to resolve the issue these indexes must be created manually.

Resolution

In order to create the missing Foreign Key indexes, you must adapt and then run a SQL script that is available in <JBOSS_HOME>/bin/dbtools/sqls/ora_create_missing_FK_indexes.sql .

Before running the script, you must first edit it to replace {TableSpaceName} with the real name of the table space that the MDM system container is using for your Talend MDM server installation.

Related Jira Issues

TMDM-6844