CI relations are keep on loading for test user/non admin users.

[Kishore32]

Hello,

I'm having an issue in Business Application form. CI relations is keep on loading for test user with read access(created a role by me) for business application table.

I added created read access role to pre-defined cmdb_rel_ci table acl's and also added to other referenced table acl's(tables: cmdb_ci and cmdb_rel_type tables). Still i'm not seeing the issue got resolved. Please help me on this how can i resolve this issue.

Here below is the screen shot

Please let me know if more details needed.

Thank you

[Mahak2]

Hello Sachin and Kisore,

I have found something may be this is causing the extra time to Load relationships for some users.

Every Relationship Related Item is having the filter to view the level of relationships,if the level is higher for ex Level 5 it will take more time and if the level is lower it will take less time to load.

I don't know whether it is right or not but when i have tested for users this logic is working for both admin and non admin users.

Please let me know if i am wrong .

Regards,

Mahak

[sachin_namjoshi]

Your solution will work for CI relationships which are less than 5 levels.

We have more than million active CIs and relationships in our instance and relationship levels go beyond 15 levels and we were getting same issue.

I had to implement recursive function custom logic to show this deep level of relationships till 15th level.

Regards,

Sachin

[Mahak2]

Hello Sachin,

So after implementing that all the relationships till 15th level is loading without taking any time ?

As for L5 relationships ,it will take approx 1min to load so i can imagine for L15 Relationships.

Please do share your feedback.

Thanks ,

Mahak

[sachin_namjoshi]

After implementing custom solution, relationships are loading faster till level 15th.

Performance is much better than OOB implementation.

Regards,

Sachin

[Mahak2]

Hello Sachin,

can you please share your customization script.

It would be very helpful.

Regards,

Mahak