IBM Support

Corrupted APIKEY after upgrade MAS to 8.8

Troubleshooting


Problem

During the upgrade of Manage to 8.4, the APIKEY values in apikeytoken table can become corrupted, affecting the integration and User synchronization process between MAS and Manage.

Symptom

In the usersync pod log, an error can be seen:
  • 2022-09-12 05:17:34,417 usersync-agent-manage INFO [nexertest maxadmin] Sync user response: r.status: 400, r.text: Error 400: BMXAA9549E - The API key token is invalid. Either the token may have expired or the token has been revoked by the administrator.
Using the OLSC/REST api with an apikey, an error is returned from the client request:
  • Error: BMXAA1649E - A programming error resulted in a null pointer exception

Resolving The Problem

Truncate APIKEYTOKEN table in Manage database:
TRUNCATE TABLE APIKEYTOKEN IMMEDIATE;
COMMIT;
Next, re-create the apikeys by running the commands shown in 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":"a8m50000000CbFGAA0","label":"Integration"}],"ARM Case Number":"TS010887777","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.8.0"}]

Document Information

Modified date:
17 October 2022

UID

ibm16829527

Page Feedback