Notifications

126 views

Description

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.

Workaround

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

Eureka Patch 13 Hot Fix 2
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
Jakarta Patch 6a
Kingston
Madrid

Fixed In

Madrid

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-23 12:03:18
Published:2019-05-23