nis_server probe errors stopped population of USM groups (no servers populating group)

Document ID : KB000047844
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms


Why do I get a number of groups in USM where the server count does not populate?

What is seen here is where some (not always all) groups have (0) Servers within them even though you can go to the settings of the group and reapply to see all server. Then, once the nis_server reruns its queries, the group(s) go back to (0) count.

Example nis_server errors:

Mar 27 17:44:28:518 FATAL [Thread-2, nis_server] Unhandled exception:
Mar 27 17:44:28:519 FATAL [Thread-2, nis_server] java.lang.NullPointerException
at com.nimsoft.probe.service.nis.DynamicGroup.constructMetaWhereClause(DynamicGroup.java:47)
at com.nimsoft.probe.service.nis.DynamicGroup.constructMetaWhereClause(DynamicGroup.java:48)
at com.nimsoft.probe.service.nis.DynamicGroup.updateGroup(DynamicGroup.java:64)
at com.nimsoft.probe.service.nis.DynamicGroupEngine.UpdateGroups(DynamicGroupEngine.java:66)
at com.nimsoft.probe.service.nis.Probe.callbackAutomaticGroups(Probe.java:214)
at com.nimsoft.probe.service.nis.Probe$1.run(Probe.java:146)

Mar 27 17:50:15:960 ERROR [Thread-5, com.nimsoft.nimbus.NimProbeBase] Error when running on timer method in separate thread. Reason is (1) error, Not able to callback for timer callbackAutomaticGroups.300000. Reason is java.lang.NullPointerException





Solution


It?s very likely that something is referencing a group or parent ID that doesn?t exist. There are plans to have this resolved from a code perspective. In the meantime, you can check your database for illegal parent group references. Two SQL queries below will allow you to do this:?
?
--Look for illegal parent group ID's first:

SELECT * from cm_group WHERE pgrp_id NOT IN (SELECT grp_id from cm_group) AND pgrp_id != 0

-- Look for an illegal cs_id

SELECT * from cm_group_member WHERE cs_id NOT IN (SELECT cs_id from cm_computer_system)

Then if they exist, you need to remove (delete) those groups and members from the database.

Then cold start the nis_server (Deactivate-Activate)


keywords: USM group groups disappear disappearing not populate populating
?