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:
- Identify the Object Type where Insight display either missing values or incorrect object values
- 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)
| 843 |
Building |
0 |
| 844 |
Zone |
1 |
| 846 |
Display |
2 |
| 2004 |
Organisational Unit |
2 |
| 847 |
Thinclient |
3 |
| 848 |
Docking Station |
4 |
Workaround
- Please move one of the Attributes where OTA_POSITION is duplicated (any Attribute up or down).
- Run an Insight Clean re-Index.
Jira > Administration > Manage Apps > Indexing Insight > Clean re-index
- The order should get reconstructed and the issue should go away.
Bug
Medium
Page Failed to load