Integrity Checker error BMXAA0455E

Technote (troubleshooting)


Problem(Abstract)

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.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Asset Management for IT Not Applicable
Systems and Asset Management Tivoli Change and Configuration Management Database
Systems and Asset Management Tivoli Service Request Manager

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Upgrade Integ Checker

Software version:

6.2, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 7.1, 7.1.1, 7.5

Operating system(s):

Platform Independent

Reference #:

1615216

Modified date:

2014-09-19

Translate my page

Machine Translation

Content navigation