Skip to main content

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

Availability-noteDeprecated
Information noteDeprecation: Talend Master Data Management (MDM) is deprecated and will reach end of life on December 31, 2024. For more information on migrating from Talend MDM, contact Talend Professional Services.

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here