Environment

Such issue can be encountered in UCMDB version 2018.0x or higher
 

Situation

Getting error message: "Property [key=end2_display_label] doesn't exist in CmdbPropertiesImpl" when attempting to open the change report in the UI.

Resolution

This issue has been addressed and fixed in UCMDB 24.2.

Troubleshooting steps to follow:

Run the findunboundhistorytables and deleteunboundhistory commands in the JMX console.

• Use the following methods:
  • MBean: UCMDB:service=History DB Services
  • Method: findUnboundHistoryTables
  • Method: deleteUnboundHistoryTables

If any tables are found in the findunboundhistorytables query, execute the deleteunboundhistorytables query in the JMX console. Please ensure you backup the database before performing this action.

If you do not find any tables in the query findunboundhistorytables in the JMX console, or if the issue persists after taking action with deleteunboundhistory, please follow these steps:

1. StopHistoryDB (using the JMX console).
2. StartHistoryDB (using the JMX console).

Please note that this approach will result in the loss of history DB data (the default setting is to retain data for 3 months). If stopping and starting the historyDB does not resolve the issue, try restarting the uCMDB services and attempting the steps again.