Administrators are unable to re-create a previously deleted table with same name and same CMDB extended table (TPP extension model) of the old one.


Steps to Reproduce


  1. Navigate to System Definition > Tables.
  2. Create a new table:
    • Extends table = Computer [cmdb_ci_computer]
    • Label = CmdbTable
  3. Verify the table exists in the instance database and the CMDB extension is in place.
  4. Select the table just created and click Delete.
  5. Verify the table is not present in the schema anymore.
  6. Recreate the table by repeating steps 1-2.

The table creation process does not complete, and the shown label is Computer instead of CmdbTable. Orphaned records for the first table created are present in the [sys_storage_alias] and [sys_metadata] tables.


This issue is fixed in Madrid. Please review the Fixed In section to determine the latest available patch your instance can be upgraded to.

As a workaround to prevent the issue until an upgrade is possible, instead of using the 'Delete' UI Action, use the TableUtils API's described in the TableUtils - Global documentation pages.

In order to remove the orphaned records, open an incident with ServiceNow customer support.

Related Problem: PRB1097705

Seen In

Fuji Patch 10
Fuji Patch 7
Fuji Patch 9 Hot Fix 1
Geneva Patch 4
Geneva Patch 6
Geneva Patch 6 Hot Fix 2
Helsinki Patch 1
Jakarta Patch 6a

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-08-14 09:03:15