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.
TPP Migration on upgrade can leave NULL sys_class_path values in partition tables - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • TPP Migration on upgrade can leave NULL sys_class_path values in partition tables
KB0715417

TPP Migration on upgrade can leave NULL sys_class_path values in partition tables


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

Description

The upgrade from a pre-Jakarta instance to J or later migrates the CMDB to "TPP". This creates partition tables such as cmdb$par1 where the sys_class_path column can be left null, causing problems in a variety of CMDB list views. This is due to caching issues during the migration, and depends on exactly what queries get executed concurrently during the migration process.

 

Steps to Reproduce

The behaviour is impossible to reproduce consistently. The problem can occur frequently on production instances, but not on sub-prod. Even upgrading to Jakarta or later, the problem mostly will not occur, as it will need to involve a cache rebuild happening at exactly the wrong time.

  • Look directly in the database for how many records in the tables cmdb$par1, $par2, etc. have a NULL sys_class_path.
  • If working with a command-line client like "sudo snow query", remember to escape the $ symbol.

For example:
sudo snow query mycustomer "SELECT COUNT(*) FROM cmdb\$par2 WHERE sys_class_path IS NULL"

Workaround

This issue is fixed in all currently supported versions. There is no workaround applicable. Please review the Fixed In section to determine the latest available patch your instance can be upgraded to. 

If the affected instance can not be upgraded yet, open an Incident with ServiceNow Customer Support and request to run the relevant cmdb sync script. This script is safe to run on a production instance presenting the problem, although there is a small performance cost (akin to rebuilding the schema cache), therefore it should be executed outside business hours.

 


Related Problem: PRB1252503

Potentially Seen In

There is no data to report.

Fixed In

Jakarta Patch 9
Kingston Patch 6
London

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.