Error After Changing Person Status to INACTIVE

Troubleshooting

Problem

Cannot set a person record to inactive as an error message indicates the person record is in a group, but it is not.

Symptom

Error: "BMXAA3084E – Failed to deactivate the person because he/she is assigned on a person group"

IBM Logo

Cause

This is in an upgraded database where labor records have not been upgraded properly.

Resolving The Problem

STEPS:

1. Query the persongroupteam table for the person record that cannot change status:

select * from persongroupteam where respparty = 'LABESANS'

2. Run delete statement to remove the person from the person group

delete from persongroupteam where respparty = 'LABESANS'

Once the person record has been removed from the person group via the backend, the system should allow changing the person record to INACTIVE status.

*Cross-reference information*
Product	Platform	Version
IBM Maximo Asset Management	Platform Independent	7.1, 7.1.1, 7.1.2, 7.2, 7.2.1, 7.5
Maximo Asset Management Essentials	Platform Independent	All Versions
Maximo Asset Management for IT	Platform Independent	All Versions
Tivoli Change and Configuration Management Database	Platform Independent	All Versions
Tivoli Service Request Manager	Platform Independent	All Versions

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"People","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1;7.1.1;7.1.2;7.2;7.2.1;7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWK4A","label":"Maximo Asset Management Essentials"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Was this topic helpful?

Document Information

More support for:
IBM Maximo Asset Management

Software version:
7.1, 7.1.1, 7.1.2, 7.2, 7.2.1, 7.5

Document number:
151131

Modified date:
17 June 2018

UID

swg21469133

IBM Support

Tips