Troubleshooting
Problem
You deployed the MREF Maximo Real Estate and Facilities, you created a user FACILITIESADMIN but you are unable to login to the MREF, getting the error: "Cannot Sign into IBM Maximo Real Estate & Facilities as you do not have a valid user".
You have followed the IBM Documentation for Creating users in Maximo Application Suite 9.1 but still not working.
Symptom
You are not able to login the MREF Maximo Real Estate and Facilities Application, getting the error: "Cannot Sign into IBM Maximo Real Estate & Facilities as you do not have a valid user"
Cause
It could be an issue produced during the environment setup. This is not a Product defect.
Diagnosing The Problem
1) You can run a SELECT statement to check the FACILITIESADMIN exists in the table
TRIDATA.T_TRIPEOPLE before running the UPDATE SQL statement.SELECT * from TRIDATA.T_TRIPEOPLE where UPPER(TRIUSERNAMETX) = 'FACILITIESADMIN';
2) You can check if the user is added to "USERMANAGEMENT" group.
Resolving The Problem
1) You can resolve the issue by running a SQL to remove/retire the existing FACILITIESADMIN user record and then they were able to log in.
Solution: updated the "old" FACILITIESADMIN id, and the WF generated a correct FACILITIESADMIN user
The following SQL was for a case we worked for DB2, please adapt to Oracle or other DB if needed:
UPDATE TRIDATA.T_TRIPEOPLE
SET
TRINAMETX = 'deleted user',
TRIFIRSTNAMETX = 'deleted',
TRILASTNAMETX = 'user',
TRIUSERNAMETX = 'DELETED_FACILITIESADMIN',
TRIEMAILTX = NULL,
TRIRECORDNAMETX = 'deleted user',
TRIRECORDNAMESY = 'deleted user',
TRIMODIFIEDBYTX = 'System System'
WHERE UPPER(TRIUSERNAMETX) = 'FACILITIESADMIN';
COMMIT;
SET
TRINAMETX = 'deleted user',
TRIFIRSTNAMETX = 'deleted',
TRILASTNAMETX = 'user',
TRIUSERNAMETX = 'DELETED_FACILITIESADMIN',
TRIEMAILTX = NULL,
TRIRECORDNAMETX = 'deleted user',
TRIRECORDNAMESY = 'deleted user',
TRIMODIFIEDBYTX = 'System System'
WHERE UPPER(TRIUSERNAMETX) = 'FACILITIESADMIN';
COMMIT;
2) Add the user to "usermanagement" group. If a user needs administrative permissions to create other users, you must assign them to the USERMANAGEMENT security group. For more information, see Creating administrators for user management.
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFDAS","label":"IBM Facilities and Real Estate Management on Cloud (TRIRIGA)"},"ARM Category":[{"code":"a8m0z000000cxW6AAI","label":"Maximo Application-\u003EUsers"}],"ARM Case Number":"TS020275568","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]
Was this topic helpful?
Document Information
Modified date:
23 September 2025
UID
ibm17245933