IBM Support

Integrity Checker reports GL Too Small Error

Troubleshooting


Problem

Integrity Checker reports the following cryptic error message: BMXAA0443E -- ERROR -- configdb#GLTOOSMALL The error message is followed by a list of columns.

Symptom

The error code GLTOOSMALL is not being translated to an error message. The error should read:
"The following attributes are defined as GL attributes, but the character length is too short:"

The error message is followed by a list of columns.

Cause

A Maximo-specific datatype is 'GL'. All columns defined as type GL contain GL Account Codes. All GL Account codes, and GL columns, must be the same character length. The columns listed in the error message are too short to contain a full GL Account Code.

Diagnosing The Problem

To determine the proper length of a column defined to be datatype GL, execute this query:

Select length From maxattribute Where objectname='CHARTOFACCOUNTS' And attributename='GLACCOUNT;

Resolving The Problem

Use the Database Configuration application to set the length of every column listed in the error message to the results of the above query.

To add the error message to your database, apply one of attached SQL scripts AddMaxMessage.xxx that is appropriate for your database platform.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Upgrade Integ Checker","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1;7.5","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":"Not Applicable","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"}},{"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":"SSWK4A","label":"Maximo Asset Management Essentials"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"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

swg21633020