OBM starting gets stuck at Configuring UCMDB step

  • Document ID:KM03771888
  • Creation Date:15-Jan-2021
  • Modified Date:15-Jan-2021
    • Micro Focus Products:
      operations bridge manager

Archived Content: This information is no longer maintained and is provided "as is" for your convenience.

Summary

OBM starting gets stuck at Configuring UCMDB step

Error

From error.log files, I found some error message which mentions that there is a duplicated entry within RTSM HA_REVISIONS table:

Caused by: org.postgresql.util.PSQLException: ERROR: could not create unique index "pk_ha_revisions"

Fix

we can delete the duplicated by following:
=
WITH cte AS (select *, ROW_NUMBER() OVER( PARTITION BY MODEL_ID, REVISION ORDER BY MODEL_ID,REVISION) row_num From ha_revisions) DELETE FROM cte WHERE row_num > 1;
=