Problems deleting records or users in MDM Web User Interface when using an Oracle database
This article is applicable when using an Oracle database to store the system objects.
Symptoms/DescriptionIn 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.
ResolutionIn 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