Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Has CMDB re-parenting and flattening/TPP migration happened? - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Has CMDB re-parenting and flattening/TPP migration happened?
KB0720689

Has CMDB re-parenting and flattening/TPP migration happened?


1025 Views Last updated : Apr 8, 2025 public Copy Permalink
KB Summary by Now Assist

Issue

Table of Contents

  • Introduction
  • Did Geneva Re-Parenting happen?
  • Did Jakarta TPP Migration happen?

Introduction

Since the introduction of N-2 and N-1 support policies all instances should have had both these migrations happen automatically. Some Oracle database and on-premise customers may have been given the option to defer this, and some performance issues may also have delayed this on a few instances, however for the sake of supportability all should now aim to migrate. If you were not one of those exceptions then something may have gone wrong in the upgrades.

VersionApplication TablesSQL TablesExtended Table/Flattening Method
<= Fuji  cmdb_ci, and all extending tables cmdb_ci, cmdb_ci_hardware, cmdb_ci_computer, etc.Table-Per-Class
>= Geneva  cmdb, and all extending tables, including cmdb_ci
A 'cmdb' table was slotted in above 'cmdb_ci' to become the new parent table.
 cmdb, cmdb_ci, cmdb_ci_hardware, cmdb_ci_computer, etc.Table-Per-Class
>= Jakarta  Unchanged cmdb + cmdb$par1 [ + cmdb$par2 ]Table-Per-Partition

Some CMDB feature-related code in more recent versions expects this to have happened. Unexpected behaviour can in theory occur if this is not done. Please open a Case in HI with Customer Support if you notice this has not happened in your instance.

 

Did Geneva Re-Parenting happen?

If cmdb_ci lists lots of records, and cmdb lists none, or doesn't even load a list view, then Geneva Re-Parenting has probably not happened.

This can be confirmed by looking in the sys_db_object table:

  1. Open a list for the 'sys_db_object' table
    /sys_db_object_list.do
  2. Filter on Name is cmdb or cmdb_ci
  3. If the cmdb_ci record shows Extends Table = Base Configuration Item, then Re-Parenting has happened.

Did Jakarta TPP Migration happen?

This can also be confirmed by looking in the sys_db_object table:

  1. Open a list for the 'sys_db_object' table
    /sys_db_object_list.do
  2. Filter on Name is cmdb or cmdb_ci
  3. If the cmdb record's Extension Model = Table per Partition, then TPP Migration has happened.

Release

Post Geneva and/or Jakarta.

 

Related Links

Multiple apparently duplicate Dictionary Records existing for the same CMDB field is a sign that TPP Migration has happened. This is part of the TPP design.

You may or may not see a sys_db_object record for the additional partition table named cmdb$par1 after TPP migration. This is not there on some instances, and does not cause any functional issues.

Ghost/Orphan records are only possible with Table-Per-Class. TPP migration will delete any existing orphan records, where the sys_id is missing from the top level cmdb table.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.