Issue Summary

Insight UI displays random objects values or it does not display all objects values if OTA_POSITION is duplicated.
Insight AO_8542F1_IFJ_OBJ_TYPE_ATTR table, there is a OTA_POSITION column for the attributes and it has not been unique within the object type (which it should be)

This is reproducible on Data Center: yes
It affects to all Insight versions as of today (9.1.11)

Steps to Reproduce

Unable to reproduce the issue but refer to Actual Results to find out how to identify the wrong object attribute.

Expected Results

Insight UI should display valid objects values

Actual Results

Insight UI displays random objects values. A way to determinate it, would be as follows:

1. Identify the Object Type where Insight display either missing values or incorrect object values
2. Run the below query in Jira database. Replace ? for the Object Type Id

   SELECT "ID","NAME","OTA_POSITION" 
   FROM "AO_8542F1_IFJ_OBJ_TYPE_ATTR" 
   WHERE "OBJECT_TYPE_ID" = ?
   order by "OTA_POSITION" asc
   

Below is just an example where OTA_POSITION is duplicated for some Object attributes (Display, Organisational Unit)

Workaround

1. Please move one of the Attributes where OTA_POSITION is duplicated (any Attribute up or down).
2. Run an Insight Clean re-Index.

   Jira > Administration > Manage Apps > Indexing Insight > Clean re-index

3. The order should get reconstructed and the issue should go away.