Troubleshooting
Problem
If the Refresh Token is larger than 1024 characters, you get a database Error 8152 ( BMXAA4211E - Database error number 8152 has occurred when operating on INBOUNDCOMMCFG
Cause
This is caused by the Refresh Token Field length not being Large enough to accept the entered value.
Diagnosing The Problem
Run the following Queries on your Database:
Select oauthaccesstoken, oauthaccesstokendexpdate from INBOUNDCOMMCFG;
They both will most likely be NULL
Select LENGTH from MAXATTRIBUTECFG where OBJECTNAME='INBOUNDCOMMCFG' and ATTRIBUTENAME='OAUTHREFRESHTOKEN';
Review the number of characters there are in the Refresh Token and Increase the Length of the OAUTHREFRESHTOKEN field.
Resolving The Problem
Go to System Configuration> Platform Configuration>Database Configuration
Turn on AMDIN MODE
Bring up the INBOUNDCOMMCFG Object
Go to the Attribute Tab and bring up the OAUTHREFRESHTOKEN Attribute
Change the length and Save
Apply Configuration Changes (Save a Backup of your Database)
You now should be able to Save the Refresh Token as it will now accept the Number of characters due to the increase in length.
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":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbA4AAK","label":"System Administration->Database Configuration"}],"ARM Case Number":"TS009365018","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
More support for:
IBM Maximo Asset Management
Component:
System Administration->Database Configuration
Software version:
All Versions
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows, z/OS
Document number:
6594809
Modified date:
14 June 2022
UID
ibm16594809
Manage My Notification Subscriptions