"Check for data inconsistencies in DB upgrade" NSX precheck error for VCF 9 upgrades - "MP Objects found in DB" and NSX Manager to Policy objects promotion fails with error Config Translation Failed

Products

• VMware NSX

Issue/Introduction

• During upgrade to VCF / NSX 9 prechecks will fail with errors similar to the below observed in NSX or SDDC:
  
  UC MP - Check for data inconsistencies in DB 

Found data inconsistencies: MP Objects found in DB before promotion for tables : <table_name, table_name, etc>, please perform Manager to Policy promotion or delete the MP objects and retry the prechecks. Delete any Bridge firewall section/rule if they exist and then retry the prechecks. For more details, please refer to - https://knowledge.broadcom.com/external/article/385606

• In General Promotion, the operation to promote manager objects to policy in the NSX UI fails with the following error:
  
  

Environment

VMware NSX 4.2.x

Cause

This error occurs as a result of a stale ServiceConfig object that is still present in NSX. Prior to upgrade any Manager objects must be either removed or migrated to Policy objects. This precheck purposefully blocks the upgrade to allow the resolution steps to be followed.

Resolution

This is a known issue impacting VMware NSX

Workaround:

1. Delete the stale ServiceConfig using the API call:
   DELETE https://<nsxmanager>/api/v1/service-configs/UUID
2. Verify there is no production DFW policy currently using this ServiceConfig.
3. Retry the promotion — after cleanup, restart the MP→Policy migration from the UI.