Troubleshooting
Problem
In Manage, open Administration application (Work Center) and try to open the API Keys tab, it does not show the information. It keeps loading but it does not end.
Cause
There are two possible causes:
1.) Permissions are not set correctly in the security groups application
2.) The apikeytoken table is corrupted
2.) The apikeytoken table is corrupted
Resolving The Problem
1.) Check whether permissions are properly granted:
Go to Security > Security Groups. Search for MAXADMIN group.
On the Applications tab under Applications, filter for Description=Administration and Application Type=Work Center.
Click Object Structure Authorizations (in some environments you need to list actions to get this option):
Grant Delete, Insert, Read, Save, as well as "Sigoption to control the visibility of SQL clause in apimeta and querymeta" for MXAPIAPIKEY.
Save the changes, log out, and log back in. Then, test again.
If the permissions are granted and you still see the issue, maybe apikeytoken table is corrupted:
2.) Truncate APIKEYTOKEN table in Manage database:
TRUNCATE TABLE APIKEYTOKEN IMMEDIATE;
COMMIT;
Re-create the apikeys by running the commands below from maxinst pod:
cd /opt/IBM/SMP/maximo/tools/maximo
./insertapikey.sh -v'${MANAGE_APIKEY}' -m'prop:mxe.int.dfltuser'
./insertapikey.sh -v'${MANAGE_APIKEY}, O=cert-manager' -m'prop:mxe.int.dfltuser'
./insertapikey.sh -v'${HEALTH_APIKEY}' -m'prop:mxe.MASUserSyncAgentUser'
./insertapikey.sh -v'${HEALTH_APIKEY}, O=cert-manager' -m'prop:mxe.MASUserSyncAgentUser'
./insertapikey.sh -v'${PMI_APIKEY}' -m'prop:mxe.PMIUser'
./insertapikey.sh -v'${PMI_APIKEY}, O=cert-manager' -m'prop:mxe.PMIUser'
./insertapikey.sh -v'${PMI_APIKEY_NEW}, O=cert-manager' -m'prop:mxe.PMIUser'
./insertapikey.sh -v'${PMI_APIKEY_NEW}' -m'prop:mxe.PMIUser'
./insertapikey.sh -v'${EU_APIKEY}' -m'prop:hputilities.health.user'
./insertapikey.sh -v'${EU_APIKEY}, O=cert-manager' -m'prop:hputilities.health.user'
./insertapikey.sh -v'${EU_APIKEY_NEW}, O=cert-manager' -m'prop:hputilities.health.user'
./insertapikey.sh -v'${EU_APIKEY_NEW}' -m'prop:hputilities.health.user'
Restart Manage pod.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m3p000000LPPOAA4","label":"Work Centers-\u003EAdministration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
28 December 2022
UID
ibm16851991