IBM Support

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.

[{"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"}}]

Document Information

Modified date:
17 June 2018

UID

swg21469133