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

author
Talend Documentation Team
EnrichVersion
6.4
6.3
6.2
6.1
6.0
EnrichProdName
Talend MDM Platform
Talend Data Fabric
task
Administration and Monitoring
EnrichPlatform
Talend MDM Web UI

Problems deleting records or users in the Talend MDM Web UI when using an Oracle database

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 UI. This article describes how to resolve these issues with the aid of a script.
Environment

This article applies to all versions of Talend MDM from 5.3.2 onwards, when using an Oracle database to store the system objects.

Symptoms/Description

In the Talend MDM Web UI, 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