How To Fix SMI_GENERAL055 - Delete cascade failed

SAP Error Message - Details

• Message type: E = Error

• Message class: SMI_GENERAL -

• Message number: 055

• Message text: Delete cascade failed

What causes this issue?

There is an inconsistency in the index table $TA_INDEXVOICEOFCUST due to
which altering the table to activate delete cascade functionality is
terminated.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

This inconsistency can be due to:
Records deleted from the SOCIALDATA table but the corresponding entries
still exist in the $TA_INDEXVOICEOFCUST table

System Response

How to fix this error?

You can perform any of the following step to remove the inconsistency
between tables:
Manually remove the inconsistency in the index table
$TA_INDEXVOICEOFCUST by removing the related records. If a record is
deleted from the SOCIALDATA table, the corresponding entries for this
record in the $TA_INDEXVOICEOFCUST index table should also be deleted
.
Delete the index INDEXVOICEOFCUST and index table $TA_INDEXVOICEOFCUST
and run the report SMI_TAINDEX_ON_SOCIALPOSTTEXT to recreate index and
activate delete cascade functionality.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.