57 views

Symptoms


  • A column (from a custom table) deletion transaction was cancelled before the transaction completed.
  • The column is now inaccessible but still appears in some places.

Release


Jakarta+ 

Cause


  • Deleting a column triggers cascade deletions of important metadata records.
  • Since this process was interrupted, these metadata records did not get fully removed.

Resolution


  1. In order to fully remove the column, the deletion process must be initiated again.
  2. Since this process originates from the sys_dictionary record, that record needs to be re-imported via XML or re-created, and then deleted again.
  3. Verify that the column no longer appears in Tables & Columns and all metadata is cleaned up.

 

Article Information

Last Updated:2018-06-11 08:15:48
Published:2018-06-11