Analyze Unique field Database validation Bug

[freddyDOTCMS]

Parent Issue

No response

Problem Statement

We are currently experiencing issues with a Customer due to recent changes in the database's unique fields validation. When they attempt to delete a duplicate Contentlet, they encounter the following error:

Log:
[19/02/25 16:54:26:077 GMT] ERROR ajax.ContentletAjax: Invocation error on method: com.dotcms.contenttype.business.uniquefields.extratable.UniqueFieldsTableCleaner#cleanUpAfterDeleteContentlet, for event: com.dotmarketing.business.DeleteContentletVersionInfoEvent@63bdd55d

Steps to Reproduce

Just try to delete the duplicated Contentlet, I am not able to reproduce this error locally for now

Acceptance Criteria

Find out what is happening in the Customer environment and create a issue to fix the problem

dotCMS Version

Customer version

Proposed Objective

Core Features

Proposed Priority

Priority 1 - Show Stopper

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

No response

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response

[freddyDOTCMS]

PR: #31444