SAP ABAP Message Class SMI_GENERAL Message Number 055 (Delete cascade failed)
Hierarchy
SAP_BS_FND (Software Component) SAP Business Suite Foundation
   CA-EPT-SMI (Application Component) Social Media Intelligence Foundation
     BS_SOMI_DATA_MODELS (Package) Datta Models for Social Media Intelligence
Attribute
Message class SMI_GENERAL  
Short Description    
Message Number 055  
Documentation status       Space: object requires documentation
Authorization check Error Message      
Changed On 20140121   
Message Text
Delete cascade failed
Help Document

Diagnosis

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

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

Procedure

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 Administration

History
Last changed on/by 20140121  SAP 
SAP Release Created in   747