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

[sachin_namjoshi]

Below is the sample script

var maxLevel = parseInt(gs.getProperty('NotifyAffectedCI.max_rel_level'));

var maxCis = parseInt(gs.getProperty('NotifyAffectedCI.max_cis', '100000'));

// max_events determines how many cis may be tracked in the noNotify array

// increasing to a very large number ( > ~100K) might use too much memory



var impactedAccounts = new Utility();

var returncount = impactedAccounts.findImpactedAccounts('sys_id');

gs.print(returncount);

 

findImpactedAccounts: function (parentCI) {

        var returnCount = 0;
    //get relationship where CI is the parent
    var getChildren = new GlideAggregate('cmdb_rel_ci');
    getChildren.addQuery('parent', parentCI);
    getChildren.addAggregate('COUNT', 'child.sys_class_name');
    getChildren.addAggregate('COUNT', 'child');// i think this is needed to access the value in glideaggregate
    getChildren.query();
    while (getChildren.next()) {//this is now a grouping of childred by class
        if (getChildren.child.sys_class_name == 'u_account') {
            returnCount += getChildren.getAggregate('COUNT','child.sys_class_name');
        } else {
            // if its not a account type... check for children
            // countAccount = countAccount + this.findImpactedAccounts(getChildren.child);
            this.findImpactedAccounts(getChildren.child);
        }
    }
    return returnCount;
},

Regards,

Sachin

[Kishore32]

Hello Sachin,

I added my custom read role to cmdb_rel_ci table but still issue exists. Even if i update the settings on CI grid by setting level still i'm seeing issue. 

What else may cause this issue?

Mahak,

i set the settings for CI relations grid as follows. 

I tried with all levels but not working.

Thanks,

Kishore

[MS]

Did you get any solution for this issue @Kishore ?

I am facing the same issue for few CI's. Please suggest as to what steps we need to take.

[Kishore32]

I didn't found any solution for the same. If you come across please let me know.

Thank you

[MS]

Not yet