Troubleshooting
Problem
Integrity Checker reports this error, followed by a list of user ids: BMXAA0443E - ERROR -- BMXAA0455E - The following users should be removed from Maximo because they have no MAXIMO privileges:
Symptom
Obsolete/orphan user ids are defined in Maximo, but user id has no access to or privileges in Maximo.
Cause
Users are defined in table MaxUser, but are not associated with any Maximo group in table GroupUser. Any user not associated with a group has no privileges in Maximo.
Diagnosing The Problem
To verify these user ids are orphans - that is, not defined in table GroupUser, execute this query:
Select userid From maxuser Where Not Exists (Select * From groupuser Where userid=maxuser.userid)
This query should return the same list of users that follows the BMXAA0455E error message.
Resolving The Problem
Review the list of users to verify that they are obsolete and can be removed. To drop the users from table MaxUser:
Delete From maxuser Where Not Exists (Select * From groupuser Where userid=maxuser.userid)
Run Integrity Checker (report-mode only) again to verify the error is resolved.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21615216